Select All checkbox button quick question

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi there,

i have a 'select all' checkbox that sets a variable if it is true or false.

So - on check will be : Set(checkallVar,true)

and OnUnCheck will be : Set(checkallVar,false)

Within each chx box the default is :

If(checkallVar=true,true,false)

My screen also saves to a collection when it is saved, and also on the hidden it resets all checkboxes.

So I want the checkboxes to check the value of the collection and / or highlight from the selectall box.

Anyone with anyideas ? I have put an if statement in the default like this , but i dont have it correct :

If(
checkallVar = true,
true,
If(
First(Collection).'Column one' = 'Yes or No'.Yes,
true,
If(checkallVar = false,false)
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous, if you share some screenshots, it would make it easier to understand your question. One thing as a sidenote, you don't need to set a variable to hold the status value of your checkbox, you can use Checkbox1.Value and it will be true if checked and false if unchecked.

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accept it as the Solution to help other members in the community find it more.

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

Like (0)

Report
Copy link

Link copied!

Hi there, id thought id give more info.
At the moment, each checkbox has this in the default so it shows either / true of false of the checkbox result from an save (stored in a collection).

If(First(InspectionItemTPHCollection).'PHV Licence' = 'Yes or No'.Yes,true,false)

As you can see, it is stored as an optionset and i am just changing that to true or false. This works well.

On the Select All - i am setting a variable like this on the OnSelect and the alternative on the OnUnSelect:
Set(checkallVar,true)

So i need to overwrite the default on the checkboxes to set to this variable on selectall. but when this is not SELECTED on not NOT SELECTED then show the result from the collection as per :

If(First(InspectionItemTPHCollection).'PHV Licence' = 'Yes or No'.Yes,true,false)

Thanks !

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous,

You can think of using the With Function:

With( First(Colletion), If( 'Column one' = 'Yes or No'.Yes, true, checkallVar = false, false ) )

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

Like (0)

Report
Copy link

Link copied!

Very nice solution but its not really working completely..
The checkboxes are defaulting as true (so its best to start as false).
And if i deselect them all , i have to press Select all twice and then it will tick all the columns.
Any ideas ?

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

Like (0)

Report
Copy link

Link copied!

are we missing the condition if checkallvar = true ?

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

Like (0)

Report
Copy link

Link copied!
Hi there,
I have added this to all the chxbox defaults :

With( First(InspectionItemTPHCollection), If( 'PHV Licence' = 'Yes or No'.Yes, true, AllChecked = true, true, AllChecked = false, false ) )
And this kinda works... But when you un-select-all it comes back to its saved position and not an empty position.
Any ideas ?

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous , use the Clear function to clear the collection after you submit

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

Like (0)

Report
Copy link

Link copied!

I cannot use the clear function, because 'the users need to carry on with their work' if they come out of the screen or not. So once its saved, its saved.

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous, try this:

With( First(InspectionItemTPHCollection), If( AllChecked = false, If('PHV Licence' = 'Yes or No'.Yes, true,false), true ) )

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

Like (0)

Report
Copy link

Link copied!

It isnt even saving now :(... I think it depends on the sequence you put it in , in the With statement. Thankyou very much for your continued help... I am completely at a loss...

Was this reply helpful? Yes No