Get automatic Invoicelines data to Excel from Dynamics 365 Business Central through Power Automate

(4) Share

Report

Posted on by PN-17020758-0

Hello,

I'm trying to make a automated data-pull with Power Automate. (Data from Dynamics 365 Business Central to Excel)

I succeeded to get Invoice data with this metode and i'm currently getting all informations live in Excel - except the invoice product lines. I also succesfully pulled dato from Inventory, whenever there is changes, i see it.

I can make it succeed by choosing the same "table name" in "When a record is created" and "Get record".

I see that in "Get Record" i have a table option called "salesinvoicelines", but i unfortunally don't have that option in "When a record is created". I tried is a few times, but i can't get it to work.

I also see, that the data i would get should be the correct data, because i can see in step 3 "Add a row into a table" that the product lines, price, discount etc is chooseable, but i still don't get the data.

Is there a work around, a fix or something i can do?

Categories:

Dynamics 365 general

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Holly Huffman 6,530 Super User 2025 Season 2 on at

Like (0)

Report

hi there!

nice work getting it this far! let's see about getting those lines to go too....
can you try:

1. trigger when a record is created for invoice header

- initialize a variable - call it invoiceID to store the invoiceID

2. then list invoice lines

- use an action "List Records" to retrieve all the lines from the salesinvoicelines table

apply the filter query to get invoice lines related to the invoiceID we stored in the variable

3. then do a LOOP and add "apply to each" loop to process each line retrieved from the step above

- use the GET RECORD to retrieve detailed information for each line found with that invoiceID

4. add data to excel using "add row into a table"

- then add each invoice line's data to the table in excel

hope this helps some!

Was this reply helpful? Yes No