Unanswered

Not able to schedule a flow (License issue)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Auto scheduling report not possible due to License Limitation for "Apply To Each" step. Is there a work around for this please? Quiet urgent.

Error message: Unable to process template language expressions for action 'Apply_to_each' at line '0' and column '0': 'The number of foreach items limit exceeded for action 'Apply_to_each': maximum '5000' and actual '10975'.'.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

You should redesign your workflow so you use OData filters to get specific rows and not all rows at a time. Are your pulling data from SharePoint or from Excel? Do you need to get all rows?

Regards,

Ferran

Was this reply helpful? Yes No
Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @Anonymous
This has nothing to do with a license but limit overflow beyond max count set to Apply_to_each
so you can break the array to 5000 each and process as needed.

@fchopo suggestion on oData filter is valid which you can try.

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.
https://www.youtube.com/channel/UCgQWIrxj5KrZ2nlx3CDYhEg/playlists

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

Like (0)

Report
Copy link

Link copied!

Getting data from SQL and then running it through Paginate report based on the scenario. So the base source which needs splitting would be data from paginate report.
Meanwhile how do I use Odata connector and after which step ?

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

It could be great if you can provide some context to your problem and share your workflow so we can understand how we can help.

Regards,

Ferran

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

Like (0)

Report
Copy link

Link copied!

Sure. Basically I'm getting data from a Paginate report, Splitting the content by Line brake, Creating JSON, Parsing JSON, Creating CSV table and then creating a CSV file.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Have you considered designing a Dataflow to do all operations and using it from Power Automate?

Regards,

Ferran

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

Like (0)

Report
Copy link

Link copied!

Haven,t worked with Apps before. Will Look into this.

Was this reply helpful? Yes No