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 / How do you turn off "S...
Power Automate
Answered

How do you turn off "Split On" in an Excel rows flow? Whats's the new trigger to loop through the rows?

(0) ShareShare
ReportReport
Posted on by 4

I have built a flow that reads the rows of an Excel document to populate items in Planner. One of the steps is to check and see if a Planner Bucket exists based on one of the Columns, and if it doesn't exist, create the Bucket in Planner. If I run the flow one row at a time, it works. If the Bucket already exists, it works. The challenge is that with the setting "Split On", the flow starts processing multiple rows concurrently and each Flow creates a new Bucket. I want the Flow to loop through the selected rows consecutively so it doesn't create multiple Buckets. When I click the "Split On" to the off position, I can't save the settings. I'm assuming it needs a new trigger, but I don't know what is the new trigger. (Note: I'm very new to Power Automate.)

 

SimonsCoach_0-1628713053464.jpeg

 

All feedback is welcomed. Thank you.

 

FYI: Here's the entire flow:

 

SimonsCoach_1-1628713092092.jpeg

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    Ellis Karim Profile Picture
    11,931 Super User 2026 Season 1 on at

    Check out if concurrency control will suit your needs. This can limit the runs of trigger to one at a time (with other trigger events being queue to run when the currently running flow completes):

    ekarim2020_0-1628716203282.png

    See: Power Automate – Limit Runs to Trigger One at a Time

    Ellis

  • SimonsCoach Profile Picture
    4 on at

    Turning on the Concurrency Control and setting the Degree of Parallelism to 1 resolved my issue. Thank you! 😀

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