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
    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
  • Suggested answer
    Fubar Profile Picture
    Fubar 8,203 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
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 66 Super User 2025 Season 2

#2
Jerry-IN Profile Picture

Jerry-IN 55

#3
dgray304 Profile Picture

dgray304 35

Last 30 days Overall leaderboard

Featured topics

Updates on Power Apps Portals - PLEASE READ

Product updates

Microsoft Power Platform Community release plans