Including Line Items from Canvas app in and Email

(0) Share

Report

Posted on by SwedUSCrm

Hello All,

No Idea how to accomplish what I am wanting to do, so I am hoping for some guidance or reference to an example.

I have built a Canvas App that creates and Order. The order is comprised of a header and line items. When the order is submitted, an email is sent. In the email I can easily include information from the header, but I would like to also include a list of the items on the order. There is a relationship between the order header and the order line items.

Not sure how to go about doing this.

Thoughts? Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

rpersad 831 on at

Like (0)

Report
Copy link

Link copied!
If you want to retrieve the data you can use the LastSubmit function to retrieve the last row that was submitted to your data source and store it into a variable. Example:
Set(var, 'DataSource Name'.LastSubmit)
Then in the email body just reference back the variable and the column that you want to send in your email. NOTE: You must ensure that the value is a text.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @SwMatchUS,

Generally, Form.LastSubmit works for only the current session of the app, however it only works for an edit form.

However, it is still a correct direction.

If you exit the app and next time you enter the app, the Form.LastSubmit won't work if you don't submit a form.

Based on your previous operation, you could include info from the header and there is relationship between header and other order info, you could use the LookUp() function:

LookUp(list,Header=xxx).OrderInfo

If all this happened in the same session, you could directly refer each field of your submitted item:

FormName.LastSubmit.FieldName

Was this reply helpful? Yes No
SwedUSCrm 87 on at

Like (0)

Report
Copy link

Link copied!

Hi @rpersad

You mention the last row submitted. The order would have multiple lines, so I would want to retrieve all lines related to the header and list in the email.

Was this reply helpful? Yes No