Answered

Toggle that selects all checkboxes in gallery and updates multiple data when is check

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I have a problem, The thing I wanna do is a toggle that when is onCheck ,checks all checkboxes of the gallery, I have putted in checkbox default (toggle.Value) but I want also a multiple "Patch", the data only is modified when I click the checkbox but I want to modify the data throw the toggle ,Im confused, I will appreciate help, thanks.

(if you see the pictures, when I click the checkbox the data updates, but when I click toggle ,the checkbox changes but no data update).

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Are you really wanting to update ALL of the records in the gallery when your master toggle is turned on?

Your Default property for the Checkbox permisCheck should be:

ThisItem.Permisos || SeleccionaTots.Value

In your current formula, the SelecionaCap value doesn't really play a part in the logic.

But the question still is the first one above. Do you want to actually update all the records on the change of the master checkbox (SeleccionaTots) or do you want to do this through some other action?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi! thanks for the answer, I want to update with de master toggle and with the checkbox ,for example you can select individually who haves permissions with the checkbox and if you want all users with permission you click the toggle .

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Then the only thing you need to concern yourself over is the OnCheck and OnUncheck actions of the SeleccionaTots toggle.

OnCheck:

Patch(USUARIS_DEP, ForAll(yourGallery.AllItems, {ID: ID, Permisos: "True" } ) )

OnUncheck:

Patch(USUARIS_DEP, ForAll(yourGallery.AllItems, {ID: ID, Permisos: "False" } ) )

Nothing else needs to be done because the Default property of the checkbox in the gallery will then change based on the underling record (unless your gallery is based on a static table)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

i've tried this but it goes visually so slow,I have a counter below and goes very slow ,(1,...2,....3...),it sums the users with permissions slowly,I want also that when is master toggle checked the counter goes to top automatically ,fast..,

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

My guess is you had it backwards before - i.e. ForAll(..., Patch(

That will be very slow. However the formula I provided you is using the ForAll properly - Patch(..., ForAll(

That will be much faster.

However, this is the only choice you have if you are not doing the data operations in some other place. If you had a "commit" button or something like that, then you could make it fast. But, if the toggle is the only control to govern the data operations, then use the formulas as I provided...do not use the ForAll backwards.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

yes , its faster! thanks I will accept as a solution

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Yes...when using the ForAll properly it makes all the difference!!

If you need anything even more faster than that, then you need to consider a separate "submit/commit" button that would contain the data operations.

Glad that worked for you!

Was this reply helpful? Yes No