cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
felixpwc
Frequent Visitor

Filtering on attribute of 3 tier related table in Dataverse

Hi everyone,

 

I am trying to filter a table on an attribute which comes from a LookUp column from another table.

 

Abstract ERD:

felixpwc_0-1646910395316.png

In the gallery my Items are of Entity 3. Entity 2 has a LookUp to Entity 1. I am trying to filter entity 3 on an attribute of Entity 1 but I don't get any results back.

 

In my use case entity 1 is the contact table. Entity 2 is the clients table which retrieves full name(s) from the contact table and entity 3 is a Documents table (Progress Monitor Documents).

The following code does not return any records:

 

        Filter(
    'PMPP Progress Monitor Documents',
    'PMPP Client'.'Partner/Director'.'Full Name' = ComboBox1.Selected.'Full Name')

 

Is it not possible to filter on an attribute of a table linked two levels deep?

Hope somebody knows a workaround for this problem.

Kind Regards,


F. Verduin

 

1 REPLY 1
AhmedSalih
Super User
Super User

It is not possible to filter on an attribute of a table linked two levels deep. You have to use the filter and Lookup function to get data from Entity 3 that are based on data from Entity 1. 

This article has more information about the multi-level relationship https://thepoweraddict.com/how-to-work-with-many-to-one-dataverse-relationships/

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (6,277)