Creating a new Team and SharePoint Document Library from within a PowerApp

[Chris1969]

I am developing a PowerApp for our book club members to facilitate discussion and gather book reviews (as Word docs).

As new books are received, can PowerAutomate automatically generate a Teams channel (Great Gatsby, Catch-22, etc.) and also generate a SharePoint site including a document library where our members can upload their personal reviews in Word format?

I have been unable to find an online resource documenting the steps to do this; any guidance would be greatly appreciated.

[v-jefferni]

Hi @Chris1969 ,

Could you please share more details about your scenario? What do you mean by "new books are received"? Do you have a data table to store the books inventory?

Assuming that you have a SP list to store the books inventory, when new books are received, book inventory manager would add each book into the list. If so, you could create Flows applied on that list to create Teams channel automatically. But speaking of SP site, is it necessary? Why not create Libraries or even folders in a specific library? Creating sites is not so easy using Flow, you will need to leverage SharePoint REST API to achieve that need.

To be clear, below is a Flow I created for demonstration:

With this flow, when add a new row in the "list1", a new Teams channel and a folder would automatically be created. Channel name and folder name are both basing on the Name column value in the list1.

But if subsites are necessary in your scenario, please refer to below blog which contains detailed process of creating a Flow to create subsites:

https://www.annajhaveri.com/sharepoint/create-a-sharepoint-online-subsite-from-power-automate-flow/

Or if you need to create a library, you will need a "send an Http request to Sharepoint" action, below is a blog for your reference:

https://www.kkit.com.au/post/create-a-sharepoint-library-with-flow

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Chris1969]

@v-jefferni,

Thank you so much for the detailed information, and I'm sorry I didn't provide everything needed right up front. 

Regarding "assuming that you have a SP list to store the books inventory", actually we use Dataverse, not SharePoint lists because it seems like a newer and more powerful solution.

Our business requirements actually necessitate the creation of a SharePoint site for each book to be reviewed and a Teams channel to be created for each book to be reviewed (the total workflow is a bit more complicated than what I put in the original post; I was trying to keep my scenario at a high level).

Am I correct that the solution you've shared can be readily adapted to the insertion of a row into a Dataverse table rather than the creation of an item in a SharePoint list ?

Thanks again for all your help.

[v-jefferni · Accepted solution]

Hi @Chris1969 ,

If you are working with Dataverse, there is a trigger just like SharePoint I mentioned above, just use it to replace SP trigger in the blog than it meets your scenario:

https://www.annajhaveri.com/sharepoint/create-a-sharepoint-online-subsite-from-power-automate-flow/

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Chris1969]

Thank you very much - this is extremely helpful