Send Email from Excel using power automate, flow to multiple mail Ids and BCC

This video is to demonstrate, how we can send email from an excel dynamically using power automate to multiple mail ids and how to pass dynamic emails to BCC.
Send email to distinct users from excel | Remove duplicate emails using power automate | Flow
• Send email to distinct...
Books
Learn Power Automate : amzn.to/3aVRoc2
Learn Power Bi: amzn.to/3xjt3Es
Learn Power Apps: amzn.to/3xnTSrb
#powerautomate #emails #dynamically #excel #flow

[@corporateprogramming]

Please subscribe the channel your support really helps me out, thank you!

[@GenNextAnalyst]

Amazing! Thanks a lot!

[@davereb8464]

Thank you!

[@chanclstl4854]

Thank you bro

[@jrs7541]

Amazing video! Why do we need to append the email ids and please explain what is appending and the semicolon. Thank you so much

[@CatherineLabro]

Hi, this is very useful but how can I pass dynamic cc? ie. I have 2 columns for employee and manager and the manager was copied on the email meanwhile the rest of the team will be in "TO" field.

[@khekiw3094]

Thank you

[@corporateprogramming]

You're welcome!

[@rockwscuba]

Excellent video thank you so much. A quick ? , how do you trigger the flow from within excel? Thank you

[@corporateprogramming]

Glad it was useful! I’m using manual trigger. flow does not contain any trigger for Excel. Although there is a workaround you can use ‘When a http request is received’ trigger. And bind it with a button in excel.

[@beckyfosterman6163]

This is a great video. Thank you. You ended it with partially showing us how to use BCC instead of To. In my scenario I would like the emails to all be in BCC, however, To is a required field. Is there a work around so not all email addresses are visible?

[@corporateprogramming]

Thank you! Yes that’s possible. Option 1: you can use ‘send http request’ action by using rest api end point to send emails. In this ‘To’ is not required. Option 2: you can use your email id/shared mail box email in ‘To’ & ‘From’

[@beckyfosterman6163]

@@corporateprogramming thank you. I will give that a try.

[@shaikhsameer8141]

Nice video keep it up

[@corporateprogramming]

Thank you!:)

[@yogeshkoshti9809]

Good Informative video. Thanks.. I am having one scenario if you can help it would be great..!! I am having multiple systems which have an out dated antivirus signature. Some multiple systems have only one owner and I want to notify them via email by copy or creating an Excel table in emails with the system name and dates.. Is it possible using power automate?

[@corporateprogramming]

Thank you! Do you have the data of owners/antivirus at any centralised location? Like sharepoint excel, dataverse.

[@shahrulsham94]

Can someone explain where is the value come from?

[@ritwicktripathi]

I am creating a flow where there different levels of follow ups, and different templates of follow up email body. When I am using condition I am gettin BadRequeat error. E.g If follow up status is equal to Followup 1 then template 1 should be sent If not then new condition if follow up status is equal to Followup 2 then template 2 Same for 4 follow up levels Can you please suggest something for this

[@corporateprogramming]

You can do this by the help of switch control action.

[@basireddy1387]

Hi Like mine also same request one id in to and remaining managers in cc, this cc depends on employees list some employees doesn't have managers so that id is empty or null my issue is in that list for cc or bcc how to manage the null or empty mail id

[@corporateprogramming]

Yes that’s possible, you can use Filter array with Select action and check for null

[@sudharani-is2ir]

useful video.. I have a query.How do we fetch latest worksheet from Excel which gets addon New worksheet daily

[@corporateprogramming]

You can send your usecase at [e-mail]

[@user-km4gt9iz2u]

HI I need to add one more condition, that is to send the email on the due date and not when the status is getting changed, can u help me with the action i would be required to add?

[@corporateprogramming]

You need to use recurring trigger and set frequency to daily. Check for due date = today’s date, if true send notification.

[@cendyfauzan1481]

Hello , Nice video.. I have similar usage but my desired email recipients are in multiple columns (4-6 recipient email columns). how to send email in 1 row excel with multiple email recipients (4-6 recipient email columns)

[@corporateprogramming]

Hi Cendy, You can use the "Excel - Get Rows" action to retrieve all the rows of data from the spreadsheet, and then use the "Select" action to select specific columns.

[@koys1000]

Hello , Great video.. I have a similar use but what I need to add is the a list of Positions that relate to the recipient within the email.. Would you kindly connect with me and we can talk through it please?

[@corporateprogramming]

Please share your use case using the query form. Our team will connect with you to provide the customised solution as per the need. forms.gle/KgjFkXJuJJJKbvgYA

[@rajeshkhanna8709]

Hi, Nice Video I would like to ask you one thing In same Senario have a data for each emailid I would like ask you how to send those data to individual emailid with attachment

[@corporateprogramming]

You can use 'send email v2' action within for each.

[@rajeshkhanna8709]

@@corporateprogramming how to learn full course

[@rajeshkhanna8709]

@@corporateprogramming how?

[@corporateprogramming]

You can connect [e-mail] Send your usecase

[@Rakesh_RV]

How to read text from excel and use it to the body of an email?

[@corporateprogramming]

Use the 'List rows' action to read data from Excel, then select columns to include in the email body navigating to 'dynamic content'. fyi, refer to the recorded video on sending emails by formatting data in table. video_link: kzbin.info/www/bejne/bJ3HlaB9r8uDnbs.

[@dencioberdino6163]

How do you handle duplicate emails recipients?

[@corporateprogramming]

Include if condition and check for ‘doesn’t contain’ within same string before appending.

[@ahmathbasha8788]

My flow returns with bad request at list rows present in table. It asks for select query and where i am not able to understand

[@corporateprogramming]

Please provide more details.

[@khekiw3094]

How do I trigger the email for a single row at a time. It's sending emails for all rows 😢

[@corporateprogramming]

you can set top parameter to 1

[@user-bp8xg7bp2p]

Very hard to follow as your are skipping steps and going back and forth!

[@corporateprogramming]

Apologies for inconvenience, you may refer to the another video on same business case. video link: kzbin.info/www/bejne/moTOo5h7jalrgdU Hope this will help you to achieve your task!

[@KiranKumar-ec6qf]

@KiranKumar-ec6qf 0 seconds ago Hi , thank you for the video I able use it. How do I create a flow for which can trigger and email based on the two values in a row condition with AND. Send and email from out look. If possible please help. Thank you very much. I tried from my side it says no errors or warnings and Test says success but no email triggers. I have been working on this requirement for the past 4 months.

[@corporateprogramming]

You can include condition action and use And for the values inside apply to each for true append emails to variable finally pass the variable in To or CC as per the need

[@khekiw3094]

Hi @corporateprogramming