I try to export some of my invoice lines to excel by making use of an invoice line entity from D365FO.
This works fine so far.
In a second step, I try to add the invoice header information (from the invoice header entity in D365FO) to my excel lines by making use of the update excel functionality.
Now, I have the problem that I need to specify the row id that identifies, which row to update and here my problem starts.
My invoice lines are linked to my header through the ParentRecIdField. I.e. in my excel invoice lines section, I have a column that holds the ParentRecIdField. The corresponding field in the invoice header field is denominated UniqueInvoiceIdentifier.
What do I have to enter in the row id field in the Excel update row action to get the invoice header information assigned to all of my lines?
Note: Multiple lines can be assigned to the same header.
Would be great if you could help.
Many thanks and best regards,
Could you please share a screenshot of your flow's configuration?
I suppose that you add "Get records" action of Dynamics 365 For Operations connector within your flow and want to update the invoice header information of each record of Invoice Header entity into the excel file with a "Apply to each" action (loop action). Is it true?
Please take a try with my following thought as a reference:
Add a "Apply to each 2" action, input parameter set to output of "Filter array" action. Within "Apply to each 2" action, add a "Update row" action, Row id field set to following formula:
Invoice Header Information field set to Invoice Header Information dynamic content of "Get records" action.
Thank you for your feedback.
I am not very clear with the filter array that I have to apply.
Maybe I did not express precisely what I want to achieve.
So, let's try again with what I have so far.
1. I use a recurrence trigger
2. Then I retrieve the invoice headers (FTI headers)
3. Once I have the headers, I retrieve the lines (FTI lines) because each header has one or more lines.
4. Then I insert all lines into my excel sheet. I start with the lines because later on, I want to update each line with the header information.
5. Then I said get rows
Now I am a bit stuck because I need to filter first all of my rows to get the rowid from Excel.
Once I have this id and know which lines to update I have to link the FTI lines to the FTI headers. This linkage is established by a field ('parent recid') that can be found in the FTI lines. In the FTI header, the field name is unique identifier (recid). I am not sure how to establish this filter & linkage and how to update my excel rows then.
Can you help with that?
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!