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

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / How to filter a list t...
Power Pages
Unanswered

How to filter a list to show only records from other accounts?

(0) ShareShare
ReportReport
Posted on by devfv 128
Hi all,
 
I have a table A with records from different accounts,
I'm able to filter a list to show only 'account id' related records:
 
However, is it a possibility to filter a list to show only NON 'account id' related records?
 
background: the use case is to improve user experience since they only need to know other accounts' availability.
 
Categories:
Power Apps portals
I have the same question (0)
  • Suggested answer
    oliver.rodrigues Profile Picture
    oliver.rodrigues 9,368 Most Valuable Professional on at
    How to filter a list to show only records from other accounts?
    You can achieve this by adding a filter in the Dataverse view itself.
     
    In your view basically set a filter to:
    • Account NOT EQUALS <any account>
    I know, it sounds strange, but it actually works, check this video that explains it https://www.youtube.com/watch?v=yJgg4_-UyB8
  • Suggested answer
    Fubar Profile Picture
    Fubar 8,321 Super User 2025 Season 2 on at
    How to filter a list to show only records from other accounts?
    As per Oliver's response. The same also works for filtering based on current portal user by doing a view with a Contact Lookup in the criteria (the portal will automatically substitute in the current portal user). 
     
    This 'feature' is actually documented somewhere - just can never find it.

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
Forum hierarchy changes are complete!
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Jerry-IN Profile Picture

Jerry-IN 66

#2
Fubar Profile Picture

Fubar 45 Super User 2025 Season 2

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 31 Super User 2025 Season 2

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