Premissions to Create SharePoint Site with Power Automate

[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,

[Expiscornovus]

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?

[Krebs]

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

[Expiscornovus]

Hi @Krebs,

Can you also remove web from the Uri?

The Uri should be

_api/SPSiteManager/create

Instead of

_api/web/SPSiteManager/create

[Krebs]

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

[Expiscornovus]

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