Skip to main content

Notifications

Community site session details

Community site session details

Session Id : MVzhG5HZg3mKuDDhURDNWT
Power Automate - General Discussion
Unanswered

Flows behaviour unexpectedly

Like (0) ShareShare
ReportReport
Posted on 5 Jan 2023 10:02:08 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?

  • Sh3r1 Profile Picture
    12 on 12 Jan 2023 at 03:25:21
    Re: Flows behaviour unexpectedly

    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

  • VictorIvanidze Profile Picture
    11,989 on 05 Jan 2023 at 10:09:31
    Re: Flows behaviour unexpectedly

    Could you show your flow?

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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,440 Most Valuable Professional

Leaderboard
Loading started
Loading complete