Hi Drizzle,
Here is the sample flow.
I have used a custom table with 2 columns - Name & Country (both are single line of text):
Flow:
1. Add "List rows" action to get all the rows from the custom table:
2. Next, add "Select" action to create an array of countries from the output of list rows action. Pass the value object from the previous action in 'From' parameter:
Click 'Switch Map to text mode' button and enter an expression to get the country value for each row:
Below expression needs to be added in the expression box as shown below:
item()?['crc76_country']
pls replace the actual logical name of the column in the above expression.
3. Add "Apply to each" action to loop through the output of select action. To get distinct country name, we will be using expression as shown below:
union(body('Select'),body('Select'))
Add filter array action to get the users of a country in each iteration. Pass the output value object array from the List rows action as its input and enter the query to filter the results based on the country:
Click 'Edit in advanced mode' button on the bottom & enter the below query in the textbox:
@equals(item()?['crc76_country'], items('Apply_to_each'))
pls use actual logical name of the column in the above query.
Add "Create HTML table" action to capture the users for each country in a table. Choose 'Custom' from the dropdown for 'Columns' parameter and pass the output body of filter array as its input:
Use the below table for the map object. Both keys are entered as plain text but for value, expression needs to be added:
| Key |
Value |
| Country |
item()?['crc76_country'] |
| User(s) |
item()?['crc76_name'] |
Pls use the actual logical name of the column in each expression.
Finally, add "Send an email" action and pass the output of create html table action in the email body to display the list of users:
Output:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
