cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
neill_long
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:

Checkbox1.Value

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.

 

thanks

 

2 REPLIES 2
Anonymous
Not applicable

Re: Select All from Gallery

Hi,

 

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

on the outside checkbox property ?

 

Regards,

 

Louis

neill_long
Level: Powered On

Re: Select All from Gallery

@Anonymous 

Thanks for you reply, unfortunately that is not working

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: 313 members 5,955 guests
Please welcome our newest community members: