cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Guero
Level: Powered On

Creating multiple Document Libraries through Flow with a single API call

Hi,

 

We currently have client SharePoint sites hosted on our O365 tenant, with access to each site to be rolled out to each of our respective clients shortly - I'm currently in the process of trying to automate site creation for any new clients that join us, as previously we've just handled site creation through the GUI and PowerShell. All the sites for the time being will essentially be the same with the same structure, the only difference being the files themselves. I've managed to automate the SharePoint site creation through flow, as well as linking the sites to a hub site, ownership of the sites, group membership, and external access, but I'm having trouble with creating the document libraries on newly created sites. There are 8 libraries overall, and whilst I have actually worked out how to create them each individually using the 'Send a HTTP request to SharePoint" action (I'm quite new to this!), I'd like to try and use MS Graph and JSON batching instead, so I can create all 8 libraries in a single API call.

 

I've tested my JSON on the MS Graph Explorer, which works and and creates the libraries on a specified client site as expected, but when I try and do it through Flow, I get the below error:

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
<HTML><HEAD><TITLE>Bad Request</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Bad Request - Invalid Header</h2>
<hr><p>HTTP Error 400. The request has an invalid header name.</p>
</BODY></HTML>

 

Would anyone be able to tell me where I'm going wrong? I'm assuming it is the Headers, but I'm not sure what the issue is. Do I require an authorization header?

 

See HTTP action below:Doc Lib error.png

 

Any help would be appreciated!

Thank you

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Creating multiple Document Libraries through Flow with a single API call

Hi @Guero ,

 

Why make things complicated?

 

I would create an Azure function that applies a PnP template. (https://veenstra.me.uk/2017/05/18/office-365-azure-running-pnp-powershell-using-azure-functions/)

 

This function you can then call from a flow.

 

 

 

 

View solution in original post

1 REPLY 1
Highlighted
Super User
Super User

Re: Creating multiple Document Libraries through Flow with a single API call

Hi @Guero ,

 

Why make things complicated?

 

I would create an Azure function that applies a PnP template. (https://veenstra.me.uk/2017/05/18/office-365-azure-running-pnp-powershell-using-azure-functions/)

 

This function you can then call from a flow.

 

 

 

 

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,773)