Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Bulk Update Status Item Existing

(1) ShareShare
ReportReport
Posted on by 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.

 

  • FLMike Profile Picture
    FLMike 31,580 on at
    Re: Bulk Update Status Item Existing

    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

  • krfajar Profile Picture
    krfajar 153 on at
    Re: Bulk Update Status Item Existing

    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?

  • FLMike Profile Picture
    FLMike 31,580 on at
    Re: Bulk Update Status Item Existing

    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

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard