i have a form tied to a SharePoint list. There are several fields that are required on the form where the fields aren't required in SharePoint. The form will submit and create a new record without values in the required fields. Is there anyway to fix this without making my fields required in SharePoint? I have several conditional required fields that I don't want to have to change in SP.
My solution would be to not allow the user to submit the form if the required field is not filled in. Try code like this in the DisplayMode property of the button.
If(TextInput_Required=Blank(), DisplayMode.Disabled, DisplayMode.Edit)
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."
I normally do this by disabling the Submit button until the required fields are filled in. The easiest way to do that is to use an IF() formula in the display Mode property of the button to test whether any of the fields are empty. If you have more than 3 fields then I switch to setting the OnChange property of each field to increment a variable if its filled in and decrement it if its empty. Then test that value to set the button to disabled if the number is not equal to or greater than the number of fields.
@mdevaney 's fingers are faster than mine, but I provided a bit more detail. Between the two you should be able to do what you want.