Power Pages Web Templates: Working with Liquid and FetchXML

As someone in love with SPFx web parts, Power Pages web templates felt like something I'd want to try. What we're building: Analytical dashboard tiles for a book tracking application. Each tile will: Connect to Dataverse using FetchXML Accept a status code as a parameter Display a count of books matching that status for the current user App overview (drawing, table schema) My 5-year-old Procreate license is finally seeing some action: Obviously, there's no way to improve this perfection, so let's move on to the database schema. Table Structure This solution uses the following table structure: We only need the User Book Status table for our dashboard: Which books the user has What status each book is in (Read, Reading, Want to Read, etc.) The link to the user (Contact) Creating a Web Template Quick setup: Power Pages Management → Web Templates → New Web Template. Name it, connect to your site, set MIME type to application/json Done with the basics, we can move to the actual web template