Nested If Statement problem

(0) Share

Report

Posted on by Marty3012

Hi, hope someone can help me with my problem.

I have an Icon that has the following code in its 'DisplayMode' property;

If(IsBlank(TextInput_1) ||
IsBlank(TextInput_2) ||
IsBlank(TextInput_3) ||
IsBlank(ComboBox_1) ||

IsBlank(ComboBox_2) ||
IsBlank(ComboBox_3), DisplayMode.Disabled, DisplayMode.Edit)

This works as when all the text inputs and comboboxes are filled the icon is then visible. However, I would also like to introduce the following statement into to the above code;

If(IsBlank(ComboBox_4) || IsBlank(TextInput_4),DisplayMode.Disabled, DisplayMode.Edit)

So basically the above statement is assessed on its own and then the result is assessed along with the other statements. Example below (which doesn't work);

If(IsBlank(TextInput_1) ||
IsBlank(TextInput_2)||
IsBlank(TextInput_3)
IsBlank(ComboBox_1) ||
IsBlank(ComboBox_2) ||
IsBlank(ComboBox_3) ||
If(IsBlank(ComboBox_4) || IsBlank(TextInput_4)),
DisplayMode.Disabled, DisplayMode.Edit)

I've tried various other ways but just can't get it to work. Any help appreciated.

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report
Heya, so first of all you should be referencing the property of each control that you want to check for Blanks, not the control itself directly - often it does understand and get the right property but I have had many times in the past where it checks a different property of the control rather than the Text or etc - this is especially true for combo boxes where the item in the combo box could have many fields and the IsBlank could check a different property.

Then regarding your question about the nested if, you need to have the inner if as part of the 'then' which creates a new layer of 'if':

If( IsBlank(TextInput_1) || IsBlank(TextInput_2) || IsBlank(TextInput_3) || IsBlank(ComboBox_1) || IsBlank(ComboBox_2) || IsBlank(ComboBox_3), //Then If( IsBlank(ComboBox_4) || IsBlank(TextInput_4), //Then - Nested inner DisplayMode.Disabled, DisplayMode.Edit ), //Else condition for when none of the above are true DisplayMode.Edit )

Cheers,

Sancho

Was this reply helpful? Yes No
Marty3012 on at

Like (1)

Report
HI @iAm_ManCat
Thanks for your quick response. I used your solution and there are no more errors. However I noticed a couple of things;
When I fill out the fields and fill the Combobox_4 and TextInput_4 fields last, all works ok and the icon is made editable
If I fill out Combobox_4 and TexInput_4 first, then the icon becomes editable and doesn't take into account that the rest of the fields are blank.
Should also say that once all fields have a value and I then change the Combobox_4 and TextInput_4, the icon still stays enabled. Thanks

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report
Ah, so there may have been a misunderstanding based on your original code, I'll change it based on what you've described and put more comments in the code - if you can just let me know if that's correct and if not then how you want the logic to work:

If( IsBlank(TextInput_1) || IsBlank(TextInput_2) || IsBlank(TextInput_3) || IsBlank(ComboBox_1) || IsBlank(ComboBox_2) || IsBlank(ComboBox_3), // If any of the above are blank, make it disabled DisplayMode.Disabled, // Otherwise, if none are blank, check this condition If( IsBlank(ComboBox_4) || IsBlank(TextInput_4), // If either of the above two are blank then make it disabled DisplayMode.Disabled, // If none of the fields are blank, then make it enabled DisplayMode.Edit ) )

Cheers,

Sancho

Was this reply helpful? Yes No
Marty3012 on at

Like (1)

Report

Thanks, that works!

Was this reply helpful? Yes No