Unanswered

Only Submit If Required Fields are Filled Out before Sending Emailing and Saving to SharePoint List

(0) Share

Report

Posted on by 123testing321

Hello all,

I have a form that sends an email and sends the data from the form to a SharePoint list. But I want to make sure that the user fills out all the required fields before it sends an email and submits to a SharePoint list. I also want the required fields highlighted once they submit so that the user knows which fields are required - but of course make sure that it does not send an email and submits to SharePoint list before all required fields are filled out.

I have the code below (form sends email and sends data to SharePoint list, I've omitted the HTML code text which is hidden in the form):

Office365Outlook.SendEmailV2(DataCardValue38.Selected.Email,

"Title: " &DataCardValue30.Text

, HtmlText1_2.HtmlText,

{Cc: DataCardValue35.Selected.Email &";"& DataCardValue39.Selected.Email &";"&DataCardValue40.Selected.Email &";"& DataCardValue41.Selected.Email

,Importance: "High"

,Attachments: RenameColumns(DataCardValue42.Attachments,"Value", "ContentBytes" ) }
);




SubmitForm(Form1_2)

ResetForm(Form1_2);
NewForm(Form1_2);

Does anyone know how to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@123testing321

Turn off the required property of the columns in the SharePoint list and in your form, set the cards containing those fields to required property true. The form will do the rest.

Was this reply helpful? Yes No
123testing321 28 on at

Like (0)

Report
Copy link

Link copied!
Thanks for the reply.

The data cards that I would like to be required all have Required = True. For example the title card has it on:

I removed
ResetForm(Form1_2);
NewForm(Form1_2);
and it actually has that form error now that I'm expecting for required fields.

But if fill it out with a correct email, it sends an email upon submission even if the required fields are blank. However, it does not send data to the SharePoint list which is the expected result. Right now, it doesn't matter what I put on the form as long as there is a valid email address, it will automatically sends me an email and not wait for the form to be filled out correctly first. Do you know how to fix this?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@123testing321

The SubmitForm() button should not work if the required fields are not filled in and there should be nothing except SubmitForm(Form1_2) on the submit button. Any other commands should be In the OnSuccess property of the form. This belongs in the OnSuccess property of the form. It is executing before the OnSubmit()

Office365Outlook.SendEmailV2(DataCardValue38.Selected.Email, "Title: " &DataCardValue30.Text , HtmlText1_2.HtmlText, {Cc: DataCardValue35.Selected.Email &";"& DataCardValue39.Selected.Email &";"&DataCardValue40.Selected.Email &";"& DataCardValue41.Selected.Email ,Importance: "High" ,Attachments: RenameColumns(DataCardValue42.Attachments,"Value", "ContentBytes" ) } );

Was this reply helpful? Yes No
123testing321 28 on at

Like (0)

Report
Copy link

Link copied!

Thanks I think I'm getting close but there is now an error on sending email when I click on the submit button with all the required fields filled out:

With the code and properties above, it does not send an email anymore but only updates the SharePoint list. I'm not sure what's going wrong 😕

Was this reply helpful? Yes No
123testing321 28 on at

Like (0)

Report
Copy link

Link copied!
Also to add, I tried testing it with a static email instead of

Office365Outlook.SendEmailV2(DataCardValue38.Selected.Email,

...
And the email sent but not with DataCardValue38.Selected.Email

I'm going to try to restart the app because before DataCardValue38.Selected.Email was working. Unless you see any errors on the code that I am missing?

Was this reply helpful? Yes No
123testing321 28 on at

Like (0)

Report
Copy link

Link copied!

Restarted but same issues, unfortunately. Just to add as well, I'm dumbfounded by the fact that the CC works which has the same code as TO (e.g. Selected.Email) and I'm selecting the same email I've used for TO with CC but the TO field gives an error. 😕

Was this reply helpful? Yes No