Unanswered

LastSubmit not working correctly in html post form success

(0) Share

Report

Posted on by holtzclaw42

I have a form that when successfully executed does the following:

Office365.SendEmail(PurchasingEmail, "New Supply Order Request, Order#: "&SupplyRequestView_Form.LastSubmit.ID&" has been approved.", SupplyRequestApproved_HTML.HtmlText, {Importance:Normal, IsHtml:true, Cc:MFGLeadsEmail&","&MFGManagersEmail})

The ID returns correctly in the subject field of the email.

As seen above, the body is HTML. Here's an applicable snippet:

<tr>
<td width=49%>" & " Order Number " & "</td>
<td width=1%>:</td>
<td width=50%>" & SupplyRequestView_Form.LastSubmit.ID & "</td>
</tr>

The SupplyRequestView_Form.LastSubmit.ID works in the subject, but NOT in the HTML email. It and all other fields in the HTML when calling against the .LastSubmit method return blank.

What am I missing here? This is extremely frustrating. I have certain forms where the post-success .LastSubmit call works perfectly fine in HTML emails and others, such as in this example, where I get nothing but blanks. I can't find a causal relationship. Any help or insight would be extrememly appreciated!

Thanks,

Stephen

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

holtzclaw42 10 on at

Like
a
(0)

Report
Copy link

Link copied!

As a further update, I've discovered the following:

This works perfectly when tested through the edit application (via development mode). All .LastSubmit values are gathered and populated correctly in the email.

However, when tested as a deployed app (outside of development mode) the .LastSubmit values are not populated in the email.

Another observation is that when the form is in new mode, the emails with the .LastSubmit method appear to work perfectly when SubmitForm is invoked.

However, when a form is in edit mode, the emails with the .LastSubmit method appear to not work and return blank values consistently when SubmitForm is invoked.

That seems like more than a coinsedence. Any thoughts?

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

Like
a
(0)

Report
Copy link

Link copied!

I also have the same problem.

Any suggestion ?

Was this reply helpful? Yes No
sgrpdl 109 on at

Like
a
(0)

Report
Copy link

Link copied!

Any body got the solution.. I too have same issues. Any one found the solution for this??

@holtzclaw42 wrote:
As a further update, I've discovered the following:

This works perfectly when tested through the edit application (via development mode). All .LastSubmit values are gathered and populated correctly in the email.

However, when tested as a deployed app (outside of development mode) the .LastSubmit values are not populated in the email.

Another observation is that when the form is in new mode, the emails with the .LastSubmit method appear to work perfectly when SubmitForm is invoked.

However, when a form is in edit mode, the emails with the .LastSubmit method appear to not work and return blank values consistently when SubmitForm is invoked.

That seems like more than a coinsedence. Any thoughts?

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

Like
a
(0)

Report
Copy link

Link copied!

Bumping for visibility

@Anonymous

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks for checking in..
Just I posted in my previous post. Everything works fine except for the last part...

I am sending a notification email directly from PowerApp (without using a flow), everything works fine except From email is the showing as requester email id, is there a way we can change from email to any specific Shared mailbox which my group uses.
I have done this in the flow where we define from to our shared mailbox but I don't know how to do this from PowerApps.

Was this reply helpful? Yes No
sgrpdl 109 on at

Like
a
(1)

Report
Copy link

Link copied!

What i did for my html case, and this worked for me..

<p>ID: "& Last('Sharepointlistnamehere').ID+1 &" </p>

---

Last('Sharepointlistnamehere').ID+1

Was this reply helpful? Yes No
sgrpdl 109 on at

Like
a
(0)

Report
Copy link

Link copied!

on Success of your form
ON Success: Set(VarLSID,FormTAF.LastSubmit.ID)
you can use that Global var any where then..

Was this reply helpful? Yes No