Validate Dropdown box is not chosen

(0) Share

Report

Posted on by Boon-1

140

Hi all,

I am trying to change the display mode of my button based on the values of the input boxes, drop down box and date picker. The logic is like this: If all the values of input boxes are blank, or drop down box not selected ( default value shown is the choice from sharepoint) or date picker is not chosen (managed to set the date picker to blank), the display mode will be set to view.

I wrote the following syntax but couldn't get it working. Suspect that the error comes from the dropdown boxes. Anyone can advise how to resolve this?

If(IsBlank(NameInput) Or IsBlank(emailadd_5) Or IsBlank(PInput_4) Or IsBlank(TInput_5) Or IsBlank(ServiceInput_4) Or IsEmpty(Dropdown_4) Or IsBlank(O_Input_4) Or IsEmpty(P_Dropdown_5) Or IsBlank(E_Input_5) Or IsBlank(O_Input_5) Or IsBlank(T_Input_5) Or IsBlank(Activity_Input_5) Or IsBlank(DateofLast) Or IsBlank(DateofNext), DisplayMode.Edit, DisplayMode.View)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

It quite easier working with combobox on some of these issues. But you can try
Dropdown1.Selected.Value = Blank() || "" for all the Dropdowns.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Boon-1 140 on at

Like
a
(0)

Report
Copy link

Link copied!

Realise i have a typo for the syntax. Here is the revised on but still it doesn't work

If(IsBlank(NameInput.Text) Or IsBlank(emailadd_5.Text) Or IsBlank(PInput_4.Text) Or IsBlank(TInput_5.Text) Or IsBlank(STInput_4.Text) Or IsBlank(Ohm_Input_4.Text) Or IsBlank(Equip_5.Text) Or IsBlank(OPInput_5.Text) Or IsBlank(OTInput_5.Text) Or IsBlank(Activity_5.Text) Or IsBlank(DateLast.SelectedDate) Or IsBlank(DateNext.SelectedDate) Or IsEmpty(Dropdown_5.SelectedText.Value) Or IsEmpty(Dropdown_4.SelectedText.Value), DisplayMode.View, DisplayMode.Edit)

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Have tested with;

If(IsBlank(NameInput) Or IsBlank(emailadd_5) Or IsBlank(PInput_4) Or IsBlank(TInput_5) Or IsBlank(STInput_4) Or IsBlank(Ohm_Input_4) Or IsBlank(Equip_5) Or IsBlank(OPInput_5) Or IsBlank(OTInput_5) Or
IsBlank(Activity_5) Or IsBlank(DateLast.SelectedDate) Or IsBlank(DateNext.SelectedDate) Or Dropdown_5.SelectedText.Value =Blank() Or Dropdown_4.SelectedText.Value=Blank(), DisplayMode.View, DisplayMode.Edit)

You can further play with
Dropdown_4.SelectedText.ColumnName
If you have issues with the formula.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Boon-1 140 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Eska,

My dropdown box by default shows the first item of the choices in SharePoint list and therefore it is not blank. How do i check if the user has made changes on the choice selected ? And there is also another problem that the choice could be the value that he is selecting?

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

If don't want the dropdown Automatically have an item, change the AllowEmptySelection property of the dropdown to true.
This should solve both problems.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Boon-1 140 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Eka24, I managed to get it working !

Was this reply helpful? Yes No