Hi Everyone,
I have sharepoint list exist.
I want updated bulk status from null become “done” on one stage.
This stage it consists of column: status, pic name and receipt date. With the condition:
1. FormID has been formed
2. Status from null to “done”
3. Total items exist: 300 items, will be cut evenly for 3 people with the same role.
So 1-100 items: update to name A
101-200 items: update to name B
201-300 items: update to name C
3. Receipt date: utcnow()
I'm confused about how to make the flow, because there is no right trigger to start.
Hi @krfajar
Apologies for the confusion, when I said many times, I meant, after you run through them all all 20K. Will you start over at the beginning? and you want that pattern done many times, or is it 1 and done.
And it sounds like they will change, which means you would have to do the 1-20,000 many times yeah.
Ummm.. I have to think
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Hi @FLMike
Thanks for your respon.
I need this many times, because the current number of items is very large, around twenty thousand items and the items that will be changed are very random.
Fir example:
Day 1: I change 1-200 items the next day following the same total of items or if possible from power automate directly run twenty thousand items is it possible?
Hi @krfajar
Use an Instant Flow so that you can use a button or call it from a Canvas App or Model Driven App
However, do you need to do this only one time? Or many times?
It would be faster to use a Canvas App to do this than a Flow, but I want to make sure how many times you are going to do this activity, because in Power Automate you will have to iterate through each row.
Also, is the # 1-100 etc actually a Column, or just a random number of items to change? Just looking to see if we can filter on the # or not.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey