web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Not able to schedule a...
Power Automate
Unanswered

Not able to schedule a flow (License issue)

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • fchopo Profile Picture
    8,003 Moderator on at

    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

  • Shujaath_Khan Profile Picture
    1,111 Super User 2024 Season 1 on at

    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

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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 ?

  • fchopo Profile Picture
    8,003 Moderator on at

    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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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.Apply to each step.JPGCSV.JPGJson create.JPG 

  • fchopo Profile Picture
    8,003 Moderator on at

    Hi @Anonymous 

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

    Regards,

    Ferran

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard