Scenario: 2 SharePoint lists which are "linked" via a reference column, essentially providing a one to many relationship. A workflow is triggered when a certain condition is met in the "master" list. This cumulates in a notification email which should list details of all the related entries in the "child" list. Need content of 4 columns from "child" list. Obviously the number of related "child" entries is dynamic.
So far I have used the "query list" action for each column I want to retrieve and add to collection variables. Use "For Each" loop and potentially collection actions. I'm not clear how I can build a variable up that collates/appends all the information for insertion into the notification email.
Alternatively is there a way to dynamically create variables based on the number of returned items from the "child" list?
Any help would be appreciated.