cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrQ
Helper V
Helper V

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 II
Dual Super User II

@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 III
Super User III

Simply like this:

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

View solution in original post

3 REPLIES 3
Mira_Ghaly
Dual Super User II
Dual Super User II

@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

@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 III
Super User III

Simply like this:

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

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,918)