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.
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
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,