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

Select All from Gallery

I have a gallery that lists data which can potentially be deleted from the SharePoint List that it is stored in.  I would like to add a Select All feature on it but can't seem to get it to do what i want it to do.


In the gallery i have added a checkbox with the following formulas:


OnCheck Property:

Collect(DeleteItems, ThisItem)

UnCheck Property:

Remove(DeleteItems, ThisItem)

Outside of the gallery i have adedd another checkbox with text saying Select All next to it.


I have added on the default property of the checkbox in the gallery:


If i select a single item from the gallery,  the item saves into the collection, if i unselect it, it is removed from the collection. 


However, when i select the Select All checkbox, all the checkboxes in the gallery are selected but don't get collected in the deleteitems collection.


Is there a formula i can add to resolve this?


Also, if this does get fixed i would also like it so that if all are selected but i decide to unselect one or two items, those items are removed from the collection and the remaining selected ones are still collected.




Not applicable

Re: Select All from Gallery



You can do ForAll(Gallery; If(Not(ThisItem in DeleteItems);Collect(DeleteIems;ThisItem)))

on the outside checkbox property ?





Level: Powered On

Re: Select All from Gallery


Thanks for you reply, unfortunately that is not working

Helpful resources


Power Automate Community User Group Member Badge

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


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


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 313 members 5,955 guests
Please welcome our newest community members: