Button DisplayMode

(2) Share

Report

Posted on by JM-14081323-0

114

Hi All,

trying to disable the button. Trouble is with the For All, because I need to check every single item in a gallery and its dropdown text that it is not empty (says expected boolean, number, decimal, text, dynamic). It works without the For All thing. Thanks for help.

If(
    IsEmpty(
        colVyber
        ) Or 
    IsBlank(
        Value(
            datPlan.SelectedDate)
        ) Or 
    ForAll(galPlanDelnik.AllItems As stred;
        IsBlank(
            stred.drpTextP.Text
        )
    );
    DisplayMode.Disabled;
    DisplayMode.Edit
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Haque 849 on at

Like (0)

Report
Copy link

Link copied!
Hi @JM-14081323-0,

ForAll(galPlanDelnik.AllItems As stred; IsBlank(stred.drpTextP.Text) )

From this above code we are basically getting a table of true/false values — not one Boolean. That’s why the formula engine complains. Reference is here.

We can go for CountIf - counts how many items in the gallery have a blank items. If that count is greater than 0, disable the button.

If( IsEmpty(colVyber) || IsBlank(Value(datPlan.SelectedDate)) || CountIf(galPlanDelnik.AllItems, IsBlank(drpTextP.Text)) > 0, DisplayMode.Disabled, DisplayMode.Edit )

One more option is Filter - we retrieve only the items with blank dropdowns. If that filtered set is not empty, disable the button.

If( IsEmpty(colVyber) || IsBlank(Value(datPlan.SelectedDate)) || !IsEmpty(Filter(galPlanDelnik.AllItems, IsBlank(drpTextP.Text))), DisplayMode.Disabled, DisplayMode.Edit )

Please let me know if this works for you.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
Suggested answer

DP_Prabh 293 on at

Like (1)

Report
Copy link

Link copied!

Hi @JM-14081323-0,

In case of ForAll it didn't work because it returns a table not a Boolean value (true/false).

If you want to check whether in dropdown any choice is selected, then show the submit btn or else don't. You may use the CountIf functions. I've tested same scenario at my end. Here are my findings:

Replace ForAll with CountIf function

If dropdown is having any value, it submits button will be visible or else it will be disabled.

Code: Button -----DisplayMode property:

If(

IsEmpty(colTest) ||

IsBlank(drpTest.Selected.Value) ||

CountIf(

Gallery1.AllItems,

Coalesce(drpTest.Selected.Value, "") = ""

) > 0,

DisplayMode.Disabled,

DisplayMode.Edit

)

I hope this works for you!

Was this reply helpful? Yes No
Suggested answer

11manish 395 on at

Like (1)

Report
Copy link

Link copied!
Why your formula fails

ForAll(galPlanDelnik.AllItems As stred;
IsBlank(stred.drpTextP.Text)
)

ForAll() returns a table, not a single true/false value

But If() needs:

Boolean (true/false)

Hence the error:

Expected Boolean, number, decimal, text…

Best solution

You want:

“Disable button if ANY dropdown is blank”

Use CountIf() instead:

If(
IsEmpty(colVyber) ||
IsBlank(datPlan.SelectedDate) ||
CountIf(galPlanDelnik.AllItems, IsBlank(drpTextP.Text)) > 0,
DisplayMode.Disabled,
DisplayMode.Edit
)

Was this reply helpful? Yes No