Answered

Stop form submission if fields are blank

(0) Share

Report

Posted on by RHADAVE

Sorry if this has been posted before.

I have a form linked to a sharepoint list. Im trying to make the forms mandatory and reading around i can use displaymode on the button with this command

If(IsBlank(DataCardValue2) && !IsBlank(Title) && !IsBlank(DateValue3) && !IsBlank(HourValue3) && !IsBlank(MinuteValue3) && !IsBlank(DataCardValue21) && !IsBlank(DataCardValue22) && !IsBlank(DataCardValue25),DisplayMode.Disabled)

But its not working. have i done something wrong?

Screen shot

Thank you in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

C-Papa 1,836 on at

Like (0)

Report

Hi, select the datacard, the select Required from the menu and change to true

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@RHADAVE

You need not do all the comparisons (and, you will want to compare the property of the control, not the control - i.e. DataCardValue22.Text, not just DataCardValue22).

If your field is required in the form, then simply set your submit logic to:

If(yourForm.Valid, SubmitForm(yourForm))

It will do all the other comparisons for you.

I hope this is helpful for you.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@RHADAVE

Oh, and noticing that you were using this for the DisplayMode...so the formula would be:

If(Form7.Valid, Edit, Disabled)

Was this reply helpful? Yes No
RHADAVE 53 on at

Like (0)

Report

thank you so much. ill give it a try this morning!

I really appreciate the help 🙂

Was this reply helpful? Yes No
Verified answer

RHADAVE 53 on at

Like (3)

Report

Hi mate, using
If(Form7.Valid, Edit, Disabled)
As soon as i fill in "requester" and "title" the button goes to orange which is the enabled colour...

Was this reply helpful? Yes No
Verified answer

C-Papa 1,836 on at

Like (2)

Report

This will most likely be because you have not set the other fields as required. the Form7.Valid function is deciding if the form is ready to go, so if for example all fields had required set to false, your button would always be orange / in edit mode, but if all fields were set to required (true) the button will not change to orange / edit mode until the last input value has been filled out in the form.

Was this reply helpful? Yes No
RHADAVE 53 on at

Like (1)

Report

OMG!!! IT WORKS!!! Yeeeeeeeeeeeeeeaaaaaaaaaahhhhhhh!

You have no idea how much i appreciate the help.

I have never used PowerApps until 2 weeks ago, and its been a steep uphill climb trying to build this. Last bit of coding i touched was visual basic 16 years ago in I.T boot camp!

Was this reply helpful? Yes No
RHADAVE 53 on at

Like (0)

Report

Just wondering, is there a command i can use to display a message if the disabled "send request" button is pressed when the form is blank, instead of using a tool tip. Just a friendly prompt if someone has missed something out. It Avoids me getting lots of phone haha

thank you

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@RHADAVE

If it is disabled...then users can't click on it!

Was this reply helpful? Yes No