Answered

Check all checkboxes inside gallery AND perform Collect

(0) Share

Report

Posted on by ckserra33

421

Hi everyone good morning. I am using a gallery with a check box and I have a checkbox outside the gallery that when checked, checks all the checkboxes inside the gallery as intended. However I have the following Collect formula when I check an individual checkbox inside the gallery.

Collect(
colAddTasks,
{
TaskItem: tiTaskTitle.Value,
StoreLocationNum: ThisItem.ActualStoreNumber,
StoreLocation: ThisItem.Location,
TaskStart:calTaskStartDate.Value
}
);

How can I check all the boxes with the single check box and still perform the collection?

Thanks!

Chris

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ckserra33,

You can use a variable and the Default property of the Checkbox within the gallery.

(1) OnCheck & OnUnCheck of the checkbox outside the gallery

//OnCheck UpdateContext({varCheckAll: true}); Collect( colAddTasks, ForAll( GalleryName.AllItems, { TaskItem: tiTaskTitle.Value, StoreLocationNum: ThisRecord.ActualStoreNumber, StoreLocation: ThisRecord.Location, TaskStart:calTaskStartDate.Value } ) ); //OnUnCheck UpdateContext({varCheckAll: false}); Clear(colAddTasks)

(2) Set the Default property of the checkbox within the gallery to:

varCheckAll

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
ckserra33 421 on at

Like
a
(1)

Report
Copy link

Link copied!

@LaurensM YES!! Thats perfect thank you VERY much!!
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Glad I was able to help @ckserra33 😊