Bulk Update Status Item Existing

(1) Share

Report

Posted on by krfajar

153

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.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
krfajar 153 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No