News and Announcements icon

Power Platform CommunityForums 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) Share

Report

Report

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:

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Fubar 7,647 on at

Like (0)

Report

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 8,899 on at

Like (0)

Report
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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Give Back to the Community this Month

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 143,867

#2

RandyHayes 76,308

#3

Pstork1 64,174

Leaderboard

Featured topics

Updates on Power Apps Portals - PLEASE READ

Product updates

Microsoft Power Platform Community release plans