Unanswered

If and else if statement

(0) Share

Report

Posted on by bsr1

Hi,

I want to submit a form once some conditions are met. The first condition is to check the status (DataCardValue105). If status is "In progress", the form is submitted. If status is "Completed", some other condition apply - all mandatory fields should be filled in. If the mandatory fields are blank, a warning message should show up.

I have tried this:

If(DataCardValue105.Selected.Value = "Completed" , If 
(DataCardValue79.SelectedDate = Blank() && DataCardValue80.Selected.Value = Blank() && 
DataCardValue81.Selected.Value = Blank() &&
DataCardValue82.Text = Blank() && 
DataCardValue83.Text = Blank() && 
DataCardValue84.Selected.Value = Blank() && 
DataCardValue85.Selected.Value = Blank() && 
DataCardValue86.Selected.Value = Blank() && 
DateValue5.SelectedDate = Blank() && 
DateValue6.SelectedDate= Blank(),
UpdateContext({textboxvisible:true}), SubmitForm(Form2)), SubmitForm(Form2));

Using this code, the form is submitted even though status is completed and mandatory fields are blank.

Can anyone help me with this?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

timl 36,965 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @bsr1

If your actual intention is to test the entry of data based on an 'Or' condition, that would be one explaination as to why your forumula doesn't behave as expected (eg, dispaly the warning message if DataCardValue82.Text is blank OR DataCardValue83.Text is blank etc).

In this case, you can change the && operator to the || operator.

If(DataCardValue105.Selected.Value = "Completed" && (DataCardValue79.SelectedDate = Blank() || DataCardValue80.Selected.Value = Blank() || DataCardValue81.Selected.Value = Blank() || DataCardValue82.Text = Blank() || DataCardValue83.Text = Blank() || DataCardValue84.Selected.Value = Blank() || DataCardValue85.Selected.Value = Blank() || DataCardValue86.Selected.Value = Blank() || DateValue5.SelectedDate = Blank() || DateValue6.SelectedDate= Blank()), UpdateContext({textboxvisible:true}), SubmitForm(Form2));

Was this reply helpful? Yes No
bsr1 27 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have encountered an issue with the formula above. It seems to work only when drop down Data Card is left in blank. When I leave a text Data Card Value blank, it is still possible to submit the form. How can I force that the Data Card Value Text should be filled in when status is Completed?

Was this reply helpful? Yes No