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

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
manuelstgomes
Level 10

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

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

luuminhvuong93
Level: Powered On

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

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

 

Community Support Team
Community Support Team

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

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.

manuelstgomes
Level 10

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

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

Community Support Team
Community Support Team

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

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

luuminhvuong93
Level: Powered On

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

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

manuelstgomes
Level 10

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

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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 Kudoed Authors (Last 30 Days)
Users online (6,464)