Finance | Project Operations, Human Resources, ...

Add table information on workflow email notification

(1) Share

Report

Posted on by Vinay S

184

Hi experts,

I want to show sales order line information on workflow email notification.

Can you please guide me how I will show sales order line information in table format on workflow email notification.

Note: I am triggering workflow notification through power automate and added workflow Approve/Reject action on workflow email notification

using power automate.

Thanks in advance.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,369 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi Vinay,

Can you confirm that a Power Automate approval flow should generate the email with sales order line information? If so, it is possible to initialize a string variable in the flow and loop sales order lines. For each line, you can append the text with html coding for table rows like:
<tr> <td>@{body('List_records_sales_lines')?['ItemId']}</td> <td>@{body('List_records_sales_lines')?['ItemName']}</td> <td>@{body('List_records_sales_lines')?['Qty']}</td> <td>@{body('List_records_sales_lines')?['UnitId']}</td> <td>@{formatDateTime(body('List_records_sales_lines')?['DeliveryDate'],'dd-MM-yyyy')}</td> </tr>

In the send email action, you can add HTML as body where you create the table headers and then add the string variable for the line contents, like:

<div> <table align=center border=1 bordercolor=#FFFFFF cellspacing=0 cellpadding=6 style='border-collapse:collapse;font-size:12pt;font-family:"Segoe UI",sans-serif;color:#303030'> <tr align=left style='background:#0077FF;color:#FFFFFF'> <td>Item ID</td> <td>Item Name</td> <td>Quantity</td> <td>Unit</td> <td>Delivery date</td> </tr> @{variables('TextSalesLines')} </table> </div>

Using some coloring, alignment, and font information, you can create a nice formatted table.

1 people found this reply helpful.

Was this reply helpful? Yes No
Vinay S 184 on at

Like (0)

Report
Copy link

Link copied!

Thanks André for the quick solution.

Can we add the line information on workflow tabular form?

I am able to see all line details but this is not coming in table format.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,369 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Vinay,

You mentioned Power Automate in your question. You are now sharing a screenshot of the Dynamics 365 F&O workflow configuration. These are two complete different topics.

In the work item instructions part of the Dynamics 365 F&O workflows, you can't add table information. It is possible to send an email notification using Power Automate. Then you can loop the lines and add multiple lines from a table.

Was this reply helpful? Yes No
Vinay S 184 on at

Like (0)

Report
Copy link

Link copied!

Yes, I am trying to achieve this requirment using power automate but I am struggling to add email in the power automate. Because in the email I want to add Approve/Reject feature.

Please advice how and where should I add email logic along with Approve/Reject link

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,369 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Vinay,

If it is OK, the Parse JSON has been configured with the payload from F&O. This has a field called Body WorkflowUserEmail. You can use that variable. It has the email address of the user assigned to the workflow work item.

Instead of the HTML coding I provided above, you can also use the markdown language to build a table with order lines.

Was this reply helpful? Yes No