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 / How to extract values ...
Power Automate
Unanswered

How to extract values from Array of nested objects in Power Automate?

(0) ShareShare
ReportReport
Posted on by

Hi Folks,

 

I have the below array retrieved from a SharePoint Online list:

[
 {
 "FeedbackProviders": [
 {
 "EMail": "testemail@gmail.com",
 "Title": "Test Name"
 },
 {
 "EMail": "testemail.yahoo.com",
 "Title": "Test User"
 },
 {
 "EMail": "testemail@hotmail.com",
 "Title": "Test Person"
 }
 ],
 "Id": 15,
 "ID": 15
 },
 {
 "FeedbackProviders": [
 {
 "EMail": "testemail@gmail.com",
 "Title": "Test Name"
 },
 {
 "EMail": "testemail@hotmail.com",
 "Title": "test person"
 },
 {
 "EMail": "testemail.yahoo.com",
 "Title": "Test User"
 }
 ],
 "Id": 117,
 "ID": 117
 }
]

This is a sample of 2 items. The feedbackproviders is a people picker column with multiple selection of users allowed. I would like to convert this to below array without using "Apply to each" action. 

[
{
"ID": 115,
"FeedbackProviders": "testuser@gmail.com", "testperson@gmail.com", "testemail@gmail.com"
},
{
"ID": 117,
"FeedbackProviders": "testuser@gmail.com", "testperson@gmail.com", "testemail@gmail.com"
}
]


 Is this possible by using select and without using "Apply to each"?

Please share your suggestions. Thank you. 

Categories:
I have the same question (0)
  • Verified answer
    v-dezhili-msft Profile Picture
    Microsoft Employee on at

    Hi @rbn_nue ,

     

    Please try:

    vdezhilimsft_0-1678171482640.png

    vdezhilimsft_1-1678171553618.png

    join(xpath(xml(json(concat('{"root":',json(concat('{"Value":',item()?['FeedbackProviders'], '}')), '}'))),'/root/Value/EMail/text()'),',')

    vdezhilimsft_2-1678171602324.png

     

    Best Regards,

    Dezhi

     

     

  • rbn_nue Profile Picture
    on at

    Hi @v-dezhili-msft ,

     

    This is functioning as expected. Thank you for the quick answer!

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard