News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Update SP list with ba...

Power Automate - Building Flows

Unanswered

Update SP list with batch number every 3000 records

(0) Share

Report

Report

Posted on by donnadonut85

Hey,

This seems really simple in my head but i cannot work it out.

I want to create a flow to update a column in SP list called BatchNumber. I want the first 3000 records to have 1, the next 3000 to have 2, the next 3000 to have 3 and so on.

Can anyone help with this?

All responses Img

All responses (1)

Answers Img

Answers (0)

Unknown geen idee 1,755 on at

Like (0)

Report
Re: Update SP list with batch number every 3000 records

Dear D,
Create a variable called 'Counter3000'.
Create a variable called 'BatchNumber' and set it to 3000.
Loop through all your records via an 'Apply to each'.
Inside the loop, update the record with the variable BatchNumber.
Inside the loop, include action 'Increment Counter3000 variable' +1.
Inside the loop, include a conditional statement which checks if the Counter3000 = 3000 ... if so, then increment BatchNumber +3000 and reset Counter3000 to 0.
Continue...
Please note that because you are using variables, you cannot run parralel loops which affects your speed.
You can probably do this without variables as well ... but that becomes a bit more complicated.

Happy flowing,
Koen

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans