How to link a column value to an email

[mr-samd]

Hi,

I have a flow that is collecting data for each of my area teams. It collects the data into a HTML table for each team and I want to be able to email this filtered HTML table to that teams manager. 

The data only has the team name and no email linked it. How can I input the emails i need into the flow so i can reference them in the emails "To" box? I suspect its some sort of JSON array but that's where i become out of my depth. 

I have teams A-G and i want to link the team name to the manager

e.g.

Team A

Manager: <Managers email>

Deputy: <Deputy email>

Team B

Manager: <Managers email>

Deputy: <Deputy email>

Etc.

Any help would be very much appreciated

[v-bofeng-msft · Accepted solution]

Hi @mr-samd :

I've made a test for your reference:

1\I assume there is a data source:

2\I assume there is a team list

3\My flow:

The Result:

Best Regards,

Bof

[mr-samd]

Thats amazing thank you.