How to filter a table based on N:N relation

(0) Share

Report

Posted on by Usmannb

I have two tables Decision and File. And I have N:N relation between these tables.
My business case is that I want to relate multiple files with a decision and show that in a gallery and similarly I want to be able to relate multiple decisions with a file and show the related decisions in a gallery for selected file.

My current approach is to use this formula.

In this formula DecisionFile is the unique identifier of File table and ThisItem is representing current selected item in a gallery and in the items property of this gallery I have used Decision table as datasource.

As you can see that I have a delegation issue in the above formula and as I am expecting to have more than 2000 records in both table it will be problematic for me in future.

Categories:

Tables

Microsoft Dataverse

Entities

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: How to filter a table based on N:N relation

Hi @Usmannb ：

You could try:

ForAll( ThisItem.Files.DecisionFile As A, LookUp(Files,DecisionFile=A[@DecisionFile]) )

Best Regards,

Bof