Unanswered

Notification flow for each case created

(0) Share

Report

Posted on by MartinVargas

312

Hi comunnity, I am working with the following invoice, and my question is, what is the correct procedure to send this information with this data?. I am using entities from dataverse.

And this is my notification flow. Basically what it is doing is that for each OrderLine that it creates an email is sent with all this data.

What I am looking for is to send all the data of this invoice, in a single email:

Can anybody help me out here ?

Cheers folks.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @MartinVargas ,

I would suggest you use an HTML Table type of approach to capture the information on the lines and then put this into a single Email step. Example here: https://debajmecrm.com/how-to-send-an-email-with-html-table-in-power-automate/

The above shows example of multiple Accounts in same email but this approach should work for what you are trying to do as well.

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @MartinVargas ,

There are also articles on formatting of the HTML table as well:

https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/

Thanks,

Drew

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@MartinVargas

Can I understand more about what you are trying to achieve here, are you creating the line items inside the flow?

What I believe you need to do is to separate the logic of the creation of the order lines and the logic of invoice sending.

So once you have invoice and invoice lines there is 2 options you can do:

1. Use a word template to generate the invoice document and attach to email

2.get related line items of the invoice and use create html table and append to the email body with the invoice header.

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report

Hi @Mira_Ghaly in this link I simplify it:
https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Send-email-for-each-order-created/m-p/1343378

Thanks.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (1)

Report
Hi @MartinVargas ,

I assume that IdOrder column and MKT Order column are all text columns ,not lookup column.

I did a test for you.

idorder : @{outputs('List_rows')?['body/value'][0]['crba2_idorder']}<br> -----------------------------------------------------<br>

No I add a new Item to trigger this flow .

Best Regards,

Wearsky

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report

Hi @v-xiaochen-msft , Thank you very much, I am very clear. By the way MKT_Order from the Order_Line table is a lookup column).

Was this reply helpful? Yes No