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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How do you turn off "S...
Power Automate
Unanswered

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,681 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard