Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
Unanswered

Possible using JavaScript, Liquid, FetchXML to filter entity list based on a URL Parameter?

(0) ShareShare
ReportReport
Posted on by 2

Have a requirement where I'm attempting to build a public-facing Power Page with a DataVerse entity list that filters by the unique URL they receive in an email. 

 

Scenario 

I have a canvas power app used by internal staff members who multi select widgets for sale and then also choose the vendor accounts that our org would like to offer to them. Once items have been selected and accounts chosen,  new rows are generated as well as a URL that we'd like to email out to our vendors.  We do not want to force vendors to register for accounts to use the application. 

 

URL structure:

websitename.powerportals.com?Email=test@test.com

 

Using JavaScript I can see that I've extracted the email address from the URL via F12 Inspect in browser,   however I want the entity list to filter items shown based on matching the email address column in the item list (who's source is DataVerse)  to the extract URL parameter email value.

 

How can I accomplish this ?  Or is there a potentially easier way to get to the same end result ?

 

Categories:
  • Fubar Profile Picture
    7,960 Super User 2025 Season 1 on at
    Re: Possible using JavaScript, Liquid, FetchXML to filter entity list based on a URL Parameter?

    You can't achieve it with a standard List, you will need to build it from scratch using Liquid fetchxml

    https://learn.microsoft.com/en-us/power-pages/configure/liquid/template-tags#fetchxml

    and you will need Global table permissions on the Table(s) in your fetchxml and those permissions assigned to the anonymous web role

     

    Note: if any of  the information is private, you will need to force the user to login as the above is not secure.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >