Unanswered

Disable Submit Button with Nested IF statement

(0) Share

Report

Posted on by Xinlin

I'm trying to disabled / edit a submit button on my form and this form has an "Instrument" dropdown field that allows users to choose A, B, C, D, E etc.

So if user chooses A, there will be few more related columns showing up for users to fill up relevant information.

I wish to disable the submit button if the relevant fields are not filled up. I tried to do it with Nested IF statement, but the button didn't disable accordingly. Wish to have someone to help me look into it because I wasn't sure which part of it went wrong.

Here's the logic I'm using:

If(
 !IsBlank(DataCardValue15.Selected.Value) && 
 !IsBlank(DataCardValue35_1) && 
 !IsBlank(DataCardValue36_1) && 
 !IsBlank(DataCardValue37_1) && 
 !IsBlank(DateValue2_1.SelectedDate),
 If(
 !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "A" 
 Or !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "B") && 
 !IsBlank(DataCardValue53_1) && !IsBlank(DataCardValue48_1) && 
 !IsBlank(DataCardValue49_1) && !IsBlank(DataCardValue50_1) && 
 !IsBlank(DataCardValue51_1)) 
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "C" Or 
 !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "D")) && 
 !IsBlank(DataCardValue52_1)
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "E" Or 
 !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "F")) && 
 !IsBlank(DataCardValue55_1)
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "G") && 
 !IsBlank(DataCardValue43_1.Selected.Value) && 
 !IsBlank(DataCardValue44_1.Selected.Value) && 
 !IsBlank(DataCardValue45_1.Selected.Value) && !IsBlank(DataCardValue46_1) && 
 !IsBlank(DataCardValue47_1)
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "H" Or 
 !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "I")) && 
 !IsBlank(DataCardValue54_1)
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "J") && 
 !IsBlank(DataCardValue39_1) && !IsBlank(DataCardValue40_1) && 
 !IsBlank(DataCardValue42_1)
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "K") && 
 !IsBlank(DataCardValue39_1) 
 && !IsBlank(DataCardValue40_1) 
 || !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "L") Or 
 !IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)' = "M") 
 ,DisplayMode.Edit,
 DisplayMode.Disabled
))

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
@Xinlin

With({_cond: Or(IsBlank(DataCardValue15.Selected.Value), IsBlank(DataCardValue35_1), IsBlank(DataCardValue36_1), IsBlank(DataCardValue37_1), IsBlank(DateValue2_1.SelectedDate) ) _instr: DataCardValue38_1.Selected.'Instrument (instrument)' },_cond && Switch( _instr, "A" || "B", Or(IsBlank(DataCardValue53_1), IsBlank(DataCardValue48_1), IsBlank(DataCardValue49_1), IsBlank(DataCardValue50_1), IsBlank(DataCardValue51_1) ), "C" || "D", IsBlank(DataCardValue52_1), "E" || "F", IsBlank(DataCardValue55_1), "G", Or(IsBlank(DataCardValue43_1.Selected.Value), IsBlank(DataCardValue44_1.Selected.Value), IsBlank(DataCardValue45_1.Selected.Value), IsBlank(DataCardValue46_1), IsBlank(DataCardValue47_1) ) "H" || "I", IsBlank(DataCardValue54_1), "J", Or(IsBlank(DataCardValue39_1), IsBlank(DataCardValue40_1), IsBlank(DataCardValue42_1) ), "K", Or(IsBlank(DataCardValue39_1), IsBlank(DataCardValue40_1) ), !("L" || "M"), //I'm not sure what you want to happen if "L' or "M" is selected ),DisplayMode.Disabled, DisplayMode.Edit ) )

Was this reply helpful? Yes No
Xinlin 82 on at

Like (0)

Report

I'm getting an unexpected warning towards the end of the code. As for L & M, I wish the button will be enabled if L or M is selected.

Thank you.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Xinlin

Delete the "," between the parentheses after "fixed income"

Was this reply helpful? Yes No
Xinlin 82 on at

Like (0)

Report

It came back with springy underline for the rest of the codes (sobs)

Was this reply helpful? Yes No
Verified answer

Al_10 1,691 Super User 2024 Season 1 on at

Like (1)

Report
@Xinlin

If( IsBlank(DataCardValue15.Selected.Value) || IsBlank(DataCardValue35_1.Text) || IsBlank(DataCardValue36_1.Text) || IsBlank(DataCardValue37_1.Text) || IsBlank(DateValue2_1.SelectedDate) || IsBlank(DataCardValue38_1.Selected.'Instrument (instrument)') || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["A", "B"] && ( IsBlank(DataCardValue53_1.Text) || IsBlank(DataCardValue48_1.Text) || IsBlank(DataCardValue49_1.Text) || IsBlank(DataCardValue50_1.Text) || IsBlank(DataCardValue51_1.Text) ) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["C", "D"] && IsBlank(DataCardValue52_1.Text) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["E", "F"] && IsBlank(DataCardValue55_1.Text) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["G"] && ( IsBlank(DataCardValue43_1.Selected.Value) || IsBlank(DataCardValue44_1.Selected.Value) || IsBlank(DataCardValue45_1.Selected.Value) || IsBlank(DataCardValue46_1.Text) || IsBlank(DataCardValue47_1.Text) ) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["H", "I"] && IsBlank(DataCardValue54_1.Text) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["J"] && ( IsBlank(DataCardValue39_1.Text) || IsBlank(DataCardValue40_1.Text) || IsBlank(DataCardValue42_1.Text) ) ) || ( DataCardValue38_1.Selected.'Instrument (instrument)' in ["K"] && ( IsBlank(DataCardValue39_1.Text) || IsBlank(DataCardValue40_1.Text) ) ) || ( !(DataCardValue38_1.Selected.'Instrument (instrument)' in ["L", "M"]) ) , DisplayMode.Disabled, DisplayMode.Edit )

Was this reply helpful? Yes No