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
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
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!
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
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 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?
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?
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?
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!
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.
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
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.
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?
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?
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?
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?
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?
@@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
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?
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, 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
@@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2fdRtWtTmvs.html
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.
Anyone else getting this error "AADSTS50020: User account from identity provider 'live.com' does not exist in tenant 'Microsoft' and cannot access the application 'e01eb8c0-2b79-4a23-9cb0-90694634c338'(Microsoft Flow Launch Panel) in that tenant. The account needs to be added as an external user in the tenant first. Sign out and sign in again with a different Azure Active Directory user account." when trying to sign in to use flow?
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
Literaly i spend like 2 hours studying this flow, and this crap is not even working with templates, seems there is no way i could run any flow what ever i do run button is gray out... do you know what could be wrong >?
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 ?
also i noticed when i click flow buton it does not see any flows i created, and if i create new one its named with -2 on the back, i cannot see my flows that i created i tested in website in everywhere i just does not let me run it..
Hello, I tried it, but it just works for only 256 rows, what can be done to increase the rows to more than 256. I need to send like 5000 emails in one shot from Excel
@@HowToExcelBlog thanks for the response, I tried to replicate. It stops with 256 rows even in personal email. I tried Trigger manual -> List rows present in table -> Apply to each -> Send email. The excel with the table was in a sharepoint.
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?
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
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.
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
@@HowToExcelBlog 30+ clicks to configure the whole thing is not too many? Plus pay for the Flow. Plus expose your data to somebody out there in the cloud? Too much effort and risk for me.
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.
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?
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 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
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?
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.
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.
and i have find out its the bugs thats related when you have more than 1 microsoft account... very stupid bugs... you need to delete and have only 1 microsoft account so you can use flows properly