Code not working

[Emont]

Hello,

I'm trying to assign a value to validarinfo, the idea is that I have a Gallery and I am trying to validate in all lines if it has blanks but is always equal to zero (either is empty the gallery or not):

Set(
    validarinfo,
    If(
        CountRows(
            Filter(
                Gallery3_1.AllItems,
                COLLQUANTITYTYPEOFSERVICE = "" || COLLCAPACITYSERVICEDESCRIPTION = "" || COLLUNITOFMEASURESERVICEDESCRIPTION = ""
            )
        ) = 0,
        true,
        false
    )
);

What is wrong with the code?

Thanks in advance.

[leyburn19 · Accepted solution]

try 

COLLQUANTITYTYPEOFSERVICE = Blank() || COLLCAPACITYSERVICEDESCRIPTION = Blank() || COLLUNITOFMEASURESERVICEDESCRIPTION = Blank()

[v-chenzhi]

Hi @Emont ,

Do you want to check if the item in the Gallery is empty?

Could you please tell me what’s your data source and what’s the type of COLLQUANTITYTYPEOFSERVICE and other columns?

I assume that you have this in SP and made a test on my side, please try the following workaround.

Set the OnSelect property of Button as following:

Set(
    validarinfo,
    If(
        CountRows(
            Filter(
                Gallery6.AllItems,
                COLLQUANTITYTYPEOFSERVICE.Value = Blank() || COLLCAPACITYSERVICEDESCRIPTION = Blank() || COLLUNITOFMEASURESERVICEDESCRIPTION = Blank()
            )
        ) = 0,
        true,
        false
    )
)

    

Best regards,

Zhi Chen