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

Question

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?

Answer 1

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

Answer 2

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.