Unanswered

Filter blank value based on checkbox

(0) Share

Report

Posted on by zmansuri

6,048 Super User 2024 Season 1

When Contract checkbox is checked all the values which have blank values under contract field should disappear from gallery same for Training and Skill. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Abhilash_Swain 901 on at

Like (0)

Report

Hi @zmansuri
"On Check " for contract check Box, add UpdateContext({Chkcontract:!Chkcontract})
"Items" in Gallery , If (ChkContract, Filter(Gallery source, !IsBlank(Contract),gallery Source).

Please let me know if you get the error due to syntax, I will try in a sample table and share

Was this reply helpful? Yes No
Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

Hey.

You should filter it.

So, in Items property you should wirte something like this:

If(CheckboxContract.Value = true; Filter(List; Contract != ""); List)

So, if the checkbox is selected, it will filter the list and retrieve the contacts that have something. If not, it will retrieve the whole list

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
I did it with this code.

If( chkTraining.Value = true && chkSkill.Value = true, Filter( Zishan, !IsBlank(StatusForTraining) && !IsBlank(StatusForSkill) ), If( chkTraining.Value = true && chkSkill.Value = false, Filter( Zishan, !IsBlank(StatusForTraining) ), If( chkSkill.Value = true && chkTraining.Value = false, Filter( Zishan, !IsBlank(StatusForSkill) ), Zishan ) ) )
Is there a better way?

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

I think not.. That is almost the solution that I was telling you about...

Was this reply helpful? Yes No
Abhilash_Swain 901 on at

Like (1)

Report

Will it work if you filter the gallery without blank values and show all items when a user wants to see them.

Was this reply helpful? Yes No