OOB N:N - Filter one table based on existence of records in related table

(0) Share

Report

Posted on by MP-27080919-0

I have two tables using an OOB many-to-many relationship and have successfully related records to each other in both tables. I want to filter one table based on whether there are related records in the other table. Beat my head against the wall for 2 hours now so giving up and asking for help...

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @mitchpowell ,

I made a sample for you.

Filter(ForAll(TestL32S As temp,If(CountRows(temp.TestL33S)>0,temp)),!IsBlank(TestL32))

Best Regards,

Wearsky

Was this reply helpful? Yes No