Answered

Converting Office 365 Group members to a SharePoint list item

(0) Share

Report

Posted on by Anonymous247

Hello there,

I am new to Power Automate and I need help. I am trying to automate the updates of the SharePoint item to have multiple usernames in the Members list (screenshot 2 below) as per the Microsoft 365 Teams & Groups (screenshot 3 below).

However, the SharePoint results show only one member's name in each item (screenshot 1 below). Is there a way to show multiple member names in a SharePoint item?

Appreciate it if someone can point me to the right direction. After conversion, only one member was listed (below attachment)

After conversion from Office 365 Groups to SharePoint list, only one member appeared in SharePoint list instead of three. I want to achieve multiple members in SharePoint list item. How?

Below is what I am trying to achieve to appear in the SharePoint list

This is what I want to achieve in SharePoint.

This is the initial members' list of Group 1 in Office 365 Groups

This is the initial Office 365 Group member list

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

HenWang Microsoft Employee on at

Like (0)

Report
Hi @Anonymous247 ,

Please firstly make sure the person column inside you SP list is Allowing multiple selections:

Try below flow:

1. List the group member you want to add

2. Use initialize variable to create an array variable

3. Create "append to array variable" action to add the email value:

Inside the value to be appended:

{ "Claims": "i:0#.f|membership| /*The mail dynamic content*/ " }

Please make sure our Value content is exactly having the same value.

4. Update item:
In my list, the person_2 column is the multiple person column, please click below button to switch the way of updating this person column:

Then you can just put the array variable into this person column and save the flow:

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Anonymous247 16 on at

Like (1)

Report

Hi Hen Wang. Thank you so much for your reply. I have tried the procedure you have listed. Now I am able to get two members listed only instead of three members in Office 365 Groups. Where could I go wrong?
Appreciate your help. Thank you.

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (0)

Report

Hi @Anonymous247 ,

Could you please send me this same screenshot from your flow?

Please include the apply to each part as well. And please also check the output of your list group members action like below snap to confirm whether flow did receive three person information or not.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Anonymous247 16 on at

Like (0)

Report

Thank you for your reply. Here are the screenshots requested:

Just for your info, the output did not come out as the flow runs endlessly without stopping after completion as shown in the first screenshot. I am unsure about the reason for it. Appreciate your kind feedback.
Kind Regards
Shen Wong

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (0)

Report

Hi @Anonymous247 ,

Thanks for the information. Understand that you are trying to add member for multiple groups and there are two variables inside your flow. Without knowing the other variable's meaning, at least I would suggest you replace the DisplayName dynamic content inside this "append to array" action with Mail dynamic content.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Anonymous247 16 on at

Like (1)

Report

Hello Hen Wang
Thank you for your suggestion. I did as you said and seems like it works now. Thanks once again for your valuable information. Have a great day.
Kind Regards
Shen Wong

Was this reply helpful? Yes No
Anonymous247 16 on at

Like (0)

Report

Hello Hen Wang
Sorry, I need to ask another question before I let you go. Is it possible to list group owners from Office 365 Groups and then include them in SharePoint list items (as per the Owners column in the screenshot below)?
Kind Regards
Shen Wong

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (0)

Report

Hi @Anonymous247 ，

I am afraid there is no direct action in Power automate to achieve this, but you can check this blog by using HTTP request way:
https://tomriha.com/how-to-get-microsoft-365-group-owners-in-power-automate/

Hope this can help.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Anonymous247 16 on at

Like (1)

Report

Thank you Hen Wang for showing me the link to the blog. I have tried that, but it doesn't work. Having said that, I will continue to try again. Hopefully to have a good outcome. Enjoy the rest of the day. Regards Shen.

Was this reply helpful? Yes No