Add Users to a Sharepoint Site

(0) Share

Report

Posted on by Community Power Pla...

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,

Categories:

Using flows

I have the same question (0)

All responses (14)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

First of all, which action of that article returned blank results? We might be able to help you out by finding the root cause.

Alternatively, you could look at the add member/user to group type of actions instead of the HTTP request approach. What type of group were you planning on using for this?

Microsoft 365 Group

Azure AD Security Group

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @Expiscornovus,

Thank you for the response.

Third action in article returns blank, you can see below.

I want to add member to sharepoint site, which i create this with MS Teams.
All users are from inside the company, so i don't need to add a new one to our Azure AD, they are already there.

Thanks in advance,

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous,

Thanks for sharing that screenshot.

In the original article of Norm I see he was using the SiteName value and the Group column name of the SharePoint Demo list. In your screenshot it looks like it is missing the SiteName value, it only says ' Members'.

That is probably the reason why it returns empty. It cannot find a group called ' Members'.

Can you share a screenshot of the config of your whole flow and also that specific action? Did you use the same expression as Norm as well in the URI?

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Expiscornovus,
I used the same expression with Norm, you can see below;

concat(variables('varSiteName'), ' ', triggerOutputs()?['body/Group/Value'])
Also, some of variables are in French in Sharepoint, could language create problem?

Code is: concat(variables('varSiteName'), ' ', triggerOutputs()?['body/Group/Value'])

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Expiscornovus ,

Yes, i did;

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Expiscornovus ,

Yes,

Was this reply helpful? Yes No