Share
Report
1I'm trying to filter a Power Pages (Power Apps Portal) entity list by the currently logged-in user. Hardcoded fetch XML works, but when I switch to a dynamic approach with Liquid, it fails to filter.
For example, the following hardcoded fetch works fine:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="request_ticketlist">
<filter type="and">
<condition attribute="ticket_createdby" operator="eq" uiname="John" uitype="contact" value="{3AAAAA7C-BD8B-EF21-AC21-000D3DDA56F5}" />
</filter>
</entity>
</fetch>
However, when I try referencing the current user’s GUID, it doesn’t work. For example:
{% if user and user.contactid %}
{% assign currentUserId = '{' | append: user.contactid | append: '}' %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="request_ticketlist">
<filter type="and">
<condition attribute="ticket_createdby" operator="eq" value="{{ currentUserId }}" />
</filter>
</entity>
</fetch>
{% endif %}
{% assign currentUserId = '{' | append: user.contactid | append: '}' %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="request_ticketlist">
<filter type="and">
<condition attribute="ticket_createdby" operator="eq" value="{{ currentUserId }}" />
</filter>
</entity>
</fetch>
{% endif %}
I’ve confirmed the table permissions for “request_ticketlist” and “ticket_createdby” are correct, and the user is signed in.
Things I’ve tried:
- Using {{ user.contactid }} directly without braces.
- Checking entity permissions for the contact and request_ticketlist tables.
- Verifying sign-in and verifying that “user” data is available in the same block.
Question:
How can I ensure that my fetch XML dynamically filters records based on the signed-in user’s contact ID? Any configuration steps I might be missing?
How can I ensure that my fetch XML dynamically filters records based on the signed-in user’s contact ID? Any configuration steps I might be missing?
Thank you!
Note: I used this tutorial to help me (https://debajmecrm.com/how-to-dynamically-show-hide-buttons-on-entity-list-grid-in-powerapps-portals/)
Categories:
All responses (
Answers (
