cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Get File Properties (sharepoint) - more than 5000 limit ?

Dear all,

I am trying to Update the Title column in Sharepoint Library with around 200,000 photos  to be equal to the photo name 

(for Indexing in powerapps)

However , Flow don't have the Pagination options like "get items" , so i cannot update more than 5000 items in the library,

 

anyone has a solution to overcome this limit for SP online Library?

 

Thanks a lot ,

 

7 REPLIES 7
Highlighted
Super User II
Super User II

Hi @luuminhvuong93 

 

You're right. There's the limitation, so you have to do it in batches. You can create a Flow that triggers every 5 minutes that performs a "Get Item" as follows:

 

small-Screenshot_2019-11-07_at_10_29_33.jpg

 

If the name is different, it means that the value was already updated. It may take a little time, but you let it run overnight you'll have all names updated in the morning. You can even leave the Flow active so that you know that the names are always correct. It will be fast once all is updated since the 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted

@manuelstgomes 

Thanks for the solution , I was thinking doing in batches but not sure how.,..

however if auto trigger with 5 Minute Interval then I have to wait and turn it off the flow off manually,

Is there a way to set this up automatically stop when all items have been updated?

 

Highlighted

Hi @luuminhvuong93,

 

If the return length of Get items value is equal to 0, turn off itself.

Annotation 2019-11-08 162448.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted

Hey @luuminhvuong93 ,

 

In my opinion, let it run and forget about it. If it doesn't have any items to parse, it just stops. If it has something to parse, it's only a couple of items, and you know that stuff is always synced. It's a win-win situation :).

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted

Hi @luuminhvuong93,

 

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Highlighted

I try but I got a message error : " aggregated page count of more than '1000'. This exceeded the maximum page count '1000' allowed

Highlighted

Hi @luuminhvuong93 

 

In the "Get Items" set the "Top Count" to something like 2000. Then only 2000 values will be fetched each time. Then make, for now, the Power Automation runs more frequently until you have all your items synced. After that, you can reduce the frequency, and it will only fix the few that will be inserted after that.

 

Does it make sense? 

 

I'm sure we can figure this out so don't worry 🙂

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

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.

Top Solution Authors
Top Kudoed Authors
Users online (7,792)