You’re offline. This is a read only version of the page.
Announcements
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 ?
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.
Share
Report
All responses (
Answers (
