cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ck25415
Level 8

Get items threshold lmit gets reset

Hello,

 

The threshold limit of get items action gets reset. I have tried different numbers but once I save the workflow and come back to edit it, the field will be empty.

 

Thanks,

5 REPLIES 5
Super User
Super User

Re: Get items threshold lmit gets reset

To insure that you do not cross the limits, you can build delays into your Flow. If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

ck25415
Level 8

Re: Get items threshold lmit gets reset

I dont understand how a delay will help here. I am trying to get items from a library with about 900 files and move them to a different library.  Since the threshold number gets reset only 100 files are retrived from the library when the flow is run, I have to run the flow multiple times(about 9) one after the other to get the job done.

 

Now I have other flows where I have increased the thershold limit to 2000 and retrieved more than 100 items, I dont want to edit those flows now because the threshold limit may get reset on them too.

 

Also, I did not receive any error messages, the problem is the get items action not retrieving more than 100 items

Super User
Super User

Re: Get items threshold lmit gets reset

If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

ck25415
Level 8

Re: Get items threshold lmit gets reset

Here you go, my simple flow and I am trying to increase the threshold limit for the get items action.


@Brad_Groux wrote:

If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!


 

GetItemsThresholdLimit.jpg

Highlighted
Super User
Super User

Re: Get items threshold lmit gets reset


@ck25415 wrote:

Here you go, my simple flow and I am trying to increase the threshold limit for the get items action.


Thanks, the reason screenshots are important is so that we can re-create your Flow exactly as it is in your environment - this helps us troubleshoot and develop possible solutions for you. 

12 is the maximum number of lookup columns you can collect using an action or trigger in Flow. The threshold limit is hard set and can't be changed and it exists to maintain the performance of SharePoint.

So, to get around this threshold limit select or create a list view with no more than 12 total columns. Then choose that view from the Limit Columns by View option of the action.LimitedColumnsByView.png

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Coming Soon: T-shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors
Users online (5,371)