cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrQ
Post Patron
Post Patron

convert array to object?

Dear community

 

I need to update a SharePoint multi-person field. In my flow, I'm managed to get the email address of the required people structured as follows:

 

[
  "user1@xy.com",
  "user2@xy.com",
  "user3@xy.com"
]

 

I get the above structure like so:

pa-app-owners.png 

The "Get items - Application Owners" action is just pointing to another SharePoint list including two columns:  TitlePerson field.

 

 

In order to update the multi-person field, I need to get it structured like this:

 

[
  {
    "Email": "user1@xy.com"
  },
  {
    "Email": "user2@xy.com"
  },
  {
    "Email": "user3@xy.com"
  }
]

 

 

 

Could anyone point me in the right direction? 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@mrQ 

Please check below to convert to the required format

Mira_Ghaly_0-1611742334856.png

Mira_Ghaly_1-1611742561331.png

 

Hope this helps!

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

Paulie78
Super User
Super User

Simply like this:

2021-01-27_10-28-19.jpg

View solution in original post

3 REPLIES 3
Mira_Ghaly
Dual Super User
Dual Super User

@mrQ 

Please check below to convert to the required format

Mira_Ghaly_0-1611742334856.png

Mira_Ghaly_1-1611742561331.png

 

Hope this helps!

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

@Mira_Ghaly 

I'm feeling quite stupid now... seems so easy, haha :-). Should have thought of that....

Thanks for your quick help! This is exactly what I needed.

Paulie78
Super User
Super User

Simply like this:

2021-01-27_10-28-19.jpg

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,995)