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 / Flows behaviour unexpe...
Power Automate
Unanswered

Flows behaviour unexpectedly

(0) ShareShare
ReportReport
Posted on by 12

I have a flow where I am processing large amount of data and then creating and updating a SharePoint list of around 5000 records using apply to each block, the flow runs fast for few entries then slows down. It would create approx 80 entries in 2 minutes and would take 1 hour for rest. I have concurrency enabled and when I try to troubleshoot I see the condition block is taking too much of time but after expanding the condition the actions inside it takes less than 3 seconds,has anyone faced something similar?

Categories:
I have the same question (0)
  • VictorIvanidze Profile Picture
    13,079 on at

    Could you show your flow?

  • Sh3r1 Profile Picture
    12 on at

    Sorry I don't have access to the system for next two weeks but it give an outline I have five excel sheets, The base one has 7000 records and others have 50k records each. I am doing list rows to get all the items for each sheet, I have added filter arrays to match the 7000 records from each sheet so I work with matching entries on the base sheet and to avoid unnecessary looping after that I am using the body of filter array as value in apply to each to loop those 7000 records and then another 4 filter arrays to find the matching value of current running loop and then I am creating the item in SharePoint list if the item doesn't already exists in SharePoint if the item exists I am updating it. I don't know if it gives any ideas of my flow but I'll try to share it as soon as I am able to.

     

    The flows runs fine for few records then it just gets stuck last run it took @ 10+ hours just to create 3000 records in SharePoint and throttled more after that

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
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard