web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter array by email ...
Power Automate
Answered

Filter array by email from Person type column gives no results

(0) ShareShare
ReportReport
Posted on by 28

I need to filter data by the person's email which should be taken from a Person type column (Added by):

JoannaW_0-1667230238986.png

expression is: 

items('Apply_to_Each')?['Addedby/EMail']
 
The results I get is:
JoannaW_1-1667230300839.png

Does anyone how can I make it work?

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,472 Most Valuable Professional on at

    Hi @JoannaW,

     

    Can you share what you are using in the Select an output from previous steps? That is referring to an Outputs from another action. Would be useful to see what the inputs and outputs of that specific action is for troubleshooting purposes.

  • JoannaW Profile Picture
    28 on at

    Hi @Expiscornovus  please see 'Select':

    JoannaW_0-1667824209824.png

    union(body('Select_-_get_emails'),body('Select_-_get_emails'))

     

  • Verified answer
    Expiscornovus Profile Picture
    33,472 Most Valuable Professional on at

    Hi @JoannaW,

     

    Can you switch the Map field to text mode and use the Added by Email property without the Key (Added By)?

     

    Within the filter array I would use items('Apply_to_each'after the is equal to.

     

    Try something like below

     

    filterarray.png

     

  • JoannaW Profile Picture
    28 on at

    Thanks a lot @Expiscornovus 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 305 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 155 Most Valuable Professional

Last 30 days Overall leaderboard