web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / getting error on the F...
Power Pages
Unanswered

getting error on the Fetch XML code

(0) ShareShare
ReportReport
Posted on by Erandi 265

hi,

I created a  condition to filter logged user details on list view. in my dataverse table, i have created a column to display each contact id's of users..by using that column i need to filter.

Erandi_1-1708056208459.png

 

Erandi_0-1708056134191.png

what are the reasons to make this kind of error? @Inogic @Fubar 

Categories:
General topics
I have the same question (0)
  • Fubar Profile Picture
    Fubar 8,487 Super User 2026 Season 1 on at

    The area where you are adding the condition does not have access to Liquid, hence the liquid 'user' object is not valid.  There is a now undocumented feature, where putting any contact record in the FetchXML the portal will substitute it with the currently logged in user.  In the old days they used to install a Contact record called something like Portal User and you would use that - but they don't install that contact any more, but you can create your own.

  • OOlashyn Profile Picture
    OOlashyn 3,498 Most Valuable Professional on at

    Hi @Erandi ,

    As @Fubar mentioned you cannot use liquid user in FetchXml filter (or any other dynamic field for that matter). But as @Fubar specified you can substitute a contact via "Enhanced view filters". However, it is a documented, although a bit clunky and not that much-used feature. You can find more details in the official documentation here - https://learn.microsoft.com/en-us/power-pages/configure/list-enhanced-view-filter.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
rezarizvii Profile Picture

rezarizvii 53

#2
DP_Prabh Profile Picture

DP_Prabh 40

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 28 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans