Filter blank value based on checkbox

[zmansuri]

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?

[Abhilash_Swain · Accepted solution]

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

[Nogueira1306 · Accepted solution]

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

[zmansuri]

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?

[Nogueira1306]

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

[Abhilash_Swain]

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