cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
LouisC
Level 8

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

@LouisC 

Thanks for you reply, unfortunately that is not working

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

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