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 / Get array data using i...
Power Automate
Answered

Get array data using item value +power automate flow

(0) ShareShare
ReportReport
Posted on by 7

I have this sample array data in flow, 

[{
"name": "abc",
"Lastname": "xyz",
"emailid": "abc@gmail.com"
},
{
"name": "def",
"Lastname": "eee",
"emailid": "def@gmail.com"
}]

 

In Power automate flow using email id as input, how can I get name and last name values for that respective email.

eg: emailid input : def@gmail.com  to the array variable

output: Name and Last name values. that should be def and eee.

 

Thanks in advance !!!

Categories:
I have the same question (0)
  • Verified answer
    Sundeep_Malik Profile Picture
    6,484 on at

    Hey @anu1393 

     

    you can use the combination of filter and select action.

     

    Compose to store your array:

     

    Sundeep_Malik_2-1666376251634.png

     

    Filter array:

    Sundeep_Malik_3-1666376313975.png

     

    Expression:

    item()['emailid']

     

    Select Action:

    Sundeep_Malik_4-1666376356953.png

    Expressions:

    Name:

    item()['name']

    Last Name:

    item()['Lastname']

     

    Final Result:

     

    Filter Action:

    Sundeep_Malik_0-1666376184418.png

     

    Select Action:

    Sundeep_Malik_1-1666376208388.png

     

    If it answered your problem, mark it as the solution.

    And if you liked the explanation, you can thumbs up/kudo the post. It really helps.

    Thanks.

  • anu1393 Profile Picture
    7 on at

    thanks it worked .

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 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard