Answered

If drop down = x and date is blank then notify else save

(0) Share

Report

Posted on by BPNJMC1

Hello,

I'm trying to validate the form inputting before saving and the = sign in the if condition part of the statement is showing an error. I've tried evaluating the selected text and the value of the selected text, but can't seem to get the syntax correct.

For example (these both do not work):

(drpGoalStatusKey.SelectedText = "Achieved" || drpGoalStatusKey.SelectedText = "Not Achieved") && IsBlank(dteGoalEndDate)

(drpGoalStatusKey.Selected = 3 || drpGoalStatusKey.Selected = 4) && IsBlank(dteGoalEndDate)

If((drpGoalStatusKey.SelectedText = "Achieved" || drpGoalStatusKey.SelectedText = "Not Achieved") && IsBlank(dteGoalEndDate)
 , Notify("Save cancelled because end date should not be blank if status is achieved or not achieved.")
 , SubmitForm(frmGoals);
 );

Could someone please help me correct this?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BPNJMC1 ,

Would you please share the items property shared with the dropdown. If it is collection dropdown.selected.columnname should else dropdown.selected.text should work.

Was this reply helpful? Yes No
BPNJMC1 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PriyankaGeethik,

The source for the drop down is an Azure SQL table.

Thanks,
J

Was this reply helpful? Yes No
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BPNJMC1 ,

Would you mind trying below code.

If((drpGoalStatusKey.Selected.GoalStatusName = "Achieved" || drpGoalStatusKey.Selected.GoalStatusName = "Not Achieved") && IsBlank(dteGoalEndDate) , Notify("Save cancelled because end date should not be blank if status is achieved or not achieved.") , SubmitForm(frmGoals); );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

IsBlank(date) returns true or false, so you need to insert something like:

(drpGoalStatusKey.SelectedText = "Achieved" || drpGoalStatusKey.SelectedText = "Not Achieved") && IsBlank(dteGoalEndDate) = true,
Notify("");
SubmitForm(Form1)

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

And maybe, you need to do sometihng like:

drpGoalStatusKey.Selected.value = "Achieved"

Was this reply helpful? Yes No
BPNJMC1 72 on at

Like
a
(0)

Report
Copy link

Link copied!

@PriyankaGeethik ,

That worked! Thank you so much!

J

Was this reply helpful? Yes No