Skip to content
Franco Mussopower pages
Neon pink and purple light particles
Photograph · Jr Korpa / Unsplash
Guide No.014
SnippetLiquid

Use Liquid and Fetch XML to retrieve records and populate your custom web templates

If you’ve used Dataverse, Model Driven Apps or Dynamics CRM / CE / Sales for any period of time, you’re likely already familiar with Advanced Find – the old reliable UI…

Level
03CustomiseStage 3 of 4
Read
2 min
Includes
Written walkthrough
Written
Feb 2021

If you’ve used Dataverse, Model Driven Apps or Dynamics CRM / CE / Sales for any period of time, you’re likely already familiar with Advanced Find – the old reliable UI for querying data and building your own views. If like me, you love Advanced Find, good news – you can now use it to produce all the queries you need for your custom web templates.

All you need to do is hit the Download Fetch XML button…

…then copy and paste the results between opening and closing fetch xml tags like so:

{% fetchxml my_query %}

Paste your Fetch XML from Advanced Find here…

{% endfetchxml %}

We also give the query a name, this gives us an easy way to access those records. This retrieves the records for us, but it doesn’t actually output and show anything on screen. For that, we’ll generally use a for loop, which you can learn all about here :)

Go deeper · Power Pages Mastery

This guide is one technique. The course is the method.

The course covers this in Level 3 · Advanced customisation: “Liquid templating for dynamic components”, alongside “Transforming out-of-the-box lists”. A structured programme distilled from dozens of real portal launches — from messy stakeholder requirements to successful go-live.

  • 6 weeks
  • 3 levels
  • Live training + video lessons
Where this fits
  1. Level 1Foundations
  2. Level 2Extending the platform
  3. Level 3Advanced customisation
    • Liquid templating for dynamic components
    • Transforming out-of-the-box lists
There is a knowledge gap when we go from traditional Power Apps work to Power Pages. Franco’s depth of platform knowledge, creative problem-solving, and understanding of web design makes using him to skill up a team a no-brainer.
Tyler Page — Director & Solution Architect — MCA Connect
Filed underLiquid

Comments

No comments yet. Spotted a gotcha I missed? Say so below.

Leave a comment

Your email address won’t be published. Comments are moderated.

Consulting

Need a Power Pages build that editors love and brands survive?

I help teams design and build Power Pages sites with bespoke UX. Tell me about yours.

Search

Book a discovery call

30 minutes. Bring your trickiest Power Pages problem — I’ll tell you honestly whether I’m the right fit.