@Matthy79 Thank you so much for responding to my message, I hope you can help 🙂
Here is the new post as suggested.
My main list is in SharePoint and is called Opportunities List which hosts a list of opportunities that become available in the business - see SharePoint dummy attachment ( I have changed some of the details from the previous screenshot to make it less confusing). Pluto and Mars were fictional locations I added to show a bit more detail in the email - the location of the opportunity is one of the fields I would use in the email.
The Opportunities List has two columns, namely 'Business Line' and 'Discipline'. I will use the data in these columns to identify which individuals need to be notified about the new roles that have been added. To provide more context, we have 5 business lines in total and each business line has a list of disciplines.
When an Opportunity is created it is allocated a discipline that is required for the role as job titles are often too ambiguous to provide enough information.
My Excel list (see revised screenshot) has a list of every line manager in the business line and the disciplines that report to that line manager.
What I would like the flow to do is:
- get new items that have been created in the Opportunities list for each business line & which disciplines are required (let's use Transport for this example)
- then match the Business Line & Disciplines to the Excel list to find which line managers have people in their teams who might be suited to the available opportunity
- Once the flow finds the line Manager ( in this case for Transport, Joe Bloggs needs to know about the Cad Drafter role and the Cost Controller opportunities)
- It then creates the HTML table and emails Joe only those roles.
At the moment my flow finds Joe but then it sends Joe all the roles. I then tried a few other iterations but that ended up sending each role to the person in separate emails and sent it multiple times. I have tried a few iterations but I suspect I need to create arrays/variables which I haven't had experience in.
