Power Platform Community Forum Thread Details

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

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:

General topics