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

Announcements

News and Announcements icon
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,767 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,767 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard