Answered

Filtering Nested Table

(0) Share

Report

Posted on by MchPAL

Hello, I need help. I have a Collection called 'filterAssignedTo' which contains Emails, and a Database called 'fskDatabase' which has a column named 'Assigned To'. The type of the column is Sharepoint List Person, so it is in the form of table in Power Apps.

Simply put, I want to filter the 'fskDatabase' based on which email(s) of 'Assigned To'.Email is in 'filterAssignedTo'. The 'filterAssignedTo' may contain more than one record and similarly, 'Assigned To' may contain more than one person.

How do I possibly achieve this? Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @MchPAL ,

You can try below formula in a Gallery:

Filter( AddColumns( fskDatabase, "test", CountIf( ForAll( ThisRecord.'Assigned To' As PP, PP.Email in filterAssignedTo ), Value = true ) ), test >0 )

Best regards,

Was this reply helpful? Yes No
AndrewR1 1,572 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @MchPAL you can try this:
Filter('fskDatabase', 'Assigned To' In 'Assigned To'.Email)
You may receive a delegation waring doing this as the in operator in non-delegable but this is the only way I know how to achieve comparing Multiple -> Multiple email.

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

Was this reply helpful? Yes No