I am trying to filter a table on an attribute which comes from a LookUp column from another table.
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:
'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,
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/
Keep up to date with current events and community announcements in the Power Apps community.
Check out the latest Community Blog from the community!