question

DK2020 avatar image
0 Votes"
DK2020 asked MatteoZamori-0183 answered

add users to sharepoint online group automation

Hi
i have excel sheet with users in my local drive. i want to add or remove users to sharepoint online group automatically whenever users is removed or added to excel sheet. i want to make this automation so i can only update excel sheet manually to add or remove user. is it any way to make this possible?
my environment is sharepoint online.

office-sharepoint-onlinewindows-server-powershelloffice-sharepoint-server-administrationoffice-sharepoint-server-customizationsharepoint-workflow
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered

Hi @DK2020
This requirement is relatively complex and currently there is no ootb method and workaround to meet your requirement.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MatteoZamori-0183 avatar image
0 Votes"
MatteoZamori-0183 answered

Hi @DK2020,

if you can use a SharePoint list rather then an Excel sheet locally than you may evaluate the approach proposed here: [link][1]
.
[1]: https://normyoung.ca/2020/10/22/add-and-remove-users-to-a-sharepoint-site-using-microsoft-lists-and-power-automate/#:~:text=Create%20a%20new%20Flow%20from%20the%20Users%20list,created%20or%20modified%20%E2%80%9D%20trigger%20and%20click%20%E2%80%9CCreate%E2%80%9D.

If you are obliged to use the Excel Sheet locally, you may still use the link above as reference but you have to install Power Automate Desktop application on your client and, at the beginning of your automation, find a way to parse the rows present in your Excel sheet

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.