Unanswered

Flow Apply Each is stopping at 400 instead of 5000

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a flow that pulls all tasks out of a specific plan in planner. Now that Plan has grown big (Between 600-700 tasks), I'm no longer able to pull all the tasks out of planner because apply each only pulls 400.

Microsoft documentation says it should cap at 5000: https://docs.microsoft.com/en-us/flow/limits-and-config

shows 400 limit

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Brad_Groux 4,556 on at

Like
a
(0)

Report
Copy link

Link copied!

This is likely because of additional steps you have downstream and/or nested within the condition. If you provided a full and detailed screenshot of your flow we could provide more insight.
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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I followed this post to create a kill and fill. It never did a great job killing (I always had some left over and deleted duplicates). https://powerusers.microsoft.com/t5/General-Flow-Discussion/Insert-and-Update-rows-in-Excel/td-p/137060

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I recognize that the original flow uses some older elements (they have been renamed). I redid it using excel business pieces and it is still pulling only 400.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

After looking at the output of get planner tasks, I think the limitation is actually happening when I pull from planner. the Output file only lists "bucket" 400 times. Help Please!

Was this reply helpful? Yes No
v-zhos-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I afraid that it is caused by the limitation of the "List tasks" action.

The action can return up to 400 records.

Here is a idea with this issue you can vote with:

https://powerusers.microsoft.com/t5/Flow-Ideas/List-tasks-over-400-tasks-from-planner/idi-p/232245?collapse_discussion=true&page=2&q=List%20tasks%20action%20only%20return%20400%20tasks&search_type=thread

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks v-zhos,

I already voted! I was wondering if there is another way to do this. I have the free version of Power BI. Do you have instructions for setting up an API?

Cheers,

Shiann

Was this reply helpful? Yes No