Flow to update share point list owner column with multiple users

[Mishatandon]

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!

[efialttes]

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!

[Mishatandon]

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

[yashag2255 · Accepted solution]

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!

[Mishatandon]

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.

[yashag2255]

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!

[Mishatandon]

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.

Attaching my flow.

[efialttes · Accepted solution]

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

Hope this helps

[Mishatandon]

@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

[v-litu-msft]

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