Unanswered

Premissions to Create SharePoint Site with Power Automate

(0) Share

Report

Posted on by Krebs

Hello Out there

Im creating a Flow that creates a Sharepoint site when the Keyword "News" is mentioned. You can then enter a Title and the News Itself. This shoud then go into the site with the Dynamic-content.

This flow fails all the time due to not Having premisions, but i have created the Teams. (Error 401) I dont understand why it isnt working because i created the Team and the Sharepoint.

Is there a Way to give the Bot or myself more Rights to Create the Sharepoint Site

This Is the help with i created the HTTPS Blcok

https://michelcarlo.com/2021/06/19/create-a-modern-sharepoint-site-using-power-automate/

This is the raw Input:

This is the raw Output

If you have Questions please ask

If this is the wrong Board im sorry

Thanks alot if Anyone can help

Greetings Kebs

Tags / Lable

Powerautomate, Power Automate, Premissions, Create Sharepoint Site, Error 401, Missing Premissions,

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Krebs,

I see in the screenshot of the error that you have an URI which starts with a white space (which got encoded to %20). In other words your are using '%20_api' instead of '_api' in your URI of the Send an HTTP request to SharePoint action.

Can you remove that white space from your URI field and try again?

Was this reply helpful? Yes No
Krebs 6 on at

Like (0)

Report

Hello @Expiscornovus
Thanks for the sugestion

Unfortunately it dint work but the error message did change from Error 401 to Error 404

Raw Input:

Raw Output:

Greetings Krebs

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

Like (0)

Report
Hi @Krebs,

Can you also remove web from the Uri?

The Uri should be

_api/SPSiteManager/create

Instead of

_api/web/SPSiteManager/create

Was this reply helpful? Yes No
Krebs 6 on at

Like (0)

Report

Hello @Expiscornovus

In Power Automator it seems to have worked but in Sharepoint the is no new Site.

Raw Input
and Request

Raw Output

Thanks for your contiued Help
Greetings Krebs

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

Like (0)

Report
Hi @Krebs,

I see the URL in the Body of your Send an HTTP request to SharePoint action contains an invalid site url for your newly created site.

It does not contain the new site name and you have also included the SitePages library into the url (please remove that part of the link).

Try something like below.

Replace the <newsitename>, <yourtenant>, <your description> and <your sitedesignguid> by your values/ variables/dynamic content.

{ "request": { "Title": "<newsitename>", "Url":"https://<yourtenant>.sharepoint.com/sites/<newsitename>", "Lcid": 1033, "ShareByEmailEnabled":false, "Description":"<your Description>", "WebTemplate":"SITEPAGEPUBLISHING#0", "SiteDesignId":"<your sitedesignguid>", "Owner":"<owner@yourtenant.onmicrosoft.com>", "WebTemplateExtensionId":"00000000-0000-0000-0000-000000000000" } }

Btw, here is the Microsoft documentation of the REST API method as a reference:

https://learn.microsoft.com/en-us/sharepoint/dev/apis/site-creation-rest

Was this reply helpful? Yes No