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.
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!
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?
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
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?
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
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!
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!
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?
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
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?
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?
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.
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 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?
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.
@@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
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.
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
Amazing ... Can we send an email without sign in to the system or when your computer is off for example ı have an excel table and there are due dates so i need to send reminder 30 days before the due date without login to my computer is it possible?
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
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.
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.
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!
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
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?
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
somewhat irrelevant..i want to make a button flow where in outlook i want to reply to client with a auto email “your request is done” either by pressing a button or by dragging the email to a specific folder
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 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.
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?
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 ?
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.
Thanks for this video! I've been looking for a way to do this without writing VBA and here it is!
Awesome! I'm happy to be on Earth now with a feeling like everyone around me is trying to help me to Excel!!
Glad I came across this video. Simple and effective. Great Tutor!
I have been on CZcams all day searching. Thank you so much this is going to help so much
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!
Exactly what i need right now.. Simple and straight forward.
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!
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?
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.
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?
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.
Great explanation!!! THanks for the help
How cool is this! I will test this right away. 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
Sir in this video, Working with different attachment for individual email address?
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..
Very interesting I will definitely explore this solution deeper
Yes! Power Automate is a must to try out!
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!
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.
Thank you for sharing! So simple and succinct!
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?
Awesome and very helpful video sir.
Thanks! Glad it helped.
Thanks for the video. Do you know how many max email that power automate can send per day?
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
Thank for sharing.. awesome..
Power automate is awesome!
Really Interesting...Thank You John!
No problem Darryl!
This video is awesome, thanks for sharing!
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?
Hi, would it be possible to have the emails accumulate in your outbox in order to attach items?
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
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.
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.
This is helpful, thankyou!
Excellent explanation! Very useful!
👍
Great video. Very useful . Thanks
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 very nice. thumbs up. How do you add some people to the cc?
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.
Could you chose a different “from” email address for esch recipient?
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 czcams.com/video/OpQ9I6KZlUI/video.html
Very cool flow. Will it avoid bulk email/spam filters?
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.
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?
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 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: czcams.com/video/GopFj0mpGEg/video.html
Great Video. Thank you so much.
Dude that was very helpful
Awesome! I love it.. Can this be applied in WPS?
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
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.
Good day, what is the maximum number of emails allowed for this flow? Thank you
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
How can we add an interval of time in between sending mass emails?
Amazing ... Can we send an email without sign in to the system or when your computer is off for example ı have an excel table and there are due dates so i need to send reminder 30 days before the due date without login to my computer is it possible?
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?
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
Hi, is it possible to add an attachment on the email as well?
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.
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!
How would I include my signature on these emails?
HI, Thanks for detail explanation. can we put date specific reminders.
Yes this is instant flow , you can use schedule flow.
is there a way to have the email flow run automatically with a cell as a trigger (i.e. if C11="yes"2) or whenever the value of a certain cell changes?
Not on change, but you could set up a scheduled flow that runs every hour and only runs for rows where there is a yes.
@@HowToExcelBlog could you make an instruction for this??
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!
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.
Great ! Appreciated.
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 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
How can I keep the email format from the flow 😅 The email format (font text and color) keeps on changing even I saved it multiple times
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
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?
Amazing!👏Thank you, Sir! Subscribing
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, great tutorial! How do you email the whole table in the email?
Same question 🙂
somewhat irrelevant..i want to make a button flow where in outlook i want to reply to client with a auto email “your request is done” either by pressing a button or by dragging the email to a specific folder
You might be able to do that without a flow.
www.msoutlook.info/question/reply-with-a-message-template-via-quick-steps
Let me know if that works.
Hello, what if I have 3 different email addresses!? How should I do the flow?
Thanks for vedio but after i done all the step I don't run the history some things went wrong
thanks for your video. but i want to send mail with attachment. can you help me
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 :)
Hi, an attachment can be added? thank you
i am not getting option to run here, what can I do?
How about adding an attachment?
You can definitely add an attachment in the flow.
Is it possible to send an email every time a new row is added to excel file ?
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...how can we add an attachment in this for each row.
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.
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?
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.
Is there a way to mail to one person but then include the others in CC?
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.
My flow refuses to send the email. The error message I get is "Bad Request". It only happens when I try to pass the email address dynamically.
There's a new-ish button on the top right of the email field that you need to click on to input dynamic content.
It won’t let me run the flow. Ps: I’m using my school’s email. Is that a problem?
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 i add dates when the email should be send?
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