Send email to distinct users from excel | Remove duplicate emails using power automate | Flow

how we can fetch unique email IDs from an Excel this is my Excel these are the application hosted on my server and I would like to send a notification to application owners to review their hosted application on server and if required do the necessary changes or update the details as this is the part of our annual review process now if you notice here I have let let's take an example of mic let's say Mike is the owner of many applications right but I would like to send just single email to Mike to inform him that the annual review process has been started kindly review your hosted application on server and update the details so how we can you know remove the duplicate email IDs before sending an email notification to the application owners so let's watch it in action come here click here I'm going to trigger it manually but you can trigger as per your business need search for list items now provide the required details what is the location of your Excel file so the my Excel file is is on this SharePoint document Library select your Excel file name and the table remember one thing before fetching data from an Excel first you need to convert your data into a table this I explained in my previous video you can find the link in description after fetching the data from Excel our next step is to get email IDs search for select operation provide the from in our case from is the output of previous action which is list rows present in a table so provide the required object which is value now click here on this icon and what we want we just want email IDs right so search for email application owner email IDs select it by doing this uh we we will able to fetch just email IDs from the entire object of excel the next thing which is required here is to add a separator basically a semicolon separator so later on we are going to use the output of this join directly in our email body how let me show you first provide the required details for join action so in case of join we already filtered out email IDs from our data now after filtering out select the output of Select and the separated here in our case is the semicolon include semicolon once okay one thing we are missing before including join operation first remove the duplicates to remove duplicate search for compose and come here in the expression and write this expression Union using Union function we are going to eliminate the duplicates so our sources the previous output after excluding duplicates now the next step is to append the filtered email IDs with semicolon or use the semicolon separator now we have a single string with all the email IDs we are good to go to send email notification to the application owners so send an email version to action use this now in two field provide the output of your join subject could be anything modify details of your hosted applications foreign the link provide the link of your Excel so that user can directly navigate to the Excel directly from the email now let me test it our floor and successfully let me go back to my select operation so these are the email IDs if you notice here you know duplicates email IDs are present here but after including compose it will remove all the duplicate emails so these are the email IDs unique email IDs and after that we separated the email IDs with semicolon so this was the input and this is the output with the separator semicolon and later on we used same output of our join in our two field subject and the body of your email now let's check our mailbox so as you can see here this is the email we triggered from the power automate and these are the unique users thanks for watching the video please like subscribe and comment if the video was useful

Channel: Corporate Programming

Views: 10,494

Keywords: Send Unique Emails with HTML Table using Data from Excel, How to Use Power Automate to Send Emails from Excel with PERSONAL Attachments, Sending email to unique list of Managers with the - Power automate, Send email to unique email address from excel - Power automate, Using Power Automate to send emails to unique users, Automatically Email Reminders from Excel with Power Automate, Sending Emails from Excel with Microsoft Flow, select action in automate, join action in power automate

Id: dSkreEXD8Ks

Length: 9min 1sec (541 seconds)

Published: Wed Mar 09 2022