Answered

Possible to filter lists in a Power Page dynamically w/ anonymous users?

(0) Share

Report

Posted on by JC_Tintin2

Hello community! I am new to Power Pages and have been doing a little research on the following scenario:

I currently have a power pages set up with a list that derives from a Dataverse data source (filtered from SQL). By default, all of the records from the data are returned with my table being set to Global Access. The function I am trying to achieve is when a visitor redirects over to the Power Pages website (from either a QR code or a Power Apps interaction, such as navigating with a dynamic value saved from the respective Power App), the list will be tailored to them without the use of a sign-in. Is there a way to achieve this behavior? Can I have users enter a unique value to them, allowing the table to filter based on their input (which would ideally derive from the Power App value, but can allow typing when the user is redirected via the QR code)?

Thank you!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Fubar 8,463 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Probably not with the standard List. You can create a page and then use Liquid to retrieve a value from the request object and then use that value in a Liquid fetchxml, then output and format the output.

However if doing this, be careful with Global Access and make sure the data you are dealing with is public info etc - as someone can just call the pages url with different values to access others data.

https://learn.microsoft.com/en-us/power-pages/configure/liquid/liquid-objects#request

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

Doesn't have to be a Web Template, but this link has an example of liquid fetchxml and outputting results https://learn.microsoft.com/en-us/power-pages/configure/web-templates-as-components-how-to#create-web-template-with-manifest (ignore the manifest part unless wanting to create a Web Template as a component)

Was this reply helpful? Yes No
JC_Tintin2 19 on at

Like (0)

Report
Copy link

Link copied!

I appreciate your response! This has gotten me on the right trail of thinking. Security concern is a good call out, as this use case would require someone to only access their own data for viewing purposes. Would an inclusion, such as a unique code generator appended to the URL to access the data, be something within scope of Liquid's use case?

Was this reply helpful? Yes No
Fubar 8,463 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Only in so far as Liquid can read the Request and query Dataverse (and then use a liquid 'if' if not found then display a message on the page else displ;ay the form/list etc), so you would need the value stored in Dataverse along with the other value and both match.

(this will then give you the next challenge, the Portal Cache, as it has an SLA of 15 mins, but usually updates within a couple, on data updated from the Dataverse side - and if you can't have a 15min delay breaking the portal cache

Was this reply helpful? Yes No
JC_Tintin2 19 on at

Like (0)

Report
Copy link

Link copied!

This has been a great explanation, and enough to get an idea on how to execute my use case. Thank you very much!

Was this reply helpful? Yes No