Send Email from Excel using power automate, flow to multiple mail Ids and BCC
HTML-код
- Опубликовано: 22 окт 2021
- 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 - Наука
Please subscribe the channel your support really helps me out, thank you!
Amazing video! Why do we need to append the email ids and please explain what is appending and the semicolon. Thank you so much
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.
Amazing! Thanks a lot!
Thank you!
Thank you bro
Excellent video thank you so much. A quick ? , how do you trigger the flow from within excel? Thank you
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.
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?
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’
@@corporateprogramming thank you. I will give that a try.
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?
Thank you!
Do you have the data of owners/antivirus at any centralised location? Like sharepoint excel, dataverse.
useful video..
I have a query.How do we fetch latest worksheet from Excel which gets addon New worksheet daily
You can send your usecase at programmingcorporate@gmail.com
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?
You need to use recurring trigger and set frequency to daily. Check for due date = today’s date, if true send notification.
Can someone explain where is the value come from?
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
You can do this by the help of switch control action.
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
Yes that’s possible, you can use Filter array with Select action and check for null
Nice video keep it up
Thank you!:)
Thank you
You're welcome!
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)
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.
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
You can use 'send email v2' action within for each.
@@corporateprogramming how to learn full course
@@corporateprogramming how?
You can connect
programmingcorporate@gmail.com
Send your usecase
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
Please provide more details.
How to read text from excel and use it to the body of an email?
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: ruclips.net/video/6lddmGzfPgY/видео.html.
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?
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
How do I trigger the email for a single row at a time. It's sending emails for all rows 😢
you can set top parameter to 1
How do you handle duplicate emails recipients?
Include if condition and check for ‘doesn’t contain’ within same string before appending.
Very hard to follow as your are skipping steps and going back and forth!
Apologies for inconvenience, you may refer to the another video on same business case. video link: ruclips.net/video/dSkreEXD8Ks/видео.html
Hope this will help you to achieve your task!
@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.
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
Hi @corporateprogramming