Power Platform Community Forum Thread Details

Hi all,

Thanks for taking the time to read this!

My goal is to create a recurring email with multiple HTML tables in it from multiple connected sources.

I have tables for Employees, Contacts, Companies, Opportunities, Projects, and Relationships.
The Relationships table shows connections between Employees and Contacts. All Contacts are connected to a Company. Companies can also be connected to Opportunities and Projects as a Primary Client.
For my Flow, I want to:

Search through Employees to find members of a specific team
For each Employee, find all of their Relationship records that have been created in the last week.
Create an HTML Table of those Relationships
Then for each Relationship Contact found
1. Find that Contact’s Company from the Contacts’ record
2. Find all Opportunities where that Company is the Primary Client
3. Create an HTML Table of those Opportunities
4. Find all Projects where that Company is the Primary Client
5. Create an HTML Table of those Projects
6. Check the Relationship Table for any other Employees Related to that Contact
7. Create an HTML Table of those Employees
Create an Email with ALL HTML Tables inside of it and send that email to the selected Employee.

Currently I have Steps 1-3 Working correctly and then it gets broken when attempting Steps 4-5. The problem I'm running into is that the Create HTML Table action needs to be nested in the same for each loop where the data i drawn from and then it's not available for the email since the email is outside of those For Each loops. And I can't build the tables after the For Each loops gather all the data as that throws an error: ' 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'For_each' referenced by 'inputs' in action 'Create_Project_Table-copy' are not defined in the template.'.'.

What's the workaround for this or is my structure off from the get go?

Any help is greatly appreciated!

Categories:

Building flows