Answered

Order of code is causing one option to not submit

(0) Share

Report

Posted on by Gtruddy5922

Hello, I am confused and trying to understand why everything in this code below works accept if I choose Assigned as an option it will only send the email not submit the form. I also assume there is a more streamlined way to write this code out.

Any help would be appreciated!

If(
DataCardValue14.Selected.Value = "Assigned", Office365Outlook.SendEmailV2("......","Your request has been accepted and is being worked on”","Body");
DataCardValue14.Selected.Value = "New", UpdateContext({DenialPopUpVIS:false});
DataCardValue14.Selected.Value = "Assigned", UpdateContext({DenialPopUpVIS:false});
DataCardValue14.Selected.Value = "Complete", UpdateContext({DenialPopUpVIS:false});
DataCardValue14.Selected.Value = "Denied", UpdateContext({DenialPopUpVIS:true});
({DenialPopUpVIS:false}), SubmitForm(Form1))

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

It's because the if statement will not check the rest of the options once one has returned true- You should update the context variable in the same 'true value' as you send the email.

Hope this helps!

Was this reply helpful? Yes No
Gtruddy5922 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you possibly show what this would look like?
Thanks!

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
You might have to make some minor modifications, but it could be something like this:
If( DataCardValue14.Selected.Value = "Assigned", Office365Outlook.SendEmailV2( "......", "Your request has been accepted and is being worked on”", "Body" ); UpdateContext({DenialPopUpVIS:false}), DataCardValue14.Selected.Value = "New", UpdateContext({DenialPopUpVIS:false}), DataCardValue14.Selected.Value = "Complete", UpdateContext({DenialPopUpVIS:false}), DataCardValue14.Selected.Value = "Denied", UpdateContext({DenialPopUpVIS:true}) ); If( ({DenialPopUpVIS:false}), SubmitForm(Form1) )

Was this reply helpful? Yes No
Gtruddy5922 22 on at

Like
a
(0)

Report
Copy link

Link copied!

This did not work for me, do you have any other ideas?

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

how didn't it work- Is it throwing errors, or same issue as before? or something else entirely?

Was this reply helpful? Yes No
Gtruddy5922 22 on at

Like
a
(0)

Report
Copy link

Link copied!
All of this was marked as an error.
If( ({DenialPopUpVIS:false}), SubmitForm(Form1) )

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What's the error?

Was this reply helpful? Yes No
Gtruddy5922 22 on at

Like
a
(0)

Report
Copy link

Link copied!

I hope this is what you mean

Was this reply helpful? Yes No
Verified answer

madlad 2,637 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Woops... I accidentally messed up the code I sent you it seems 😐
try
If( DataCardValue14.Selected.Value = "Assigned", Office365Outlook.SendEmailV2( "......", "Your request has been accepted and is being worked on”", "Body" ); UpdateContext({DenialPopUpVIS:false}), DataCardValue14.Selected.Value = "New", UpdateContext({DenialPopUpVIS:false}), DataCardValue14.Selected.Value = "Complete", UpdateContext({DenialPopUpVIS:false}), DataCardValue14.Selected.Value = "Denied", UpdateContext({DenialPopUpVIS:true}) ); If( DenialPopUpVIS, SubmitForm(Form1) );

I should also mention that this code assumes you only submit if DenialPopupVIS is true. If that's not the case, and you always submit, try this instead:
If( DataCardValue14.Selected.Value = "Assigned", Office365Outlook.SendEmailV2( "......", "Your request has been accepted and is being worked on”", "Body" ); UpdateContext({DenialPopUpVIS:false}), DataCardValue14.Selected.Value = "New", UpdateContext({DenialPopUpVIS:false}), DataCardValue14.Selected.Value = "Complete", UpdateContext({DenialPopUpVIS:false}), DataCardValue14.Selected.Value = "Denied", UpdateContext({DenialPopUpVIS:true}) ); SubmitForm(Form1);

Was this reply helpful? Yes No
Gtruddy5922 22 on at

Like
a
(0)

Report
Copy link

Link copied!

That works! Thank you!!!

Was this reply helpful? Yes No