Answered

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:

Dataflows

All responses (6)

Answers (1)

MartinVargas 312 on at

Like (0)

Report

Re: Notification flow for each case created

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).
Verified answer

v-xiaochen-msft on at

Like (1)

Report
Re: Notification flow for each case created

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
MartinVargas 312 on at

Like (0)

Report

Re: Notification flow for each case created

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.
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: Notification flow for each case created

@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.
Drew Poggemann 9,278 Most Valuable Professional on at

Like (0)

Report

Re: Notification flow for each case created

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
Drew Poggemann 9,278 Most Valuable Professional on at

Like (0)

Report

Re: Notification flow for each case created

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