How to Attach a Sales Invoice to an Email in Power Automate?

Business Central/NAV Developers Forum
1

Hi everyone,

I’ve created a flow in Power Automate to send an email notification whenever a sales invoice is created. Does anyone know how I can attach the newly created sales invoice to the email automatically? Any guidance would be greatly appreciated!

Thanks in advance!

2

Not sure if you figured this out or not but thought I’d give it a try. This flow worked for me.

You may need to add a delay between creating the record and getting the record as it will attempt to run while you are still creating the invoice.

Also this will use the Report ID you have set for the Draft Invoice in your defined Report Selections in BC.

I use Google for email but I’m sure it would work the same for Outlook or any other mail service.

Parameters for each step:
When a record is created: v2.0 / table salesInvoices
Get record: v2.0 / table salesInvoices / row body/Row Id
Get document: v2.0 / path salesInvoices/pdfDocument/pdfDocumentContent / Id
Send Email: see screenshot

image
image626×1088 48 KB

image
image1250×1264 54.1 KB

3

Hello Dear,

can you share a template please