Re: How to filter a column in excel and send an email containing the filtered data
There is some work involved in removing the duplicates email addresses and then sending a single message containing their items. As mentioned by @Heartholme there is no distinct function in Power Automate but the Union function can be used to remove duplicate email addresses:
The following expression will remove the duplicate email addresses:
union(body('Select'),body('Select'))
Then for each email address we will collect the items as recorded in the Excel file and send an email to each recipient:
For each email address:
Filter the data from Excel based on the current email address of the loop:
Next we select just the item values (i.e. Clothes, Shoes, Housegold items, Sports equipment and Furniture etc) from the Filter Array action:
This is the expression used in the Select Items action:
item()?['Items']
Finally join all the items together using a comma, into a single text string:
Finally, I simulate the Sending of the email:
Three emails will be sent with the following content:
Hope this helps.
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
