Hi y'all, I would need your expertise to help me to solve the following problem: When in a document library, the amount of items has reached 5000, I would like Power Automate to create a new document library automatically. Is there a way to solve this with flows?

@weismuller Please follow below pictures to create a flow. 1.Set trigger and get files. 2.Create a compose. 3.Create a condition and create a new document library. Uri:_api/web/lists Headers: accept application/json;odata=verbose content-type application/json;odata=verbose Body: { '__metadata':{ 'type':'SP.List' }, 'AllowContentTypes': true, 'BaseTemplate':101, 'ContentTypesEnabled':true, 'Description':"", 'Title': 'newdoc' } If an Answer is helpful, please click " Accept Answer " and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Thanks @Emily Du-MSFT , I got this working now. Problem why new library was not created was apparently that condition was set so that outputs is greater than 5000 (that was what i asked), but it seemed that Sharepoint Online couldn't take to output over 5000. When I changed the condition "outputs is greater than 4999", it worked.

How to create a flow to create new document library after certain amount of items is created

Accepted answer

Emily Du-MSFT 47,926 Reputation points Microsoft Vendor

2021-09-24T09:54:15.367+00:00

@weismuller

Please follow below pictures to create a flow.

1.Set trigger and get files.

2.Create a compose.

3.Create a condition and create a new document library.
Uri:_api/web/lists
Headers:
accept application/json;odata=verbose
content-type application/json;odata=verbose
Body:
{
'__metadata':{ 'type':'SP.List' },
'AllowContentTypes': true,
'BaseTemplate':101,
'ContentTypesEnabled':true,
'Description':"",
'Title': 'newdoc'
}

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Emily Du-MSFT 47,926 Reputation points Microsoft Vendor

2021-09-27T02:17:17.663+00:00

@weismuller

I’m checking how the things are going on about this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.

weismuller 21 Reputation points

2021-09-28T09:22:36.613+00:00

Thank you very much for your answer.

I managed to create the flow with your instructions, and Flow checker said it was good. I tested it in practice after that by moving +5000documents to the document library where I connected the flow, but no new document library was created after that.

I have no idea what might have went wrong as the flow itself didn't create any errors. Something is obviously still wrong.

And one detail I didn't mention in my original question: the new document library should contain the same columns and metadata as the one that contains 5000 documents.

I really appreciate your help and effort.

Emily Du-MSFT 47,926 Reputation points Microsoft Vendor

2021-09-28T10:16:46.787+00:00

@weismuller

Select the action Get files (properties only) ->Three dots -> Settings -> Enable Pagination -> Set the Threshold.

Create a document library with columns is a very complicated process, beyond the scope of technical support, I suggest you start a new discussion in the Microsoft Power Automate Community.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to create a flow to create new document library after certain amount of items is created

1 additional answer

Your answer