Need Help Filling Word Template with Repeating and Non-Repeating Sections

[PowerAppsMH]

Hi,

I'm hoping to get some help with a flow that I'm creating. This flow works in tandem with a PowerApps application to deliver checklist completion reports to a recipient. Here are some more details regarding the app setup:

There are three SharePoint lists that house data; the first one is the main one (we'll call 'Main'), the second one (we'll call 'Items') is used to house the checklist items and whether or not the relevant tasks have been completed, the final one (we'll call 'Signatures') contains the signatures and dates corresponding to the relevant weeks. The secondary and tertiary forms are connected to the main one via a column called 'mainFormIDFK' (like in a database schema). Each entry in the 'Main' list is unique, but the other lists can contain multiple records corresponding to the single one on 'Main'. The original paper process involved 4 papers (one for each week), but in my implementation, I segregate weeks in the 'Items' list via the 'FormWeek' column (with values ranging from 1-4, depending on when the activity needs to be done). Everything on the app side is working as expected. The complications arise on the reporting side.

I have started building the Power Automate flow, and here's what I have so far:

Step 1. When a submit button (on the app is pressed), a column named 'FormSubmitted' (meant to initiate the email notification) in the 'Main' SharePoint list is updated to 'Yes'. The flow will look for any updates.

Step 2. In the Condition step, it will determine whether the relevant column is updated, and if the value is set to 'Yes'. If anything other than 'FormSubmitted' is set to 'Yes', the flow will terminate, otherwise it will move on to the next steps.

Steps 3 and 4. The flow queries the second and third forms for data associated with the item that was updated in the 'Main' list (filtering for results from the lists using the 'mainFormIDFK' value). Resulting in multiple items being pulled that correspond to the main item.

Step 5. Set the 'FormSubmitted' column's value back to 'No' to prevent duplications.

This is where my problem arrives. I've built 4 Microsoft Word templates that need to be filled in (since each week has its own signatures and dates), but I can't seem to figure out how to segregate the retrieved items based on the FormWeeks (i.e., 1, 2, 3, 4).

I hope this was a thorough enough explanation.

[Koen5]

Dear P,

Regardless of the flow and all the steps ... is there a particular data element in your data by which you can separate the week 1,2,3 and 4 items? How would you do this manually?

If the answer to the above is that you cannot do it manually... then you cannot do it with the flow. 

The solution would be to include a data element which uniquely identifies the weeks per line.

If you can do the above ... then ensure that this data element (which uniquely identifies the weeks per line) is in the retrieved data set and use a 'Filter Array' based on this data element to filter out the items per week (assuming you will have the lines in an array).

Hope the suggestion helps,

Happy flowing,

Koen