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

This video is to demonstrate, how we can remove duplicate values, fetch value of single column from excel and how to send email from excel.
Use of data operation - select and join.
Books
Learn Power Automate : amzn.to/3aVRoc2
Learn Power Bi: amzn.to/3xjt3Es
Learn Power Apps: amzn.to/3xnTSrb
Submit you queries:
forms.gle/xkFd...
#powerautomate #RemoveDuplicates #SelectOperation #JoinAction
For business query contact at: [e-mail]
If you find it useful you can gift any amount:
UPI: rajkumarj6@okicici
Paypal: @rajkumar4422
Convert excel data into a table:
• Send Email from Excel ...

[@corporateprogramming]

Don't miss out on future content, hit subscribe and turn on notifications now, your help will surely support - Thank you!

[@davereb8464]

Thanks! Very useful

[@simonec98]

I need the same flow for power bi. Need to send unique mail with multiple data to unique recipient. Is that possible? May you share some insight

[@alecseidman5601]

Could I pair this with HTML to a table? I have a dataset that has 8 columns and 48 rows. some of the rows in the email column have duplicate emails, so I want to only send 1 email out to the user, but include all neccesary information in the other columns, in this case a reference ID, dates, and values. Thank you for any help!

[@corporateprogramming]

I will record a video for this usecase, this will be useful for others as well.

[@koys1000]

Hi I have a smilies use case. Instead I need to send one email to manager with the list of employee names and position that the manager is assigned to.. The issue I am facing is is that the manager receives multiple emails depending on how many employees are assigned to the manager.

[@adityaprakash9151]

What if we want to to include apps name individually for all owners and their apps in body of the email instead of link of excel ??

[@dtunforgettable]

How can I do this if the File is dynamic x-ms-file-id and I cant see the headers of the excel file table??

[@anuradhashankaran1494]

Hi. Very useful video. I have a scenario where I want to include a table with due dates, invoice details and send these details individually to different email IDs. My flow ran successfully but the table was present in only one email ID but not the other one. What might have gone wrong? Although email body is visible on the other email ID. Pls guide

[@corporateprogramming]

Please connect for custom requirements: [e-mail]

[@fernandosjrp5240]

Hello, congratulattion! Please How Can I use the emails that stay in another table? I need to use 2 table, one I extract and there aren't emails at this table to send diferentes emails. Thanks

[@corporateprogramming]

Hi, Thank you! You can use ‘List rows present in a table’ action to extract both the tables from excel and by the help of ‘select’ action, extract the email column from raw json object. No worries!

[@sportsmania2841]

how can I keep there managers in cc

[@corporateprogramming]

by the help of get manager action