Hopefully this is what you're looking for. I've assumed all your fields are Single line of text except for Amount which is of type Number. I've also used the Title fields (renamed as Country) for the Countries. This will run the flow daily, get all items that were created in the last 24 hours, and send them to each Country Manager as a Table.
I've used the following lists for this example.
See full flow below. I'll go into each of the actions.
Recurrence is set to run daily at 6AM (you can set this to suit your needs).
Get Transactions (Get items) retrieves the items that were created in the last 24 hours. The expression used for the Filter Query is:
Created gt '@{addDays(utcNow(), -1)}'
Get Managers (Get items) retrieves all the Country Managers.
Select Countries (Select) gets an array of all the Countries (our Title field). Note that Map is set to Text mode (see screenshot).
Compose HTML style (Compose) is some CSS that will be used to style the HTML tables within the email. I've set it before the loop as we only need to create this once, then use it multiple times.
<style>
table {
border-collapse: collapse;
}
table td,
table th {
border: 1px solid #ddd;
padding: 6px 20px;
text-align: left;
}
table th {
background-color: #1C6EA4;
color: white;
}
</style>
Apply to each iterates over each of the Countries. We use the union expression to ensure we remove any duplicate Country values.
union(body('Select_Countries'), body('Select_Countries'))
Filter Transactions (Filter array) extracts the transactions for the current Country that we are iterating over.
Filter Managers (Filter array) extracts the managers for the current Country that we are iterating over.
Select Manager (Select) extracts the Manager emails. Note that Map is using Text mode here similar to the Select Countries. The expression used is:
item()?['Manager']
Create HTML table uses the output from Filter Transactions and maps the fields as below.
//Title
item()?['Title']
//CRM ID
item()?['CRMID']
//Client Name
item()?['ClientName']
//Amount
item()?['Amount']
Send an email uses the output from Compose HTML style and Create HTML table in the Body, Current Item (Country) in the Body and the Subject, and the following expression in the To field that joins each of the Country Managers.
join(body('Select_Managers'), ';')
When the flow runs (daily) each of the Country Managers will receive an email with any items that have been created in the last 24 hours. See example emails below.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
