Power Platform Community Forum Thread Details

Hello, I am using a collection to generate a dataset.

 ClearCollect(
 colExample,
 {
 Section: true,
 Environment: true,
 Test: false,
 Dev: false,
 Prod: false
 },
 {
 Section: true,
 Environment: true,
 Test: false,
 Dev: false,
 Prod: false
 },
 {
 Section: true,
 Environment: true,
 Test: false,
 Dev: false,
 Prod: false
 },
 {
 Section: true,
 Environment: true,
 Test: false,
 Dev: false,
 Prod: false
 }
 )

To visualize this dataset I use a vertical gallery with "check boxes".

gal_Example
 chk_Section
 chk_Environment
 chk_Test
 chk_Dev
 chk_Prod

Now I have to questions:

I want to change the values of the collection by clicking on the check boxes inside the gallery. I tried to use Patch() with no success.
Outside the gallery I want to place a check box for each value (Section, Environment, Test, Dev, Prod). By clicking on this single checkbox, all values of the corresponding value in the collection should change to value of the check box. I tried to do it with UpdateIf() but had no success.

Can someone give me a hint how to solve this?

Thanks for your support.

Michael

Categories:

Building Power Apps

Hi @MichaGue,

(1) You will have to make the records distinguishable in order to correctly patch them (e.g. add a temp ID field):

 ClearCollect(
 colExample,
 {
 ID: 1,
 Section: true,
 Environment: true,
 Test: false,
 Dev: false,
 Prod: false
 },
 {
 ID: 2,
 Section: true,
 Environment: true,
 Test: false,
 Dev: false,
 Prod: false
 }
// and so on...

(2) The checkbox within your gallery will need the following code (Dev checkbox as an example):

//OnCheck
Patch(colExample, ThisItem,{Dev: true})

//OnUnCheck
Patch(colExample, ThisItem,{Dev: false})

//Default
ThisItem.Dev

(3) In order to bulk change all status values for a particular column (Dev column as an example)

//OnCheck
UpdateIf(colExample, true,{Dev: true})

//OnUnCheck
UpdateIf(colExample, true,{Dev: false})

//Default (only checked when all values are true)
CountIf(colExample,Dev) = CountRows(colExample)

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

Thanks!