Dude I just want to take a moment to take my hat off to you. I've watched 100 of hours of power automate and some how your videos turned out to be the most crucial to my beginner journey. You really have a way of simplying it to a point that even the least tech savvy are able to implement the above
Incredible video. Your calm voice paired with clarity and preciseness in language makes this an easy to understand video. Keep doing what you're doing, John.
Thank you for this video. Is there a way to trigger an event when a particular row has been changed. For example, let's say one row has a dropdown that either can have approved or rejected. Is it possible to send an email with the value (approved/rejected) to certain people when it is triggered? Thanks in advance!
Thank you for the video. I have question! You demonstrate that by clicking run, the value will be sent to email. Is there any way that an email will be sent automatically if the excel was updated? It is like this. I have forms, in that forms, i want the score to be sent to my email. Can this be done?
This was a great tutorial. One question, what if I wanted to not only have a dollar amount but include a list of outstanding invoices? Do you have a tutorial on that?
Hey mate, this is awesome and will be super helpful for us chasing payments. I did want to ask one thing. Is there a way to make the emails NOT automatically send, but to have excel speak with Outlook and basically generate the emails that then will pop up on our screen so we can make some edits. I ask because some of our chasing is for multiple invoices, or we will need to attach documents that might not always have consistent naming. Hope you can help! Your video was amazing and so so clear!
Awesome instruction - Is there a way to set up a flow to reply to a specific email that was previously sent. For example if I sent you an email on 4/21/2021 and wanted to follow up on 4/22/2021 by replying to that specific email. Can this be done in power automate?
HI John. Thx for this very useful tutorial. I have a large table and before i send out the emails, i need to "filter" my table to only show the 'pending payment" rows. ( hence there are lots of 'hidden rows). will the Flow understand (once i highlught the filtereed table) that i only need to send emails to those rows inlcuded in the election and disregard the 'hidden" tables. ? Thanking u in advance . Martin (south Africa)
Hi! great video, could you make a tutorial on how to automatically paste a graph into de body of the mail? Also, is there a way to change a paragraph depending on the data of the day? Thanks!!1
Finally a tutorial video that enabled me to create the flow I want. However, when I closed the file and try launching my saved flow, Excel prompts I have no flow for the same file. Ended up doing the entire process, but Run button is disabled for the same file. Please help me out. Thanks!
Thanks for sharing valuable videos........... I am trying to learn how to set up excel sheet to send email without opening it. The case is, I have several systems to be verified after a regular interval for their integrity. All systems are listed in an excel sheet and a condition formatting is applied to determine the due date for system integrity verification. Can we do it (I mean the email should be sent as a reminder to the concerned person on a due date without opening the excel sheet)? Thanks
Hi, great video straight to the point but I do have questions, 1- does this work when a new entry is created? 2 - will this work if I use a form in excel to create my data sheet in excel? Thank you, Paul
This is definitely a new twist from using other merge software. Is there a way to have automated emails sent out such as a birthday email to staff on their specific birthdays or does this need to be done on a daily basis?
Yes, you could do that with power automate. Set up a scheduled flow that runs every day, filters an Excel table that contains all employees by those with a birthday today, then email.
is there a way to make it send these emails automatically when a certain trigger is hit? for example if you had a due date column can u make it do exactly what it did but only when its the due date?
@@richelsantiago ahh yes I was looking into that but my work 365 account is not linked to REST API so won’t work with Outlook. I have however found a tool created by Doug Robbins that works as an addin to the usual MS Word+Excel desktop mail merge, google ‘Mail Merge Tool Doug Robbins’ if you’d want to check it out
Thank you for the tutorial sir. If I want to send separate email to multiple people with different values. How would I do it? Is there away I could send all individual emails at once?
A comma list will send a single email to all in the list. If you want to send a separate email, split the list in power automate, then loop through the resulting array.
Thanks for this video.it is very useful. When I am trying to get flow app from store then it shows error. Also 1 question...do we really need onedrive sharepoint for power automate..? Bcoz current organization not giving access of onedrive or sharepoint. Is there any alternate way?
Great Video! Instead of running the flow for selected cells, is it possible to run when a condition is met? (For example before somebody is running out of stock). Stock is updated once a week, a nice form for ordering is linked to the online excel if somebody already run out but a warning message for ordering before stock ends would be greater! At the moment we handle this step manually. Regards! Carmela
I used the selected row trigger, but you might want to use the schedule trigger to run every day (or every hour). Then list rows in your Excel table with a filter on those that need restocking.
I want to schedule the emails based on a date column (Duedate) at the table. If today=Duedate, then only mail should go with details on that specific row. Please suggest.
Can this be done without having peoples email in excel. So just having them type in a persons email or be able to just pull the email from their personal email?
can we send email reminder to multiple emails from one column in excel and when one email has updated the status as "Completed" power automate will stop sending the email reminder but continue to send to the rest of the email from that one column
i doo exactly like you do and on 6:33 my run button is inactive and i have no errors or nothing.. what is wrong ? i was try with all email apps its all the same button to run flow is always deactivated so this is not working.. i just need to simplyfy my task to send 1000 emails, and this super complicated microsoft crap its just not even close to working.. I just need the flow to generate my email, and i click send it. Its allways the same email with same file atached, but how do i automate that with flow ? I need fully working with all nice and sexy hyperlinks in custom signature and pictures all have to be flawless looking. this flow email send v2 cannot read signature logo pictures thats super anoying.. do you have any solution i have like list of companies and 1 column is a email, how do i send emails via flow ?
Can you show an example, where you have maybe 3 different companies each with their own email address but multiple invoices due, where it would NOT send a seperate email for each single invoice due, but send a single email to each of the 3 companies, with the data from each row that is relevent to that specific company?
What if the email in your excel file is created using vlookup for example. The flow pulls in the function and not the value and therefore it doesn't work. is there a way of getting flow to pull in the string and not the function? WITHOUT converting the formulas manually in the excel file by copying and pasting as values. The list continuously increases due to forms data imputing into the excel file. Thanks.
Can anyone tell me how to do this with automate? Thanks! I have an Excel table with 7 columns and hundreds of rows: ‘code’ column, ‘description’ column, ‘quantity’ column, ‘total value’ column, ‘owners’ column, ‘manager’ column, and ‘functional managers’ column. I need to send the table by email to each owner, manager, and functional manager, but only with the rows relevant to them. The rows for owners, manager, and functional manager are populated with their email addresses. Please note that there can be more than one owner (multiple email addresses in the same row).
Great video, question. I have an excel sheet that I need to send out on a cadence. I am unable to pull the email contacts from the report onto my report but have the first and last name of the people I need to email on my report. Can MS Flow use the first and last name contacts within my company to email the report to action? Thank you for the video.
@@HowToExcelBlog @AT how are you setting up your spreadsheet for a cadence delivery? How did you set up your list and PA to do a cadence? I am looking into using this as a temporary method for sales prospecting until we get SalesLoft live.
HI this might sound tough to achieve but can you tell me how to automate unique email body with multiple paragraph from excel where the end receiver should be able to receive proper email format i need to this be implemented in power automate flow
@@HowToExcelBlog I tried my best using formula %0A for body and divide the body into differnt paragraphs but still its not working, please can you help me in this as ill be saving 5 hrs per day
My edu has locked out users frm adding any add-ins at the user level. Is there another method or way of installing this? I am going to ask my IT office to whitelist it, as it is MS made, but it might be an all other nothing type situation (students, staff, faculty). They don't tend to allow them if that is the case, like with some google add-ins as well.
You can still build flows by going to flow.microsoft.com and logging in with your office 365 credentials. Can build lots of other types of flows there.
Thanks for the wonderful video. Is it possible to send the meeting request in outlook using excel file and including Microsoft team in it ?I am trying to get the data from excel file and send outlook meeting requests including Microsoft teams in it. I tried with the UIPATH, I can send the outlook meeting request but we cant include the Microsoft team in it and I don't want to record the process in the UIPATH. Could you please let me know if you can do something in Power Automate. It will be really helpful. Thanks
my situation is, I would like to make a registration link. After clicking the link , what I would like to happen is 1. have a place to type in email address, name 2. add the name to an excel file for record and add the email to MS Team group 3. send email confirming the registration and 4. notify the registered member when the meeting is about to happen. Could this be done? I don't see the big picture of how each modules ties in together. Thank you
Yes, this can be done. Use an MS Form then use power automate to create a user in azure AD when a new response to the form is submitted then add the user to a Team.
I have a workbook with macros that perform specific tasks and interact with other workbooks on a shared network drive. I want to perform those tasks once per week. I can trigger the macros to run when the workbook opens and then close the workbook when they are finished. If a flow can be created to just open the workbook once per week then the entire process becomes automated.
Hello, such a great video and this is exactly what we need. I tried it and followed exactly what was done on the video. For some reason i can't run the flow. 1st attempt, the Run option is disabled. 2nd attempt, the flow i created is after i saved it, the flow is gone in excel. when i logged into my power automate, the flow that i created is there. but since it's not showing in excel, i can't run it either. hope you can help..thanks in advance!
hey, i found out why.. it all should be in text format to run the flow.. so incase you have any column/field in number format, it wont enable.. try converting it text and see.. hope this helps!
I have a sheet with duplicate recipients with multiple companies under them. How can I consolidate the multiple companies and send one email to each recipient in place of multiple emails.
Same question. Would be nice if the rows for the same recipient can be consolidated into just one email. Has anyone of you figured out a way to do this?
Hi, my date value transfers to emails as number. How yo change? Also can i send email row by row. Sending individual emails at multiple times per day as an item is updated
I have similar use case with small change, I need send multiple approval emails based on excel but I a am facing an issue that the flow is running in loop, unless the first email is not approved, it is not getting triggered the second approval for the next row in excel. Can you please let me know how can I solve this?
what if you want to consolidate the rows before sending to the recipient? Let;s say the emails are A@gmail and B@gmail, and some rows shoulld go to A, some to B?
How can i get information to other excel (im not the propietary) but i want to join this information and search automatically information on that :(. In drive, it has "importrange" to get information to another excel but in microsoft 365 (onedrive) i dont know how to connect this when other person have the excel in onedrive. How i can do that with power automate?
@@HowToExcelBlog I tried the http connector but im sure of the format that I need to use. The Api I'm trying to use requires a oauth authorization. Am I able to share details around this with you? Do you have a paid private support line I can utilize or something of the sort for your support
@@Budgetblueprint786 try building a custom connector. It's got easy-peasy Oauth handling. This video will help ruclips.net/video/2fdRtWtTmvs/видео.html
Hello, in my table I have a date column, when I include it in the body of the email, it is shown as a number and not as a date. How can I make it show as date? So 08/18/2020, not "43869". Thank you
Dude I just want to take a moment to take my hat off to you. I've watched 100 of hours of power automate and some how your videos turned out to be the most crucial to my beginner journey. You really have a way of simplying it to a point that even the least tech savvy are able to implement the above
Thanks for the feedback. Glad it helped you.
Incredible video. Your calm voice paired with clarity and preciseness in language makes this an easy to understand video. Keep doing what you're doing, John.
Awesome! I'm happy to be on Earth now with a feeling like everyone around me is trying to help me to Excel!!
Thanks for this video! I've been looking for a way to do this without writing VBA and here it is!
The classic mail merge reimagined... Cool.
I'll have to try it this way soon to decide which method wins.
Thank you for the video.
Go with the modern methods. It can do so much more!
Thank you for this video. Is there a way to trigger an event when a particular row has been changed. For example, let's say one row has a dropdown that either can have approved or rejected. Is it possible to send an email with the value (approved/rejected) to certain people when it is triggered? Thanks in advance!
Thank you for the video. I have question! You demonstrate that by clicking run, the value will be sent to email. Is there any way that an email will be sent automatically if the excel was updated? It is like this. I have forms, in that forms, i want the score to be sent to my email. Can this be done?
This was a great tutorial. One question, what if I wanted to not only have a dollar amount but include a list of outstanding invoices? Do you have a tutorial on that?
Exactly what i need right now.. Simple and straight forward.
Glad I came across this video. Simple and effective. Great Tutor!
Hey mate, this is awesome and will be super helpful for us chasing payments. I did want to ask one thing. Is there a way to make the emails NOT automatically send, but to have excel speak with Outlook and basically generate the emails that then will pop up on our screen so we can make some edits. I ask because some of our chasing is for multiple invoices, or we will need to attach documents that might not always have consistent naming. Hope you can help! Your video was amazing and so so clear!
Sir in this video, Working with different attachment for individual email address?
Awesome instruction - Is there a way to set up a flow to reply to a specific email that was previously sent. For example if I sent you an email on 4/21/2021 and wanted to follow up on 4/22/2021 by replying to that specific email. Can this be done in power automate?
I've wanted to figure this out as well. Did you find a way to do this?
Create another table, set up the dates and emails.
HI John. Thx for this very useful tutorial. I have a large table and before i send out the emails, i need to "filter" my table to only show the 'pending payment" rows. ( hence there are lots of 'hidden rows). will the Flow understand (once i highlught the filtereed table) that i only need to send emails to those rows inlcuded in the election and disregard the 'hidden" tables. ? Thanking u in advance . Martin (south Africa)
Hi! great video, could you make a tutorial on how to automatically paste a graph into de body of the mail? Also, is there a way to change a paragraph depending on the data of the day?
Thanks!!1
Hi, would it be possible to have the emails accumulate in your outbox in order to attach items?
Thanks for the video. Do you know how many max email that power automate can send per day?
How cool is this! I will test this right away. Thanks 👍
Finally a tutorial video that enabled me to create the flow I want. However, when I closed the file and try launching my saved flow, Excel prompts I have no flow for the same file. Ended up doing the entire process, but Run button is disabled for the same file. Please help me out. Thanks!
Hello, have solve this?
check that all your Microsoft accounts are the same - the one you store the file in and the one you edit in or it won't link up.
Thanks for sharing valuable videos........... I am trying to learn how to set up excel sheet to send email without opening it. The case is, I have several systems to be verified after a regular interval for their integrity. All systems are listed in an excel sheet and a condition formatting is applied to determine the due date for system integrity verification. Can we do it (I mean the email should be sent as a reminder to the concerned person on a due date without opening the excel sheet)? Thanks
Hi, great video straight to the point but I do have questions, 1- does this work when a new entry is created? 2 - will this work if I use a form in excel to create my data sheet in excel? Thank you, Paul
Unfortunately no. There is no trigger for when a row added.
But if you're using a form, there is a trigger for that.
Hi! This is a great video. It's simpler and straight forward.
Just want to check on how to send 2 or more columns/rows to a single receipient? Thanks!
Hi, Marconi did you find how to send tables?
Not yet..
This is definitely a new twist from using other merge software. Is there a way to have automated emails sent out such as a birthday email to staff on their specific birthdays or does this need to be done on a daily basis?
Yes, you could do that with power automate.
Set up a scheduled flow that runs every day, filters an Excel table that contains all employees by those with a birthday today, then email.
@@HowToExcelBlog Thank you for your reply. I will definitely look into this.
is there a way to make it send these emails automatically when a certain trigger is hit? for example if you had a due date column can u make it do exactly what it did but only when its the due date?
I have the exact same question. were you able to figure out how to do it Kevin?
Me too 😂
You could set a scheduled trigger every day, list all rows in the table with Odata filter when date = today, then send emails.
can you show us how to add pdf attachments in Excel? need to send individual files to individual email adressess. thanks!
Hey Rich, Did you ever find the answer for this? Or video that shows you..
@@clickbisi7016 sadly, not yet. but there is a way thru sharepoint and powerautomate. It is a bit complicated though
@@richelsantiago ahh yes I was looking into that but my work 365 account is not linked to REST API so won’t work with Outlook. I have however found a tool created by Doug Robbins that works as an addin to the usual MS Word+Excel desktop mail merge, google ‘Mail Merge Tool Doug Robbins’ if you’d want to check it out
This video shows how: ruclips.net/video/GopFj0mpGEg/видео.html
Thank for sharing.. awesome..
Power automate is awesome!
Thank you for the tutorial sir. If I want to send separate email to multiple people with different values. How would I do it? Is there away I could send all individual emails at once?
I wonder if you could separate email addresses with a comma like you would in an email....
A comma list will send a single email to all in the list. If you want to send a separate email, split the list in power automate, then loop through the resulting array.
Awesome and very helpful video sir.
Thanks! Glad it helped.
Thanks for this video.it is very useful.
When I am trying to get flow app from store then it shows error.
Also 1 question...do we really need onedrive sharepoint for power automate..? Bcoz current organization not giving access of onedrive or sharepoint. Is there any alternate way?
I wanna send different files to each individual. How can we do that?
Great Video!
Instead of running the flow for selected cells, is it possible to run when a condition is met? (For example before somebody is running out of stock). Stock is updated once a week, a nice form for ordering is linked to the online excel if somebody already run out but a warning message for ordering before stock ends would be greater! At the moment we handle this step manually.
Regards! Carmela
I used the selected row trigger, but you might want to use the schedule trigger to run every day (or every hour). Then list rows in your Excel table with a filter on those that need restocking.
@@HowToExcelBlog thank you for your answer! I will definetly try that!
@@HowToExcelBlog it worked! 😁
Good to hear! Have fun with power automate, it can do a lot 😀
I want to schedule the emails based on a date column (Duedate) at the table. If today=Duedate, then only mail should go with details on that specific row.
Please suggest.
Can this be done without having peoples email in excel. So just having them type in a persons email or be able to just pull the email from their personal email?
This is helpful, thankyou!
can we send email reminder to multiple emails from one column in excel and when one email has updated the status as "Completed" power automate will stop sending the email reminder but continue to send to the rest of the email from that one column
Dude that was very helpful
Hi John.. thanks for sharing this. Lots of interesting things possible with Flow / Power Automate. Thumbs up!
Hey Wayne! Yes, you can do a lot with Flow. I've been working with it quite a lot lately and it's my new favourite service.
i doo exactly like you do and on 6:33 my run button is inactive and i have no errors or nothing.. what is wrong ? i was try with all email apps its all the same button to run flow is always deactivated so this is not working.. i just need to simplyfy my task to send 1000 emails, and this super complicated microsoft crap its just not even close to working.. I just need the flow to generate my email, and i click send it. Its allways the same email with same file atached, but how do i automate that with flow ? I need fully working with all nice and sexy hyperlinks in custom signature and pictures all have to be flawless looking. this flow email send v2 cannot read signature logo pictures thats super anoying.. do you have any solution i have like list of companies and 1 column is a email, how do i send emails via flow ?
Very interesting I will definitely explore this solution deeper
Yes! Power Automate is a must to try out!
Can you show an example, where you have maybe 3 different companies each with their own email address but multiple invoices due, where it would NOT send a seperate email for each single invoice due, but send a single email to each of the 3 companies, with the data from each row that is relevent to that specific company?
Could you chose a different “from” email address for esch recipient?
This is very nice. thumbs up. How do you add some people to the cc?
Nice! A good alternative to Word Mail Merge>
It's a billion times better than a mail merge. You can do so much more with power automate!
How To Excel do you have more advance videos using this process. More complex example.
@@cyclingmc this will get you started ruclips.net/video/OpQ9I6KZlUI/видео.html
What if the email in your excel file is created using vlookup for example. The flow pulls in the function and not the value and therefore it doesn't work. is there a way of getting flow to pull in the string and not the function? WITHOUT converting the formulas manually in the excel file by copying and pasting as values. The list continuously increases due to forms data imputing into the excel file. Thanks.
Does it? I was not aware of that. If you come across a solution, let me know.
You could do the vlookup in Flow (get rows from table then filter on a given value).
Can anyone tell me how to do this with automate? Thanks! I have an Excel table with 7 columns and hundreds of rows: ‘code’ column, ‘description’ column, ‘quantity’ column, ‘total value’ column, ‘owners’ column, ‘manager’ column, and ‘functional managers’ column. I need to send the table by email to each owner, manager, and functional manager, but only with the rows relevant to them. The rows for owners, manager, and functional manager are populated with their email addresses. Please note that there can be more than one owner (multiple email addresses in the same row).
support.microsoft.com/en-us/office/create-and-manage-sheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6
Maybe this might be a good solution
Thank you for sharing! So simple and succinct!
Good day, what is the maximum number of emails allowed for this flow? Thank you
Great video. Very useful . Thanks
Great video, question. I have an excel sheet that I need to send out on a cadence. I am unable to pull the email contacts from the report onto my report but have the first and last name of the people I need to email on my report. Can MS Flow use the first and last name contacts within my company to email the report to action?
Thank you for the video.
I think you can use the office 365 connector to search for the user and get their email.
@@HowToExcelBlog @AT how are you setting up your spreadsheet for a cadence delivery? How did you set up your list and PA to do a cadence? I am looking into using this as a temporary method for sales prospecting until we get SalesLoft live.
Do you need to have a Microsoft Business account to use automate? My personal account does not let me use Add-In's at all
Very cool flow. Will it avoid bulk email/spam filters?
HI this might sound tough to achieve but can you tell me how to automate unique email body with multiple paragraph from excel where the end receiver should be able to receive proper email format i need to this be implemented in power automate flow
Might be easier to create the email body in Excel with formulas or otherwise
@@HowToExcelBlog I tried my best using formula %0A for body and divide the body into differnt paragraphs but still its not working, please can you help me in this as ill be saving 5 hrs per day
Would it be possible to do this from a shared mailbox?
My edu has locked out users frm adding any add-ins at the user level. Is there another method or way of installing this? I am going to ask my IT office to whitelist it, as it is MS made, but it might be an all other nothing type situation (students, staff, faculty). They don't tend to allow them if that is the case, like with some google add-ins as well.
You can still build flows by going to flow.microsoft.com and logging in with your office 365 credentials. Can build lots of other types of flows there.
How To Excel thank you will try!
Hi, is it possible to add an attachment on the email as well?
Thanks for the wonderful video. Is it possible to send the meeting request in outlook using excel file and including Microsoft team in it
?I am trying to get the data from excel file and send outlook meeting requests including Microsoft teams in it. I tried with the UIPATH, I can send the outlook meeting request but we cant include the Microsoft team in it and I don't want to record the process in the UIPATH. Could you please let me know if you can do something in Power Automate. It will be really helpful. Thanks
hi john on e query i want to choose my file so how do this bez I have not seen my file except other fils.
Great ! Appreciated.
HI, Thanks for detail explanation. can we put date specific reminders.
Yes this is instant flow , you can use schedule flow.
Really Interesting...Thank You John!
No problem Darryl!
Do you have a solution if I would like to send multiple lines in 1 email?
Thank you in advance
Use list rows in power automate and perform a join on data.
yes i just took my time to learn vbs macros, and that one is 100% working :)
my situation is, I would like to make a registration link. After clicking the link , what I would like to happen is 1. have a place to type in email address, name 2. add the name to an excel file for record and add the email to MS Team group 3. send email confirming the registration and 4. notify the registered member when the meeting is about to happen.
Could this be done? I don't see the big picture of how each modules ties in together. Thank you
Yes, this can be done. Use an MS Form then use power automate to create a user in azure AD when a new response to the form is submitted then add the user to a Team.
Awesome! I love it.. Can this be applied in WPS?
Is there a way to set the flow to automatically run when manually entered data in the table is changed?
There is no on change trigger, but you might be able to hack one together. I'll have to think about it.
How To Excel Awesome! Thank you. Is there a way to schedule tasks to run such as opening an Excel workbook once a day or once a week?
You can definitely schedule a flow. Why do you need to open the file? Since it's in the cloud, you can run tasks without opening a file.
I have a workbook with macros that perform specific tasks and interact with other workbooks on a shared network drive. I want to perform those tasks once per week. I can trigger the macros to run when the workbook opens and then close the workbook when they are finished. If a flow can be created to just open the workbook once per week then the entire process becomes automated.
You can use a RPA flow to open a workbook, but this is a premium feature in Flow and its still in preview.
Excellent explanation! Very useful!
👍
Hi, an attachment can be added? thank you
Great Video. Thank you so much.
Amazing!👏Thank you, Sir! Subscribing
If I want to send notification to email ids in excel table column 15 days before the current date...would it be possible with flow?
Yep, you could do that.
Sorry, a bit more involved than a comment can explain.
GREAT tutorial. BUT does anyone know how to tell if the reciever viewed, opened, or clicked a link in your email?
Create your links with a service like bit.ly
Hello, what if I have 3 different email addresses!? How should I do the flow?
amazing
How about adding an attachment?
You can definitely add an attachment in the flow.
Hello, such a great video and this is exactly what we need. I tried it and followed exactly what was done on the video. For some reason i can't run the flow. 1st attempt, the Run option is disabled. 2nd attempt, the flow i created is after i saved it, the flow is gone in excel. when i logged into my power automate, the flow that i created is there. but since it's not showing in excel, i can't run it either. hope you can help..thanks in advance!
i am having the same issue.. the Run option is disabled. Any idea if this has to be purchased as outside Office 365?
hey, i found out why.. it all should be in text format to run the flow.. so incase you have any column/field in number format, it wont enable.. try converting it text and see.. hope this helps!
Hi, great tutorial! How do you email the whole table in the email?
Same question 🙂
How can we add an interval of time in between sending mass emails?
Hi...how can we add an attachment in this for each row.
3.07 add a table. that part wasn't quite clear. how was the table already populated?
Very well explained! Thank you! This was super helpful :)
Glad to hear Silvia. Any ideas on how you'll start using this in your work?
i am not getting option to run here, what can I do?
I have a sheet with duplicate recipients with multiple companies under them. How can I consolidate the multiple companies and send one email to each recipient in place of multiple emails.
i am having this same question also, how to send one email (in which there are multiple companies) to that recipient?
Same question. Would be nice if the rows for the same recipient can be consolidated into just one email. Has anyone of you figured out a way to do this?
How would I include my signature on these emails?
how can we send these mail with attachment on a daily bases
use power automate desktop
Can i add dates when the email should be send?
What about multiple date for single email let’s a bunch of invoice and it’s amount to different emails how can make it possible
Hi, my date value transfers to emails as number. How yo change? Also can i send email row by row. Sending individual emails at multiple times per day as an item is updated
Is there a way of scheduling the report?
Sure, use a scheduled trigger in power automate.
Have you got the solution Sir ?
While scheduling in Power Automate, how to define condition there? Suppose email should go on Due dates only.🤔
I have similar use case with small change, I need send multiple approval emails based on excel but I a am facing an issue that the flow is running in loop, unless the first email is not approved, it is not getting triggered the second approval for the next row in excel. Can you please let me know how can I solve this?
what if you want to consolidate the rows before sending to the recipient? Let;s say the emails are A@gmail and B@gmail, and some rows shoulld go to A, some to B?
I have the same question,, did u find some way?
How can i get information to other excel (im not the propietary) but i want to join this information and search automatically information on that :(.
In drive, it has "importrange" to get information to another excel but in microsoft 365 (onedrive) i dont know how to connect this when other person have the excel in onedrive. How i can do that with power automate?
You can't search for an Excel file and connect to it from power automate. You have to pick the Excel file before the flow runs.
Is there a way to mail to one person but then include the others in CC?
Have you ever worked with api's and power automate?
Yep, either use the http connectors or build a custom connector.
Both are premium license features.
@@HowToExcelBlog I tried the http connector but im sure of the format that I need to use. The Api I'm trying to use requires a oauth authorization. Am I able to share details around this with you? Do you have a paid private support line I can utilize or something of the sort for your support
*Not sure
@@Budgetblueprint786 try building a custom connector. It's got easy-peasy Oauth handling. This video will help ruclips.net/video/2fdRtWtTmvs/видео.html
@@HowToExcelBlog hey thanks will get back to you to let you know how it goes. Fingers crossed
OMG!! This is so helpful! But how should I run this again if ever I've added more data e.g. names, email and amount?
Is there a way to automate emails without having to add in "Flow"? My company does not allow us to add add-ins :(
You should be able to do this with VBA
thanks for your video. but i want to send mail with attachment. can you help me
Thanks for vedio but after i done all the step I don't run the history some things went wrong
How to send email to selective list within the same column?
Hello, in my table I have a date column, when I include it in the body of the email, it is shown as a number and not as a date. How can I make it show as date? So 08/18/2020, not "43869". Thank you
Does anyone know how I would add my signature to the bottom of the email?
Hi, how can we send attachments through Excel
Is it possible to send an email every time a new row is added to excel file ?