Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filtering Nested Table

(0) ShareShare
ReportReport
Posted on by 3

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.

  • AndrewR1 Profile Picture
    AndrewR1 1,518 on at
    Re: Filtering Nested Table

    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

  • Verified answer
    v-jefferni Profile Picture
    v-jefferni on at
    Re: Filtering Nested Table

    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard