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 / How to filter a list t...
Power Pages
Suggested Answer

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,471 Most Valuable Professional on at
    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,487 Super User 2026 Season 1 on at
    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

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 April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
11manish Profile Picture

11manish 56

#2
Valantis Profile Picture

Valantis 46

#3
rezarizvii Profile Picture

rezarizvii 38

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