Using Flow to apply sitedesign and create or update sitescripts?

[AndreSchlender]

SiteDesign and SiteScript commands are exposed through a REST API (sharepoint.utilities).

My problem is creating an App in AzureAD to create an authentication mechanism for interacting with this API

1) I can't seem to find the API to connect to. Is this the Graph API or the SharePoint API? or something altogether different.

2) Assuming I would find the correct API what are the actual permissions that need to be configured to execute the actions?

Before anyone asks ... the scenario I'm  trying to implement is as follows.

1) A new entry is created in a SharePoint project list.  This triggers a "project asset" provisioning flow.

2) This Flow's job is to create a project document library (with the project number in the title), a project deliverables list (again with the project number in the title).  It also needs to assign a project document content type to the library and make that content type the default.

So at the moment I'm trying to implement that by creating a sitescript JSON file dynamically that has the correct instructions.  The flow now needs to use the http request action to call the UpdateSiteScript and ApplySiteDesign commands through the REST API.  Any help would be appreciated.

[Jay-Encodian]

@AndreSchlender 

Have you reviewed the standard MS documentation covering this topic, it's pretty good: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-rest-api 

As an aside you can use the Graph explorer to validate what's currently available in the Graph API - https://developer.microsoft.com/en-us/graph/graph-explorer 

Ref authentication; If you're executing the request from Flow it should use the credentials which Flow is executing within, if you wanted to change the context and use App Auth (ACS) the following blog post I think covers the bases: http://www.ktskumar.com/2017/01/access-sharepoint-online-using-postman/

If you wanted to use an AAD app then the following should work, albeit it's documented for the Graph API so it may need some tweaking to assure the APP has the correct permissions - https://blogs.technet.microsoft.com/sharepointdevelopersupport/2018/02/06/use-postman-and-aad-app-to...

Ref the approach; I would personaly use Flow to call an Azure function which used PnP to do this... why? Given you need to dynamically change the site design script it'd be easier and more extensisbe to do this in CSOM as opposed to registering / upating the site design script each time.. also a whole lot easier to debug 🙂

This is pretty well documented here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-pnp-provisioni...

Hope this helps

PS: I have't fully vetted all the links/ tech content but there should be enough to help you progres.

[Jay-Encodian]

@AndreSchlender 

Have you reviewed the standard MS documentation covering this topic, it's pretty good: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-rest-api 

As an aside you can use the Graph explorer to validate what's currently available in the Graph API - https://developer.microsoft.com/en-us/graph/graph-explorer 

Ref authentication; If you're executing the request from Flow it should use the credentials which Flow is executing within, if you wanted to change the context and use App Auth (ACS) the following blog post I think covers the bases: http://www.ktskumar.com/2017/01/access-sharepoint-online-using-postman/

If you wanted to use an AAD app then the following should work, albeit it's documented for the Graph API so it may need some tweaking to assure the APP has the correct permissions - https://blogs.technet.microsoft.com/sharepointdevelopersupport/2018/02/06/use-postman-and-aad-app-to...

Ref the approach; I would personaly use Flow to call an Azure function which used PnP to do this... why? Given you need to dynamically change the site design script it'd be easier and more extensisbe to do this in CSOM as opposed to registering / upating the site design script each time.. also a whole lot easier to debug 🙂

This is pretty well documented here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-pnp-provisioni...

Hope this helps

PS: I have't fully vetted all the links/ tech content but there should be enough to help you progres.

[Jay-Encodian]

@AndreSchlender

Have you reviewed the standard MS documentation covering this topic, it's pretty good: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-rest-api

As an aside you can use the Graph explorer to validate what's currently available in the Graph API - https://developer.microsoft.com/en-us/graph/graph-explorer 

Ref authentication; If you're executing the request from Flow it should use the credentials which Flow is executing within, if you wanted to change the context and use App Auth (ACS) the following blog post I think covers the bases: http://www.ktskumar.com/2017/01/access-sharepoint-online-using-postman/

If you wanted to use an AAD app then the following should work, albeit it's documented for the Graph API so it may need some tweaking to assure the APP has the correct permissions - https://blogs.technet.microsoft.com/sharepointdevelopersupport/2018/02/06/use-postman-and-aad-app-to...

Ref the approach; I would personaly use Flow to call an Azure function which used PnP to do this... why? Given you need to dynamically change the site design script it'd be easier and more extensisbe to do this in CSOM as opposed to registering / upating the site design script each time.. also a whole lot easier to debug 🙂

This is pretty well documented here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-pnp-provisioni...

Hope this helps

PS: I have't fully vetted all the links/ tech content but there should be enough to help you progres.

[Jay-Encodian]

@AndreSchlender

Have you reviewed the standard MS documentation covering this topic, it's pretty good: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-rest-api

As an aside you can use the Graph explorer to validate what's currently available in the Graph API - https://developer.microsoft.com/en-us/graph/graph-explorer

Ref authentication; If you're executing the request from Flow it should use the credentials which Flow is executing within, if you wanted to change the context and use App Auth (ACS) the discussion links to the required info: https://social.msdn.microsoft.com/Forums/sharepoint/en-US/52fc9448-c391-4c46-a4c9-874b62512372/rest-...

If you wanted to use an AAD app then the following should work, albeit it's documented for the Graph API so it may need some tweaking to assure the APP has the correct permissions - https://blogs.technet.microsoft.com/sharepointdevelopersupport/2018/02/06/use-postman-and-aad-app-to...

Ref the approach; I would personaly use Flow to call an Azure function which used PnP to do this... why? Given you need to dynamically change the site design script it'd be easier and more extensisbe to do this in CSOM as opposed to registering / upating the site design script each time.. also a whole lot easier to debug 🙂

This is pretty well documented here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-pnp-provisioni...

Hope this helps

PS: I have't fully vetted all the links/ tech content but there should be enough to help you progres.

[anton-khrit]

Hi!

You can use PnP templates in Microsoft Flow to provision SharePoint entities.

This article describes how to provision sites, lists, libraries, and Modern pages using PnP templates from Microsoft Flow. 

Note, this is provided as an action in the Plumsail SP connector, which is a part of Plumsail Actions product. It is a paid product.