Trying to prevent save on empty text box and combobox on SharePoint form

[SPS-DEV-22]

Been trying to resolve this for a couple of days now here is the issue:

I have custom code for a combo box.

when you select "Other" then a text box become visible. Currently if you select "Other" with nothing entered in the Combo Box and or the "Other Text Box" people are able to save the form.

The issue is, I need to prevent both items being blank when people go to save the form.

I'm not sure where to put the code below at to prevent the save if the items are blank

If(IsBlank(txt_Name.Text),"This is a Required Field") &

If(IsBlank(cmb_Name.Text),"This is a Required Field")

this was recommended to try on a prior post, which got abandoned

on #2 the Error Message Label, what is considered the Label?

1. Delete this Data Card and re-add it and see if that resolve the issue. 
2. In the Error Message label put this formula: If(IsBlank(YourInputText.Text),"This is a Required Field")

not sure what to do, as I have the code for the IsBlank almost everywhere in the form, except the right location to prevent a save if the combo box (cmb_Name) and the Text Box (txt_box) are blank.

How do I prevent the form from being saved to the SharePoint list if the fields are Blank?

[RandyHayes]

@jashi3m 

IsBlank and IsEmpty are two entirely different checks on two entirely different types of data...why would you do both on a Selected property?

@SPS-DEV-22 

Please review the response I provided you where you are going to actually use the .Valid property of your form as it was intended.  Let me know if you run into issues with it.

[SPS-DEV-22]

@RandyHayes

this code:
what do I put in the <value> as :

IsBlank(cmb_Name.Selected.<value>) ||
(cmb_Name.Selected.<value> = "Other" && IsBlank(txt_Name.Text))

 it is throwing an error.

What is the value item?

Which formula are you referring to?

If(ErrorMessage17.Visible,
Blank(),
<yourCurrentUpdateFormulaHere>
)

As I have a lot of code mentioned in this .

[RandyHayes]

@SPS-DEV-22 

What is the Items property of cmb_Name?

The second Formula goes in your Update property of your datacard.  What is the current Formula in that property?

[SPS-DEV-22]

@RandyHayes

What is the Items property of cmb_Name?

Ungroup(
Table(
{DropdownOptions: Choices([@'NOPDAI Activity Form'].'NOPDAI Name or Interpreter Name')},
{DropdownOptions: ["Other"]}
),
"DropdownOptions"
)

there is no update property for the Datacard for the cmb_Name  (update, I found it I was looking in wrong area)

update Property for the Name_Datacard1

If(
cmb_Name.Selected.Value="Other",
{Value: txt_Name.Text},
cmb_Name.Selected
)

[RandyHayes]

@SPS-DEV-22 

Very good, then the Label Visible Formula should be changed to the following:

IsBlank(cmb_Name.Selected.Value) ||
(cmb_Name.Selected.Value = "Other" && IsBlank(txt_Name.Text))

Click on your Name_DataCard1 datacard and then look in the property dropdown (or in the property pane) for the Update property.  Unless the card is a custom card (you added it without a field), or it is read-only, it will have an Update property.  Need that formula!

[SPS-DEV-22]

@RandyHayes

I'm getting confused, as I have a small laptop screen, trying to find your info. (sorry for the repeating)

where do I put this at?

IsBlank(cmb_Name.Selected.Value) ||
(cmb_Name.Selected.Value = "Other" && IsBlank(txt_Name.Text))

 I put the above in the error message visible property.

update Property for the Name_Datacard1:

If(
cmb_Name.Selected.Value="Other",
{Value: txt_Name.Text},
cmb_Name.Selected
)

[RandyHayes]

@SPS-DEV-22 

The formula provided goes in the Label Visible Property

Change your Update property of your DataCard to the following:

If(ErrorMessage17.Visible, Blank(),
   cmb_Name.Selected.Value="Other", {Value: txt_Name.Text},
   cmb_Name.Selected
)

[SPS-DEV-22]

@RandyHayes

I believe you are saying when you say Label Visible property:  

you are referring to the Error Message17 item visible property

At this point the Valid property of your form will be accurate and you can use this for your DisplayMode property of the submit button:

If(SharePointForm1.Valid, Disabled, Edit)

I do not have a submit button, I have  OnNew | OnSave  | OnEdit. do I put the above code in the OnSave?

[RandyHayes · Accepted solution]

@SPS-DEV-22 

Yes, this is the label you want to change - ErrorMessage17

Set the visible property of that label to:

IsBlank(cmb_Name.Selected.Value) ||
(cmb_Name.Selected.Value = "Other" && IsBlank(txt_Name.Text))

You will not be able to "disable" a control for submitting.  You will only be able to stop it from doing so.

In your SharePointIntegration object (look in your control tree in the left pane of the designer), you will find the OnSave action.

In that action you will find the formula:  SubmitForm(SharePointForm1)

Change that to:  If(SharePointForm1.Valid, SubmitForm(SharePointForm1))

[SPS-DEV-22]

thanks @RandyHayes,

this worked.  this helped me out big time.