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 - Power Apps Portals / How to filter a list t...
Power Pages - Power Apps Portals
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:
General
I have the same question (0)
  • Suggested answer
    Fubar Profile Picture
    Fubar 8,116 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.
  • Suggested answer
    oliver.rodrigues Profile Picture
    oliver.rodrigues 9,347 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

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
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Jon Unzueta Profile Picture

Jon Unzueta 100 Super User 2025 Season 2

#2
Shafiuddin Profile Picture

Shafiuddin 45

#3
Fubar Profile Picture

Fubar 36 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Updates on Power Apps Portals - PLEASE READ

Product updates

Microsoft Power Platform Community release plans