Skip to main content

Notifications

Community site session details

Community site session details

Session Id : jc3E//gV2RU8Ddj5SO2D5e
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,852 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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Pages - General Discussions

Overall leaderboard
Loading started
Loading complete