Unanswered

Metadata filter - Filter a entity list by account (company)

(0) Share

Report

Posted on by Holiver02

I have a contacts table and an account table that are related. In this screen, the user will have a view of all contacts, but they can filter according to the selected account. I know that it's possible to add a metadata filter for text columns. But is it also possible for columns that are related to another table? If possible, without code.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Fubar 8,493 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Where the Lookup is on the Table the List is for, Yes - but only for the value in the Lookup (not another field on the other table being looked up) .
https://learn.microsoft.com/en-us/power-apps/maker/portals/configure/list-filter-configuration
You would either use Dynamic Lookup Set or a Lookup Set.

Was this reply helpful? Yes No
Holiver02 22 on at

Like (0)

Report
Copy link

Link copied!

The relationship does not appear in the list, it is many-to-one. Is there a way to work around this?

Was this reply helpful? Yes No
Fubar 8,493 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If this is for Contact and what you see as Company Name - it should be listed as Accounts in the relationship. If you see nothing listed then there is another problem - try hard clearing the browser cache or a different browser.

Was this reply helpful? Yes No
Holiver02 22 on at

Like (0)

Report
Copy link

Link copied!

This relationship in Dataverse appears as many-to-one, and the documentation states that it will only appear in the list if it is many-to-many or one-to-many. Is there any way to fix this?

Was this reply helpful? Yes No
Fubar 8,493 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Just saying "many-to-one" does not clarify things you need to also indicate which table is at either end as a many-to-one is the same as a one-to-many in the opposite direction.
The out of the box Company Name is a one-to-many between Account and Contact (and a many-to-one from Contact to Account). The Lookup sits on the "many" table. The out of the box Company Name on a Contact List is filterable and should be showing as Accounts in the Lookup Sets.

Was this reply helpful? Yes No