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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (6,635)