Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ZfA3K2t43N0SWnAUx6puaU
Power Pages - General Discussions
Unanswered

getting error on the Fetch XML code

Like (0) ShareShare
ReportReport
Posted on 16 Feb 2024 04:04:26 by 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:
  • OOlashyn Profile Picture
    3,496 Most Valuable Professional on 19 Feb 2024 at 01:54:01
    Re: getting error on the Fetch XML code

    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.

  • Fubar Profile Picture
    7,896 Super User 2025 Season 1 on 18 Feb 2024 at 23:07:48
    Re: getting error on the Fetch XML code

    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.

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

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Pages - General Discussions

#1
WarrenBelz Profile Picture

WarrenBelz 9 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 7 Super User 2025 Season 1

#3
Rondel Profile Picture

Rondel 6

Overall leaderboard
Loading started