cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ElizabethK
Helper II
Helper II

Bulk Update a user selected amount of list items with "complete" under status column

I have a SharePoint online list where production based tasks are completed throughout the day. The individual user needs to select several items at once to try to bulk update the status column selection from "Request Submitted" to "Complete."

 

The user complains that my suggestions of "quick edit" and or clicking on several items in the list and trying to edit and update all the statuses to complete using the form crashes, is not a good way to do it or is too time consuming. 

 

It looks like there used to be a way in SharePoint on prem to do this quickly using Access but that is not an option in SharePoint Online.

 

I need to create a powerautomate where my user can select several items out of a SharePoint list and with the click of a button switch all of the status columns to "complete."

A colleague in IT suggests that it should be as easy as "Get All Items" from the list and then an action for "Update Item" but since they don't want to select all items to be marked as complete at once, there needs to be some sort of input telling the flow which ones to mark as complete.  That is where I am stuck. 

 

Any ideas? I cannot share what the list looks like in a screen print due to the sensitive company information included in the list. What you need to know about the list is that it has customer name, customer information, general information that the user of the list needs to do to update the customer's account and then a column that defaults to "request submitted" for status when it is submitted, that the user then switches to complete after she has done the task. 

 

Thank you for your help! 

1 ACCEPTED SOLUTION

Accepted Solutions
PatrickMSFT
Community Support
Community Support

ElizabethK,

 

Not sure if this fits your precise situation but this may be possible using an Apply to each Condition:
https://docs.microsoft.com/en-us/power-automate/apply-to-each

 

For example...

 

PatrickMSFT_0-1602166554552.png

 

I'm getting all items from a list, using the body dynamic content operator so I have an array of all the items pulled and then I'm just updating each ID that comes up with a new Title. I just hardcoded a Title in my example but obviously, you could put an expression in here instead or use some dynamic content operator.

 

Depending on your needs, the logic could get pretty complex if you need to use multiple Condition branches. Conditions can also impact the performance of a Flow so at a certain level of complexity, you may have waits on Flow runs completing.

 

Power Apps may be the better fit here:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-form-integration 
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form 
https://powerusers.microsoft.com/t5/Building-Power-Apps/Editing-a-row-in-a-Sharepoint-List-using-Pow...

 

The last link highlights a good example of this in action. The short of it is that you can create a Gallery of changes and apply them at once using the EditForm function.

 

Let us know!

 

Patrick

View solution in original post

1 REPLY 1
PatrickMSFT
Community Support
Community Support

ElizabethK,

 

Not sure if this fits your precise situation but this may be possible using an Apply to each Condition:
https://docs.microsoft.com/en-us/power-automate/apply-to-each

 

For example...

 

PatrickMSFT_0-1602166554552.png

 

I'm getting all items from a list, using the body dynamic content operator so I have an array of all the items pulled and then I'm just updating each ID that comes up with a new Title. I just hardcoded a Title in my example but obviously, you could put an expression in here instead or use some dynamic content operator.

 

Depending on your needs, the logic could get pretty complex if you need to use multiple Condition branches. Conditions can also impact the performance of a Flow so at a certain level of complexity, you may have waits on Flow runs completing.

 

Power Apps may be the better fit here:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-form-integration 
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form 
https://powerusers.microsoft.com/t5/Building-Power-Apps/Editing-a-row-in-a-Sharepoint-List-using-Pow...

 

The last link highlights a good example of this in action. The short of it is that you can create a Gallery of changes and apply them at once using the EditForm function.

 

Let us know!

 

Patrick

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,455)