cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gmaasz
Level: Powered On

Mass-Update items in a gallery based on a checkbox tick

I want to mass-update items in a gallery's statuses to "Completed" based on them being checked, or not checked.

 

Data Source = 'Action Plans'

Each gallery item is an action plan that has to be completed. I want to check all of the completed items, and update their statuses using a button at the bottom. So the button mass-updates all of the item statusses.

 

I cant get the button to do this. I don't know how to change the status based on the checkbox, as well as using ForAll to patch each individual item based on the abovementioned condition.

 

Capture.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Mass-Update items in a gallery based on a checkbox tick

Hi @gmaasz ,

Where’s your data source from ?

Can you show me your formula ?

 

I assume that your data source is from sharepoint list .

 

I have made a test .

I create a list named test4 .status column is single text type.

19.PNG20.PNG

Set Onselect property of the button to :

ForAll(RenameColumns(Filter(Gallery1.AllItems,Checkbox1.Value=true),"ID","ID1"),Patch(test4,LookUp(test4,ID=ID1),{status:"completed"}))

21.PNG

 

Regards.

Eason

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Mass-Update items in a gallery based on a checkbox tick

Hi @gmaasz ,

Where’s your data source from ?

Can you show me your formula ?

 

I assume that your data source is from sharepoint list .

 

I have made a test .

I create a list named test4 .status column is single text type.

19.PNG20.PNG

Set Onselect property of the button to :

ForAll(RenameColumns(Filter(Gallery1.AllItems,Checkbox1.Value=true),"ID","ID1"),Patch(test4,LookUp(test4,ID=ID1),{status:"completed"}))

21.PNG

 

Regards.

Eason

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

gmaasz
Level: Powered On

Re: Mass-Update items in a gallery based on a checkbox tick

I used your formula and am getting an error. The data source is a SP list, and the column is named 'Issue Status'. It gives me the following error on the column:

 

The type of argument 'Status' does not match the expected type 'Record'. Found type 'Text'.

Capture.JPG

 

 

 

 

gmaasz
Level: Powered On

Re: Mass-Update items in a gallery based on a checkbox tick

@v-sheyu-msft

forgot to mention that the status field is a dropdown.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 176 members 4,553 guests
Please welcome our newest community members: