Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Add Users to a Sharepoint Site

(0) ShareShare
ReportReport
Posted on by

Dear all,

 

I'm trying to add users a sharepoint site via power automate.

I can provide email, id or any necessary data to flow but i can't find a way to do this.

 

I read this article but didn't work for me, result always return blank.

https://normyoung.ca/2020/10/22/add-and-remove-users-to-a-sharepoint-site-using-microsoft-lists-and-power-automate/

 

Is there any other way to do this?

 

Thanks in advance,

  • Community Power Platform Member Profile Picture
    on at
    Re: Add Users to a Sharepoint Site

    Hi@Anonymous @Expiscornovus I am trying to change the Created By column to display the user who has created the item on sharepoint list. In my case, the person who creates the item on Sharepoint could be any user.

     

    Due to the 'Create Item' command i have in my flow, sharepoint by default autopopulates this field with my user name (as i am the flow owner). In this case, the person who creates the item on Sharepoint could be any user.

     

    I was looking at the post which you said helped you, however, in the post, the author has already a designated user which he would like to assign in the Modified By column.

     

    Do you know the way to change the user in the Created By from me to the user who actually created the item on SP?
    I need this to update Created By to ensure that item-level permissions in a list worked correctly.

  • Community Power Platform Member Profile Picture
    on at
    Re: Add Users to a Sharepoint Site

    I used Teams Site and add member to Team via Flow.

    It solved my problem.

  • Community Power Platform Member Profile Picture
    on at
    Re: Add Users to a Sharepoint Site

    I am also facing this error. But in my case I am not able to get group values added to the site name . I have followed all steps.
    https://normyoung.ca/2020/10/22/add-and-remove-users-to-a-sharepoint-site-using-microsoft-lists-and-power-automate/

    VaibhavVR123XSD_0-1663587266467.png


    concat(variables('varSiteName'),'',triggerOutputs()?['body/Group/value'])

    Please help.

  • Expiscornovus Profile Picture
    31,635 Most Valuable Professional on at
    Re: Add Users to a Sharepoint Site

    Hi @Anonymous,

     

    Can you run a GET request for SiteGroups without a filter as a test? Just want to see if the PowerAppsDemo Members group is listed in the whole list of SiteGroups.

     

    Maybe it is a case of the Title of the group being different compared to the LoginName.

    _api/web/SiteGroups?$select=Id,LoginName,Title

     

    selectloginname.png

  • Community Power Platform Member Profile Picture
    on at
    Re: Add Users to a Sharepoint Site

    Hi @Expiscornovus ,

     

    Yes, 

     

    hsynclk_0-1661175424842.png

     

  • Expiscornovus Profile Picture
    31,635 Most Valuable Professional on at
    Re: Add Users to a Sharepoint Site

    Hi @Anonymous,

     

    Just to double check. The SiteGroup does exist in the interface on the site itself?

     

    CheckNameinInterface.gif

  • Community Power Platform Member Profile Picture
    on at
    Re: Add Users to a Sharepoint Site

    Hi @Expiscornovus ,

     

    Thats the only thing all we need 🙂

     

    Here is an updated one, the name (PowerAppsDemo) and type (Members) are looks correct to me.

     

    hsynclk_0-1661175036846.png

     

     

  • Expiscornovus Profile Picture
    31,635 Most Valuable Professional on at
    Re: Add Users to a Sharepoint Site

    Hi @Anonymous,

     

    Apologies, I got confused. I need another coffee. The Group column is not the issue, since it was showing the Members label of the choice column. My bad 😅

     

    I think we need to focus on the varSiteName variable value (the SiteName field value). For some reason it is returning as empty? Did you check the outputs of your flow run. Does it show up in your trigger action outputs for example?

  • Community Power Platform Member Profile Picture
    on at
    Re: Add Users to a Sharepoint Site

    Hi @Expiscornovus ,

     

    Yes, i did;

     

    hsynclk_0-1661172636898.png

     

  • Expiscornovus Profile Picture
    31,635 Most Valuable Professional on at
    Re: Add Users to a Sharepoint Site

    Hi @Anonymous,


    The name of the column in your SharePoint list could be the issue. Did you setup the choice column in the List with the same name, Group? 

     

    group_internalname.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow