add users to sharepoint online group automation

DK 46 Reputation points
2022-03-18T16:07:55.947+00:00

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.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,206 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,560 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
507 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,794 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,354 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yi Lu_MSFT 17,456 Reputation points
    2022-03-21T06:12:06.01+00:00

    Hi @DK
    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.

    0 comments
  2. Matteo Zamori 86 Reputation points
    2022-03-24T11:54:33.107+00:00

    Hi @DK ,

    if you can use a SharePoint list rather then an Excel sheet locally than you may evaluate the approach proposed here: link
    .
    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

    0 comments