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 / List component: filter...
Power Pages
Suggested Answer

List component: filtering data base on logged in user

(0) ShareShare
ReportReport
Posted on by manuelvcr
Hi all, 
 
I'm currently working on building a site using Power Pages.
 
I need to filter the data displayed on a List, using new list component, to show only data allowed to be shown to the logged in user.
 
We have a table in dataverse with all information of all the centers (PK is centerID) and another table UserCenter where there is a row for every center that an user can see.
 
The problem is how to filter this information using the relationship. I've found that the list supports fetchXML filter (at Power Pages Admin page), but it doesn't show the operator eq-userid of FetchXML.
 
Is there a way to implement this filter?
 
Any other suggestion about how to implement it?
 
Thanks on advances.  
Categories:
General topics
I have the same question (0)
  • Suggested answer
    sannavajjala87 Profile Picture
    sannavajjala87 931 Super User 2026 Season 2 on at
    Hi,
     
    For Power Pages, I'd recommend using Table Permissions rather than relying solely on FetchXML filters. This is both more secure and aligns with how Power Pages is designed to filter data per user.
     
    In your scenario:
    • Center table contains all centers.
    • UserCenter table maps contacts/users to the centers they can access.
    Create a relationship between the tables and configure a Table Permission on the Center table using a parent/child or account/contact relationship path through UserCenter. Power Pages will then automatically return only the records the logged-in user is authorized to see.
     
    If you're using the new List component, support for FetchXML operators such as eq-userid may be limited, so Table Permissions are generally the recommended approach for user-specific filtering.

    I'd focus on implementing the security model with Table Permissions first and use FetchXML only for additional filtering or sorting requirements.
     
    Thanks & Regards,
    Manoj Annavajjala

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 33 Super User 2026 Season 1

#2
Mohsin Ali Profile Picture

Mohsin Ali 25

#3
SP2019admin Profile Picture

SP2019admin 20

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