Answered

Not submit a form if a validation is empty

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I've a question, a I've a form that sends a email if all the records are complete (required), but the problem is if a record is empty the submit still works and send the email and update the data.

This is my formula.

If(
DataCardValue66.SelectedText.Value = "EN GESTIÓN";
SubmitForm(Form3);;
Navigate(
RetenciónInside;
ScreenTransition.None
);
If(
DataCardValue66.SelectedText.Value = "REPROGRAMADO";
SubmitForm(Form3);;
Navigate(
RetenciónInside;
ScreenTransition.None
);
If( DataCardValue66.SelectedText.Value = "NO CONTENIDO";
SubmitForm(Form3);;
Navigate(
RetenciónInside;
ScreenTransition.None
);

Office365Outlook.SendEmailV2(
"Sergio.Rivadeneyra@prosegur.com; juan.rincon@prosegur.com; carmen.becerra@prosegur.com; alan.espinoza@prosegur.com; diego.fajardo@prosegur.com; "&DataCardValue70;
"Contención comercial: " & "Contrato: " &DataCardValue21 & " Actividad: "&DataCardValue71;
"Se realiza la contención del contrato. " & DataCardValue21 & " Se adjunta conformidad del cliente.";
{
Attachments: AddColumns(
RenameColumns(
DataCardValue69.Attachments;
"Value";
"ContentBytes"
);
"@odatabyte";
""
)
}
)
)
);
ClearCollect(CollectAdjunto;DataCardValue69.Attachments);
SubmitForm(Form3);;
Navigate(
RetenciónInside;
ScreenTransition.None
)
)

I would like to know, how i can do to not submit and send the information if a record is empty as a required.

I'll waitinf for your comments.

Best Regards.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous , the formula contains "NO CONTENIDO"...
In this place you want to reset form (not submit) and send the notification?

Or you are trying to write above all this another If IsBlank( (SOMETHING) ) then only SendEmail ?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous and thank you for your soon reply.

My mistake for not gave all the details, sorry. The email send if it's "CONTENIDO", in this part my editform has a required item thatr is attachments, if this required item its not complete the sudmit and send information should not work, but stills works, even the property "required" its true.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It's complicated for me to understand.
If the value of the field contains "CONTENIDO" or "WHATEVER" or "BLA_BLA", and the field require value, the logic will pass everything, because the field is not empty.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thank you for your soon reply,
I'll send you some pics for a better vision.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,
Note that I have not validated he email part - just used your existing code - also not completely sure on your logic, but the below will submit the form and send the email if the status is one of the three values, otherwise do a collection and submit the form.
With( { vSelect:DataCardValue66.SelectedText.Value }, If( vSelect ="EN GESTIÓN" || vSelect= "REPROGRAMADO" || vSelect = "NO CONTENIDO" Office365Outlook.SendEmailV2( "Sergio.Rivadeneyra@prosegur.com; juan.rincon@prosegur.com; carmen.becerra@prosegur.com; alan.espinoza@prosegur.com; diego.fajardo@prosegur.com; "&DataCardValue70; "Contención comercial: " & "Contrato: " & DataCardValue21 & " Actividad: "&DataCardValue71; "Se realiza la contención del contrato. " & DataCardValue21 & " Se adjunta conformidad del cliente."; { Attachments: AddColumns( RenameColumns( DataCardValue69.Attachments; "Value"; "ContentBytes" ); "@odatabyte"; "" ) } ); ClearCollect(CollectAdjunto;DataCardValue69.Attachments);; ) );; SubmitForm(Form3);; Navigate(RetenciónInside;ScreenTransition.None)

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mr.@WarrenBelz
Thank you for your reply and I'm really sorry for answer you really late, I had some personal problems.

I could resolve my problem thank you for worried about that.

Best Regards.

Diego Fajardo Feijoo.

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Anonymous ,
If my post helped you solve your issue, please consider Accept as solution This will help others find it more readily. It also closes the item.

Was this reply helpful? Yes No