Power Platform Community Forum Thread Details

I have 2 lists in SP:

1: Contains project number, article number, description, quantity etc (a part list for multiple projects)

2: Contains the purchased articles for the project, with PO number and material certificate

What I would like to achieve:

An export to a Word document, showing a part list for 1 project with its purchased articles with their PO numbers and certificates. Each article number in list 1 can have multiple purchased articles, since we pick from stock in a FiFo way

List 2 is related to List 1 by the AOlistID column in List 2, referring to the ID column from List 1. I did not link the files by lookup or something else.

List 1, parent(s) List 2, Children

In Power automate I now use a manual trigger with a variable 'VarProject' to filter the GetItems from List 1 down to only 1 project.

With the connector 'use Word template' connector I am able to fill a table in a Word document with the whole list of items of List 1 or List 2.

So far, so good, but I don't know how to proceed anymore.

I created an example Word file with faked results to demonstrate the idea. I am fine with either option 1 or 2, although I have a slight preference for option 2.

Table option 1 and 2.png