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

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,

6 REPLIES 6
Highlighted
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!

Highlighted
Post Patron
Post Patron

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

Highlighted
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!

Highlighted
Post Patron
Post Patron

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!

Highlighted
Resolver I
Resolver I

Re: Get items threshold lmit gets reset

Are you talking about when click on the "..." on your get items action and then go into the settings? 

 

1.  Ensure you have pagination enabled

2.  Set the threshold for the maximum value of 5000 

3.  ENSURE you click done on the bottom of that settings window.

 

What I do just for peace of mind is to also set "5000" in my Get item top count.  

 

My share point list has about 8000 items and always grabs everyone and never gets reset.

 

The threshold is for pages, each 'page' is 256 items.  I have tested this with my sharepoint list.  I started my get items with a pagination of 1 and it returned 256 items, then 2 and it returned 512 items, then 10 and it returned 2560 items.  

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

Top Solution Authors
Users online (9,849)