Filtering on attribute of 3 tier related table in Dataverse

Like (0) Share

Report

Posted on 10 Mar 2022 11:16:39 by Community Power Pla...

Hi everyone,

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

Abstract ERD:

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

Categories:

General Questions

All responses (1)

Answers (0)

AhmedSalih 6,678 Moderator on 21 Mar 2022 at 16:28:09

Like (1)

Report

Re: Filtering on attribute of 3 tier related table in Dataverse

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/