cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mishatandon
Helper III
Helper III

Flow to update share point list owner column with multiple users

Hello community,

I have successfully built a flow that fetches information from excel online to share point list. The excel has 4 columns and one column is owner with email ids. Some values in column columns have multiple owners. The share point list has column owner( people/ group) with multiple selection mode on.

The flow runs successfully if I have 1 person in owner column but doesn’t work / fails for multiple people

Can somebody help me what needs to be built to update owner column with multiple people?

Thanks!
2 ACCEPTED SOLUTIONS

Accepted Solutions

Hi @Mishatandon 

 

You can also check this post out where I have shown how to populate multiple select persons field using Power Automate by populating arrays: https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/10-MS-Flow-hacks-troubleshoots-wor...

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Hi!
So, the issue is just to build the array?
As @yashag2255 suggests, you can add a second Apply to each inside the current one, assign as its input the following expression

 

 

 

split(item()?['Column3'],';')

 

 

 

This post explains how to add an expression

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

 

Or, instead of adding a second 'Apply to each', you can add a Select action block inside your current 'Apply to Each' instead to do the same in a faster efficient way, so you assign as Select input the same expression as before...

Now inside the Select action block, on the Map Table, assign as Name the text

 

 

Claims

 

 

and assign as Value the following expression

 

 

item()

 

 

 

So, assuming current iteration has 2 emails (email1@contoso.com, email2@contoso.com) Select output should look like this

 

 

[
{
"Claims": "email1@contoso.com"
},
{
"Claims": "email2@contoso.com"
}
]

 

 

 

Now just need to assign Select output to your Create Item by clicking first on the icon on the right

Flow_MultiPerson.png
Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

9 REPLIES 9
efialttes
Super User III
Super User III

Hi!
Can you share a screenshot from your current flow design?
Also, in your excel, which separator character are you using between email addresses?

 

Sounds your challenge is similar to the one described here, right?

https://sharepoint.stackexchange.com/questions/275954/populate-multi-person-field-using-an-input-fie...
Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Sorry, I am struggling to upload photo over here and not getting option on my phone!

The excel uses semicolon as a separator.

I am trying in the meanwhile to upload

Hi @Mishatandon 

 

You can also check this post out where I have shown how to populate multiple select persons field using Power Automate by populating arrays: https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/10-MS-Flow-hacks-troubleshoots-wor...

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Hello @Yash,

I followed couple of your articles to build flows and they are really insightful and helpful!

For fetching email ids from excel how do I customise array which may have 10 different user ids again one row item who should have access to that row item in share point list?

Sorry I am beginner in this and I am looking for options to post the picture of my flow.

Hi @Mishatandon 

 

Glad to hear that! Thank you so much. 

 

Coming back to the issue you are facing, 

 

You get the row from excel and then the column that has semi colon separated emails. Use the split function to split the emails on the semicolon and create an array with this. And then you can use an apply to each loop to append to a new array variable with "Claims" as the key and "selectcurrentitemhere" as the value so that the array is appropriately constructed and can be passed for the multi select persons field. 

 

This setup would support a single value as well and is dynamic so you do not have to worry about the number of emails. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Hi @yashag2255 ,

 

Thanks for the explanation but apologies again I could not find the split function to use further after I get details from excel. screesnhots of the flow would really really be helpful for beginner like me.

 

PHOTO-2020-04-12-19-44-42 (1).jpgPHOTO-2020-04-12-19-44-42 (2).jpgPHOTO-2020-04-12-19-44-42 (3).jpgPHOTO-2020-04-12-19-44-42 (4).jpgPHOTO-2020-04-12-19-44-42 (5).jpgPHOTO-2020-04-12-19-44-42.jpg

 

Attaching my flow.

Hi!
So, the issue is just to build the array?
As @yashag2255 suggests, you can add a second Apply to each inside the current one, assign as its input the following expression

 

 

 

split(item()?['Column3'],';')

 

 

 

This post explains how to add an expression

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

 

Or, instead of adding a second 'Apply to each', you can add a Select action block inside your current 'Apply to Each' instead to do the same in a faster efficient way, so you assign as Select input the same expression as before...

Now inside the Select action block, on the Map Table, assign as Name the text

 

 

Claims

 

 

and assign as Value the following expression

 

 

item()

 

 

 

So, assuming current iteration has 2 emails (email1@contoso.com, email2@contoso.com) Select output should look like this

 

 

[
{
"Claims": "email1@contoso.com"
},
{
"Claims": "email2@contoso.com"
}
]

 

 

 

Now just need to assign Select output to your Create Item by clicking first on the icon on the right

Flow_MultiPerson.png
Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

@efialttes 

 

I built the flow as per your screenshots and its working great! Thanks to you and @yashag2255  for guiding and helping with the solution! God bless you both!

 

I added a step to assign permissions as well using 'Column3' which had email id's and that also seems to work fine!

 

Again thanks for all the help!

 

Regards

Misha

Hi @Mishatandon,

 

I am glad your issue has been solved, you could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (72,495)