cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ianallen13
Helper III
Helper III

How to make drop down required before submission

Hi everyone, 

 

I wanted to see if there was an easy way to mark a drop down item 'required' so that it has to be changed/selected before the form is submitted.  I saw some examples if the drop down is BLANK, but mine are drop down lists that at the top state: "Please Select" - so is there a way to bypass this at all?  

 

Here is my 'Submit' Code: 

 

Patch('CU QA Post Qualification PA',Defaults('CU QA Post Qualification PA'),
{Specialist:'Specialist Drop Down_Eval'.Selected.Specialist,
Supervisor:'CU Supervisor_Eval'.Text,
'Case Number':Case_Number_Eval.Text,
'CU QA Comments':CU_Comments_Eval.Text,
'CU Program':CU_Program_Eval.Selected.'CU Programs',
'CU QA Score':Value(CU_Score_Eval.Text),
Session:CU_Session_Eval.Selected.'CU Sessions',
'Case Completed Date':Case_Completed_Date_Eval.SelectedDate,
'CU Email Address SP':'Specialist Drop Down_Eval'.Selected.Email,
'Quality Review':CU_Quality_Review_Eval.Selected.'CU Quality Reviews',
'CU Service Errors':Left(Concat(CU_Eval_Findings.SelectedItems, 'CU Evaluation Findings'& ","), Len(Concat(CU_Eval_Findings.SelectedItems,'CU Evaluation Findings' & ","))-1),
'CU Service Type':"Evaluations"});
Navigate('Submission Success Screen',Fade)

 

And example of one of my drop down items (See attached): 

7 REPLIES 7
mdevaney
Super User
Super User

@ianallen13 

Change the DisplayMode property of your submit button to this code:

 

If(Dropdown1.Selected.Value=“Please Select”,DisplayMode.Disabled, DisplayMode.Edit)

 

Now your button cannot be clicked unless the button the dropdown is filled

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

 

 

KroonOfficeSol
Resident Rockstar
Resident Rockstar

You could better replace your dropdowns with comboboxes. These can be not selected and gives you a hinttext for your please select....

 

Yes I know this will take some time, but will sure benefit you in the long run.

 

Paul

Hello and thank you for the response.  I tried this, but must have something wrong: 

 

If('Specialist Drop Down_Eval'.Selected.Value="Please Select",DisplayMode.Disabled, DisplayMode.Edit)

 - I get the red squiggle line under Value, and when I replaced it with 'specialist' - it still let me submit it with no problem when I had only the Please Select on.  Did I miss anything?

KroonOfficeSol
Resident Rockstar
Resident Rockstar

Also, this is a form, is that right? Why use Patch formula then?

 

You can just do SubmitForm(YourForm) and the form will do the patch for you. On the OnSuccess of the form you can then put then Navigate().

 

Also, when I right you can set required to true on the datacard. Not sure here, but I will check later.

 

Hope this helps.

 

Paul

@ianallen13 
Can you please share a screenshot of what your app looks like when the ComboBox is showing "Please Select"?  Make sure to include formula bar in the screenshot and control name highlighted in the left-side menu.

I have a few ideas why this might be happening and seeing the app usually helps me to diagnose.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
   

 

KroonOfficeSol
Resident Rockstar
Resident Rockstar

Also.

 

If you want/need to use Patch formula then you have to validate the input before you use Patch. How to do this? I made a video a while back, you can find it here 

https://youtu.be/8ICx6pg0VMA

 

Reason is that when you Patch required should be set in the datasource.

 

Paul

This video link worked perfect for me. 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,333)