cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Using Flow to apply sitedesign and create or update sitescripts?

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.

5 REPLIES 5
Highlighted
Super User II
Super User II

Re: Using Flow to apply sitedesign and create or update sitescripts?

@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.

Highlighted
Super User II
Super User II

Re: Using Flow to apply sitedesign and create or update sitescripts?

@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.

Highlighted
Super User II
Super User II

Re: Using Flow to apply sitedesign and create or update sitescripts?

@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.

Highlighted
Super User II
Super User II

Re: Using Flow to apply sitedesign and create or update sitescripts?

@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.

Highlighted
Helper V
Helper V

Re: Using Flow to apply sitedesign and create or update sitescripts?

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.

 

1_-m6kU7Okrrh2t2qUFy9zPw.png

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,707)