Thank you so much!! It has taken me a lot of attempts and a lot of different tutorials! This one was so easy to follow and I did it! We now have an automatic email reminder for our tech subscriptions at a school. Great life saver so we do not forget anything!!
You alleviated my discomfort! I liked your video since it solved my problem, especially the part about sending a single unique email to a list of outstanding rows rather than sending many emails to a person for an overdue task! Brilliant! You're the greatest! 🤩😘🥰
@@MyOnlineTrainingHub Please add another action that after Create HTML table to improve the style of the output table, which is currently just a plain text table with no formatting.
Excellent tutorial Mynda, thanks for sharing. I couldn't add the filter for the second action as I failed to find the proper format for Canada EST. Otherwise, it worked fine.
There isn't a standard time for Canada as it covers numerous time zones. For example, Calgary is Mountain Standard Time and Toronto is Eastern Standard time. Hope that helps.
Very informative, thank you Mynda. As a school we use Gmail as our mail client, so i have replaced the Send Email v2 connector with a Gmail send Email (2) and works a treat. Thanks again
This video is very on-point with a good example of how to use power automate in a useful way. Do you have a playlist for your power automate related videos?
I would love to be able to do this but with creating separate Excel workbooks for each. I tried using the OneDrive "Create File" function but couldn't get it to work. Love this tutorial! Thank you so much for all you put out there!
Glad you liked it, JoAnna. There probably is a way with separate workbooks, but that's beyond my Power Automate skillset at this point 😁 Try the Power Automate community forum.
Myanda, thank you for sharing this video. However, it would be helpful if you can share a tips on how to create dynamic mail body, sender name and attachment
I'd love to, but I'm not a Power Automate expert, sorry. If you're stuck, try posting your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Excellent tutorial. Excellent explanation. The flow can be easily adapted (with the great explanations of Mynda), to different flows. Thanks for sharing Mynda.
@@MyOnlineTrainingHub Syntax error at position 45 in 'ReminderDate eq' 2023-06-12T16:19:05.2812274''. inner exception: Syntax error at position 45 in 'ReminderDate eq' 2023-06-12T16:19:05.2812274''. getting this error
Amazing video. I was stuck on formatdate. Didn’t find any video that used the dynamic content in html… finally!!!! Pls pls pls create a power automate list. It is not there when i looked in the playlists.. waiting for more power automate videos!!! ❤❤❤
@@MyOnlineTrainingHub I understand!! Will keep looking for more on this to be made by you 😉 this was pretty simple, clear and instantly useful. Loved it!!! More success and power to you..
Excellent tutorial and loved how the step by step has been provided. Is there anyway possible if to run a script of the reminder due date has past? 1st attempt using power automate and am loving it. Is there a way to run a parallel script with a different reminder due date? Would be keen to view later videos of a similar nature. Thank you!
Glad you liked it. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
I normally add another row on excel to convert the date and time into text 😂 i learned something new. Im not an expert, i learned power automate on my own. but i noticed that you used a couple of function that can be done by get a row alone 😀✌️ Great tutorial tho.👍👍👍
Best video ever after looking into many video tutorials and succeeded to sent email on reminder date looking into your video. But want to send it until the due date comes (recurring everyday until the due date). Can you help me on that ?
So pleased it was helpful. Regarding sending it every day until the due date, unfortunately, I'm not a Power Automate expert, so I'm not sure myself. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
I really enjoy your crystal-clear training. I followed step you suggested but got stuck at apply to each step when it causes an error "The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose')' is of type 'String'. The result must be a valid array." what should I do in this one?
Great to hear! Unfortunately, I'm not a Power Automate expert so I'm not sure what the issue is. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
This video is great and she is so good at explaining each step. I tried to mimic the exact flow by creating the same table but I get an error under the Create HTML action : Unable to process template language expressions in action 'Create_HTML_table' inputs at line '0' and column '0': 'The template language expression 'outputs('Filter_array-1')['body/value']' cannot be evaluated because property 'body/value' doesn't exist, available properties are 'body'. Has anyone else experienced this?
I wonder if you're having trouble due to a regional setting. However, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
The flow works well thanks. Just one quetion, if I have 10 rows of data with a common due date I get 10 emails each with the same information. Is there a way to group the rows of data so I ony get one email instead of 10?
I'm sure there will be however, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hello thank you first of all. I want to change it so that it sends an e-mail if today's date is the same as or past the ReminderDate. What change needs to be made?
Great question. However, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi. This video is very helpful! I followed these steps last october 2023, all were working. But I think there was an update with Power Automate (obviously the look of it is now different). Not sure if this has an effect on the previous flow I made copying from your video. Would it be possible if you recreate an updated video, using the examples you have here, but in the new platform of power automate? Really hope you can help out. Thank you so much 😊
That's a shame. I'll add it to the list of video topics, but I'm not sure when I'll get to it. In the meantime, you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hey, this is very useful for me as to remind me task on which id due on yearly basis. I have follow all the step mention in the video and run the test which is also success but I am not getting any Email and after "Apply to each" step all below step (i.e. filter array, create HTML table and Send and email (V2) ) are skipped by putting message like "ActionConditionFailed" Kindly let me know what to do to resolve this error
Glad you’ll be able to make use of it. If you’ve followed the steps exactly, then I’m not sure what’s causing the error. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi Mynda, Thanks for the detailed and step by step explanation. I tried and created a similar flow, but I am not receiving email alerts. Can please help me to fix this issue?
I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hy Mynda, this is usefull for me, Thankf for that. I'd like to know how can I understand from zero the construction of expressions in this tool, is it an especific lenguage? What material do you reccomend me to start?
Hi, this tutorial was exactly what I was looking for. Instantly had me subscribe your channel. Could you please help me with a query though? I am receiving the emails the number of time of the row. For example if 2 tasks are due today then I am receiving the email twice with the 2 rows of the same tasks. How do I edit the flow so that I only receive the email once?
I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thanks, Vesa! I'm not a Power Automate expert, please post your question on the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Briliant Tutorial! Quite engaging, I enjoyed it very much. Just had an issue not finding my excel document. We use Dropbox and sharepoint and but no matter which one I chose, I could find my document. What am i doing wrong?? :(
Glad you enjoyed it! I'm not sure what the problem might be and not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi Mynda . Thanks so much for your brilliant presentation. After much searching on how to set this up in Power Automate I found this one the most helpful. I know it's been quite sometime since you put up the video but I am hoping you can help me with a query. When I set this up yesterday it worked perfectly. I received an email to my inbox reminding me of the task due. However, I had a task due today and did not receive an email. When Ii run the test it tells me that it has run successfully but I am not receiving the email.
That's odd. I wonder if it's a time zone issue between the time zone of the Power Automate server vs your time zone. I'm just guessing. For more expert advice you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi thanks for the video, do you have video for creating outlook calendar event from excel with capacity to auto update if there is any change in the excel thanks.
No, I don't, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi Mynda, thank you for your tutorial. I have a question. I have a question, I want it to continue sending e-mails after the reminder date has passed too. When you delete the related row or update the date in Excel, it should stop send mail. for example: today: 13.07.2023 reminder due date : 13.07.2023 (This system is sending mail ok) tomorrow : 14.07.2023 reminder due date: 13.07.2023 (this system should send to continue mail during a mounth remaind up to change or update date) How can i do this, which parameters should i add? thank you.
I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
I'm sure it is however, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Great tutorial Mynda. If I need to capture all rows/records that fall within say today and 60 days later, how would I best build in the filter? Tried to replace the "eq" with a "le" in the list filter query, but it didn't like it.
Hi Gordon, in that case you're filtering for dates that are equal to today OR less than or equal to today +60 days. So it'll be something like: ReminderDate/all (r: r eq 'formatDateTime(utcNow(),'yyyy-MM-dd') or r le 'formatDateTime(addDays(utcNow(),60),'yyyy-MM-dd') ) That might need some tweaking as I'm not expert on ODATA functions. You can find out more here: docs.microsoft.com/en-us/azure/search/search-query-odata-logical-operators
@@gordoncprice Did you ever find a way round this? I am also trying to only get content from an excel table based on whether it is within a 30 day 'deadline date', as opposed to all content, all the time.
Thanks, I've been searching for this. One question, though, if all the reminders go to the same person, in which case I wouldn't need an email column. Which steps in the flow can be skipped?
I'm sure you can modify it to handle this however, I'm not a Power Automate expert. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you for the great video. I am beginner at Power Automate trying to setup automatic emails 90, 60 and 30 days in advance (of the due date) using my excel tracker. I have made my excel sheet and tables, but when I want to enter tables, it only shows table 1 to table 7 without my table headers (or names). How can I fix this? Thanks, Al.
Glad you liked it 🙏 I'm not a Power Automate expert either, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
I don't have the file to hand, sorry. It's only 5 columns and a few rows so should be quick to recreate. Then you can follow the steps in the written tutorial: www.myonlinetraininghub.com/automatically-email-reminders-from-excel-with-power-automate
Hi Mynda, really great tutorial. Is it possible to break the items pulled from the excel into the body of the email? They load in fine but are all cramped together. Is there a way to add breaks between items in the filter array to better list out the headers and values? Also, is it possible to list multiple dates in the excel so that the emails could fire on certain assigned dates in the future? Kind regards from Dublin, Brian
Glad it was helpful, Brian! I'm confident you can do the things you want, however I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thanks Mynda it’s a great tutorial. I used it and it worked for two flows without any issues. The third and fourth time I ran the flow it started sending emails and did not stop. Can you please help me resolve this issue.
Glad you were able to make use of these techniques, Umar. Not sure what the problem would be. You're best to post your question on the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
I don't have a tutorial on that. I recommend you post your question on the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you so much! extremely valuable video! only one important thing i felt missing is the output, could you please add the part to see how does the email looks like after running the query ? thank you!
@@MyOnlineTrainingHub I watched that video closely many times and followed the exact steps but from some reason it appears that the distinct list of emails doesn't work for me, the emails sends to all the address multiple times and i cant get it to work, i have no idea what am i doing wrong, please help me figure this out, my company relays on it and it will be so greatly appreciated , thanks in advance!!
Ive found the problem!! When i created the "send email" i inserted inside the subject a variable from the Excel table, (the automation sends seperate emails to each vendor and i wanted the subject of each email to contain the vendor's name in each email difrently) that process created aditional loop, so when i romoved the vendor's name from the subject the loop was romoved and now the distinct adresses are working, but i still need to find a solution to put the specefic vendor name in each emai withot creating aditional loop...
Excellent Tutorial. I created a flow for due date. How about the due hours ??? Please help me out. I’m not expert either that much good in power automate
Glad you found it helpful! I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Excellent video! Very easy to follow :) I would like to set a reminder both 30 days before and 14 days before the deadline. Would I need to create a second flow for this?
Thanks, Matt! I would think you can incorporate the two reminders in the one flow, but honestly, I'm not an expert in PowerAutomate, so I could be wrong.
@@shahanshilashrestha2304 I have mine set up to send a reminder 7 days before the due date. What I did is make a column in my spreadsheet, i took the due date cell -7 days or 14 days, and then used that column instead of the Due Date column. I called it the reminder column. Hope that helps.
It's so important to follow the direction closely. I wasted 3 days because I missed "Click on the Text icon:" in the Select Step. I hate myself for this because I would have learned so much more in 3 days if I didn't miss this. Well, good thing is that I learned some other skills while trying to fix this.
Thank you so much for this! Is it possible for filter query eq the date and older? I want emails to continue to keep coming until the reminder date has been changed to a future.
Glad you liked it. Regarding modifying the flow, unfortunately I'm not a Power Automate expert. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Can I include a link in the generated email to a Microsoft form or other file like Excel that could allow me to prompt staff for further questions or information? Thank you for the helpful video, and whatever guidance you can provide 😊😊
Hi, Thanks for the video, it is very helpful. I want to filter data from excel instead of equal to a specific date, I want to select a range of dates, please let me know if this applicable. thanks
Possibly, but I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you for this tutorial, it is very helpful. Could you please tell me if it's possible to send just one email for multiple entries from the table? Currently if there are multiple lines included in the table, it sends multiple email reminders. Thank you!
Thanks for this video, so easy to follow! I have one issue that I’m struggling to resolve: I’ve set up the flow and tested it on a sample group (10 people) which all works as planned, however when I use the flow for the full list (approx. 900) the flow seems to max out at around 32 emails. Any help would be appreciated! Thanks
So pleased it was helpful! Not sure about the limits. I wonder if it's your subscription with Microsoft that's limiting it. You might need to check your account settings.
Thanks, this is great! Could you please help me with a problem, Whenever a new Excel file is placed in a SharePoint folder, I want to read its contents and send emails accordingly. Each Excel file will have a different name, but the table design in it will be the same.
I'm not an expert in Power Automate. Best to seek help in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank, Sarah! I'm not a Power Automate expert, so you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you Mynda for this video! M flow ran successfully as shown in PA, but I didn't get the email notification. What could be wrong? I'd be grateful for your input
Great to hear you were able to get it partially working. Unfortunately, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Glad it was useful. If you're stuck adding more than one email, post your question in the Power Automate Community forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
This is great! I am however running into a problem where I try to run a second filter based on another cell value, multiple emails get sent. Not sure if I'm misssing something obvious? Keep up the great work, thank you!
Glad you like it, Jeff. You might like to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi, thank you so much for this tutorial, it helped solved my problem. However, if i only want to send the email where those tasks that have 'Pending' status and ignore those that are 'Completed', how should i do? Thanks in advance
Great question, however I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Very good thanks. Can you do the reminding not with a new email but somehow following the latest correspondance (using entryid or conversationid or something else)
Probably however, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Amazing video! thanks for sharing. I got issues on the Date Format "formatDateTime(convertFromUtc(utcNow(),'E. Australia Standard Time'), 'MM-dd-yyyy')" how should I adjust for GMT 0 (West Africa)? Thank you!
Hi, I followed the instruction and I did find one error in the flow. I couldn't get it to work until I found the error, but otherwise thank you for putting together and helping me. I would like to know how you can set a rule or add a step in the flow to only send reminders for active tasks and not closed tasks
Glad you found it helpful. Regarding the active vs closed tasks, you're best to post your question in the Power Automate support forum as I'm not a Power Automate expert, sorry: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
So many cool use cases, thank you! For mine, I need to to show any data added in the last 7 days in the output tables say, not just due on todays date. How might I edit the Filter Query expression in the List Rows step? Any tips appreciated! edit: Similar to Gordon Price :)
Great to hear, Brett. Similar to what I said to Gordon, you're filtering for dates that are equal to today OR less than or equal to today -7 days. So it'll be something like: ReminderDate/all (r: r eq 'formatDateTime(addDays(utcNow(),-7),'yyyy-MM-dd') or r le 'formatDateTime(utcNow(),'yyyy-MM-dd') ) That might need some tweaking as I'm not expert on ODATA functions. You can find out more here: docs.microsoft.com/en-us/azure/search/search-query-odata-logical-operators
Thank you for the video! Can I have multiple email addresses in one excel cell and send to all those address one email asking for input "participant names" for a "meeting" ? In may case each meeting will be one row hence needing to have in the "email" cell multiple email addresses.
It's not ideal to store multiple records in a single cell. Maybe if they're separated by a delimiter, you can use them, but you'd have to ask your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hmm, that's odd. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Excellent tutorial! I would be curious though if there is a way for it to only send the email for a task once (i.e. such as a week before the due date, instead of every day leading up to it)? Also, what happens if you don't remove tasks from the list? Does it only pull from tasks that are after the current date?
Thanks, Christopher! With the method I've shown it will only send it once, on the 'reminder date'. The process runs every day to pick up any new tasks that have a reminder date of today. If you don't remove tasks from the list it won't matter as it filters the list to display only those tasks that have a reminder date of today using the utcNow function.
@@MyOnlineTrainingHub Oh duh! I totally forgot you had a separate reminder date column *face palm* That makes so much sense. I apologize for the silly question! Keep up the great work.
Thank you for your video. I have a small employee chart and we are trying to generate email reminders, but I keep getting this error "There is an unterminated string literal at position 24 in 'REMINDER eq ' 2023-09-28'. inner exception: There is an unterminated string literal at position 24 in 'REMINDER eq ' 2023-09-28'. clientRequestId: cd39f8fb-9753-40a2-9b9e-7eeffc69f53a" It would be a wonderful thing if it works for me.
This is exactly what I was looking for. I tried to duplicate this since I have a similar task at my work, and I found that in the filter array control, when I add the parameters, I see you did from "Value" and the filter query "email is equal to current item". For me, the from is only showing body/value instead of just value and because of this, the flow is skipping every step because of this. Is there a way to fix it? Power automate doesnt seem to add a separate value expression, it just adds body/value together.
I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Base on your video, i can see the column header called "Email". May i know if this is sender email address or recipient email address? If this is for recipient email address purpose, can i put more than 1 recipient address at the same time? if it's allowable, should i just use "Comma" as separator in the same excel row cell?
Excellent video. However, I am unable to see "value" in the list of items. Hence flow after "Apply to each" is getting skipped. Please let me know how i can correct here. Really appreciate your response.
Not sure what's gone wrong for you there. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Strange 🤔 I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi, Thank you very mush for the explanation. I have been searching for this type of flow and could not fine one till now. It work on the file and Table I have now. But it is sending email of every status I have. Need your help and suggestion. How do I trigger email based on only two conditions using And Condition.
Glad you found the video helpful. Regarding your question, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you for this tutorial. I would be happy if you could assist me in a simple task. I would like to send an Email to myself several times every day to remind me of several task I must do on a daily basis is this possible. The tasks are listed in the excel sheet along with their times and I would like to get an email at the beginning of every task Thx
Glad you found Power Automate helpful. I'm not a Power Automate expert, so you're best to post your question on the Power Automate community forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Glad you liked it 🙏 In regards to adding a CC address, you’re best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thanks, Mynda, for the helpful flow. I am able to run the flow without errors and receive email, but the email content only shows the column headers mentioned in the HTML Table creation step ... there are no values showing up under the column headers. Please help.
Glad you liked it. Please post your question in the Power Automate support forum where someone can help you troubleshoot: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hai nice work by the way, i have a question about filter query. Can i make query that RemainderDate equivalent to today date also after date. Because i wanna keep emailing the remainder task everyday even the date is due. Thanks
Yes you can. If you get stuck, you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Is there a way of having the emails generate and pop up on our screen before sending? We often have attachments - that cant be autoattached or we have clients that need an email that covers multiple co-insurer invoices so being able to do a quick tinker to the email on those specific cases would be ideal. thoughts on this?
Probably. However, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
@@MyOnlineTrainingHub Hey again! So i am trying to replicate this minus the time schedule but when i get to the 2nd step with the Select field i do not have an option to say Value. Any ideas on this? Could it be how i have set up my excel document/table? Thank you so much in advance!
I'd love to but I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi, would this work for simple reminders for productivity rates for individual employees? If I have an excel spreadsheet for the productivity rates of employees ( 30days, 60days, 6month with the company ect.) Could I set up my excel to send email reminders to the office personnel regarding those milestone dates?
I'm sure you can. If you get stuck, you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you so much!! It has taken me a lot of attempts and a lot of different tutorials! This one was so easy to follow and I did it! We now have an automatic email reminder for our tech subscriptions at a school. Great life saver so we do not forget anything!!
Awesome to hear!
Great example. How do you format to look at tasks within a week range vs daily?
I got congratulations from my manager for applying the e-mail reminder. I really want to thank you a lot. Greetings from Mexico!
Congratulations on your success! Glad I could help 😁
You alleviated my discomfort! I liked your video since it solved my problem, especially the part about sending a single unique email to a list of outstanding rows rather than sending many emails to a person for an overdue task! Brilliant! You're the greatest! 🤩😘🥰
Thanks for your kind words!
@@MyOnlineTrainingHub Please add another action that after Create HTML table to improve the style of the output table, which is currently just a plain text table with no formatting.
Thank you. I had to watch it twice to understand what was happening. Can't wait to try this out.
Yeah, there's a few steps. Hope it helps.
Excellent tutorial Mynda, thanks for sharing. I couldn't add the filter for the second action as I failed to find the proper format for Canada EST. Otherwise, it worked fine.
Thank you! I wonder if you can use the equivalent US time zone to convert your date/time.
There isn't a standard time for Canada as it covers numerous time zones. For example, Calgary is Mountain Standard Time and Toronto is Eastern Standard time. Hope that helps.
Very informative, thank you Mynda. As a school we use Gmail as our mail client, so i have replaced the Send Email v2 connector with a Gmail send Email (2) and works a treat. Thanks again
Awesome to hear, James!
This video is very on-point with a good example of how to use power automate in a useful way. Do you have a playlist for your power automate related videos?
Glad it was helpful. I'm not a Power Automate expert, so this was a one off for me, sorry.
This is an awesome tutorial! I tried it out and it worked like a charm...Thanks a ton!
Great to hear! 😉
I would love to be able to do this but with creating separate Excel workbooks for each. I tried using the OneDrive "Create File" function but couldn't get it to work. Love this tutorial! Thank you so much for all you put out there!
Glad you liked it, JoAnna. There probably is a way with separate workbooks, but that's beyond my Power Automate skillset at this point 😁 Try the Power Automate community forum.
Hi Joanna, just wondering if you got any joy creating the workflow for different workbooks or spreadsheets
Myanda, thank you for sharing this video. However, it would be helpful if you can share a tips on how to create dynamic mail body, sender name and attachment
I'd love to, but I'm not a Power Automate expert, sorry. If you're stuck, try posting your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Excellent tutorial. Excellent explanation. The flow can be easily adapted (with the great explanations of Mynda), to different flows. Thanks for sharing Mynda.
Awesome, thank you, Antonio!
@@MyOnlineTrainingHub Syntax error at position 45 in 'ReminderDate eq' 2023-06-12T16:19:05.2812274''.
inner exception: Syntax error at position 45 in 'ReminderDate eq' 2023-06-12T16:19:05.2812274''. getting this error
Same problem what happened to you ?@@Dora-t1j
Thanks, was searching for this. Got Office Prof but not business 365, so will need to wait for that I guess.
Hi Mynda!Great Tutorial.I Found Power Automate Frustrating At First But Now Love It...Thank You :)
Awesome to hear, Darryl! I would agree that it could be more intuitive to use, but once you get started and have some success it's exciting.
Amazing video. I was stuck on formatdate. Didn’t find any video that used the dynamic content in html… finally!!!! Pls pls pls create a power automate list. It is not there when i looked in the playlists.. waiting for more power automate videos!!! ❤❤❤
Glad it was helpful! I'm not a Power Automate expert, so probably won't be publishing a playlist on this topic 🫤
@@MyOnlineTrainingHub I understand!! Will keep looking for more on this to be made by you 😉 this was pretty simple, clear and instantly useful. Loved it!!! More success and power to you..
Excellent explanation! concise and easy to follow, thank you so very much for sharing this.
Glad you enjoyed it!
Excellent tutorial and loved how the step by step has been provided. Is there anyway possible if to run a script of the reminder due date has past? 1st attempt using power automate and am loving it.
Is there a way to run a parallel script with a different reminder due date? Would be keen to view later videos of a similar nature. Thank you!
Glad you liked it. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
This is exactly what I am looking for! The alternative combination to replace difficult VBA code!
Great to hear, Eric!
Thanks Mynda. Useful lesson! Thumbs up!!
Glad you liked it, Wayne!
I normally add another row on excel to convert the date and time into text 😂 i learned something new.
Im not an expert, i learned power automate on my own. but i noticed that you used a couple of function that can be done by get a row alone 😀✌️
Great tutorial tho.👍👍👍
Thanks for sharing! I'm not an expert either 😂
This is very helpful. thank you for all of your tutorials.
Glad you like them!
@@MyOnlineTrainingHub it saves a lot of my time. I love your tutorials, they are easy to follow.
Thanks a lot... From Tamil Nadu, India
Pleasure 😊
Best video ever after looking into many video tutorials and succeeded to sent email on reminder date looking into your video. But want to send it until the due date comes (recurring everyday until the due date). Can you help me on that ?
So pleased it was helpful. Regarding sending it every day until the due date, unfortunately, I'm not a Power Automate expert, so I'm not sure myself. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Absolutely like it - very useful, hope You will give more examples and good ideas in the future
Great to hear, Ivan 😊
Thank you for sharing, this is very useful. I am trying to do some automation to update a few files and this will help a lot. Thank you again.
So pleased to hear that, Paulo!
Hi Mynda, excellent video, I'm going to try this out, thanks!
Thanks, Chris! Have fun 😊
I really enjoy your crystal-clear training. I followed step you suggested but got stuck at apply to each step when it causes an error "The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose')' is of type 'String'. The result must be a valid array." what should I do in this one?
Great to hear! Unfortunately, I'm not a Power Automate expert so I'm not sure what the issue is. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
This video is great and she is so good at explaining each step. I tried to mimic the exact flow by creating the same table but I get an error under the Create HTML action : Unable to process template language expressions in action 'Create_HTML_table' inputs at line '0' and column '0': 'The template language expression 'outputs('Filter_array-1')['body/value']' cannot be evaluated because property 'body/value' doesn't exist, available properties are 'body'.
Has anyone else experienced this?
I wonder if you're having trouble due to a regional setting. However, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
The flow works well thanks. Just one quetion, if I have 10 rows of data with a common due date I get 10 emails each with the same information. Is there a way to group the rows of data so I ony get one email instead of 10?
I'm sure there will be however, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Very Informative
Glad it was helpful!
Hello thank you first of all. I want to change it so that it sends an e-mail if today's date is the same as or past the ReminderDate. What change needs to be made?
Great question. However, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi. This video is very helpful! I followed these steps last october 2023, all were working. But I think there was an update with Power Automate (obviously the look of it is now different). Not sure if this has an effect on the previous flow I made copying from your video. Would it be possible if you recreate an updated video, using the examples you have here, but in the new platform of power automate? Really hope you can help out. Thank you so much 😊
That's a shame. I'll add it to the list of video topics, but I'm not sure when I'll get to it. In the meantime, you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
@@MyOnlineTrainingHub thank you so much!
Hey, this is very useful for me as to remind me task on which id due on yearly basis.
I have follow all the step mention in the video and run the test which is also success but I am not getting any Email and after "Apply to each" step all below step (i.e. filter array, create HTML table and Send and email (V2) ) are skipped by putting message like "ActionConditionFailed"
Kindly let me know what to do to resolve this error
Glad you’ll be able to make use of it. If you’ve followed the steps exactly, then I’m not sure what’s causing the error. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi Mynda, Thanks for the detailed and step by step explanation. I tried and created a similar flow, but I am not receiving email alerts. Can please help me to fix this issue?
I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Great tutorial, thank you for sharing!
Thank you 😊
Excellent tutorial.
Glad you liked it!
Hy Mynda, this is usefull for me, Thankf for that. I'd like to know how can I understand from zero the construction of expressions in this tool, is it an especific lenguage? What material do you reccomend me to start?
Great to hear! There's more on the programming language it uses here: github.com/microsoft/Power-Fx/blob/main/docs/overview.md
Hi, this tutorial was exactly what I was looking for. Instantly had me subscribe your channel.
Could you please help me with a query though?
I am receiving the emails the number of time of the row. For example if 2 tasks are due today then I am receiving the email twice with the 2 rows of the same tasks. How do I edit the flow so that I only receive the email once?
I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
How to send email to multiple persons at the same time ? Excellent tutorial !
Thanks, Vesa! I'm not a Power Automate expert, please post your question on the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Briliant Tutorial! Quite engaging, I enjoyed it very much. Just had an issue not finding my excel document. We use Dropbox and sharepoint and but no matter which one I chose, I could find my document. What am i doing wrong?? :(
Glad you enjoyed it! I'm not sure what the problem might be and not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi Mynda . Thanks so much for your brilliant presentation. After much searching on how to set this up in Power Automate I found this one the most helpful. I know it's been quite sometime since you put up the video but I am hoping you can help me with a query. When I set this up yesterday it worked perfectly. I received an email to my inbox reminding me of the task due. However, I had a task due today and did not receive an email. When Ii run the test it tells me that it has run successfully but I am not receiving the email.
That's odd. I wonder if it's a time zone issue between the time zone of the Power Automate server vs your time zone. I'm just guessing. For more expert advice you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi thanks for the video, do you have video for creating outlook calendar event from excel with capacity to auto update if there is any change in the excel thanks.
No, I don't, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Very nice, it would be cool to set this up to setup takes in Planner and allow recurring events
I'm sure you could do that too.
Hi Mynda, thank you for your tutorial. I have a question.
I have a question, I want it to continue sending e-mails after the reminder date has passed too.
When you delete the related row or update the date in Excel, it should stop send mail.
for example:
today: 13.07.2023
reminder due date : 13.07.2023 (This system is sending mail ok)
tomorrow : 14.07.2023
reminder due date: 13.07.2023 (this system should send to continue mail during a mounth remaind up to change or update date)
How can i do this, which parameters should i add?
thank you.
I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you for the video. Is this possible to send reminders on a specific time in a day using this method? As an example two reminders 9am and 1pm?
I'm sure it is however, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Great tetorial mem I love you so much
Please replay
Great to hear you liked my tutorial 😊
@@MyOnlineTrainingHub yes mem I like your lecture mem you are so beautiful like rose🌹I love you ❤️
Great tutorial Mynda. If I need to capture all rows/records that fall within say today and 60 days later, how would I best build in the filter?
Tried to replace the "eq" with a "le" in the list filter query, but it didn't like it.
Hi Gordon, in that case you're filtering for dates that are equal to today OR less than or equal to today +60 days. So it'll be something like:
ReminderDate/all (r: r eq 'formatDateTime(utcNow(),'yyyy-MM-dd') or r le 'formatDateTime(addDays(utcNow(),60),'yyyy-MM-dd') )
That might need some tweaking as I'm not expert on ODATA functions. You can find out more here: docs.microsoft.com/en-us/azure/search/search-query-odata-logical-operators
@@MyOnlineTrainingHub Unfortunately OData doesn't support the "le" operator in the filter query. Will keep trying
@@gordoncprice Did you ever find a way round this? I am also trying to only get content from an excel table based on whether it is within a 30 day 'deadline date', as opposed to all content, all the time.
Good job Mynda!
Thanks so much!
Thanks, I've been searching for this. One question, though, if all the reminders go to the same person, in which case I wouldn't need an email column. Which steps in the flow can be skipped?
I'm sure you can modify it to handle this however, I'm not a Power Automate expert. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you for the great video. I am beginner at Power Automate trying to setup automatic emails 90, 60 and 30 days in advance (of the due date) using my excel tracker.
I have made my excel sheet and tables, but when I want to enter tables, it only shows table 1 to table 7 without my table headers (or names).
How can I fix this?
Thanks,
Al.
Glad you liked it 🙏 I'm not a Power Automate expert either, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Extremely well done, i picked up the truncated link and it works perfectly...as always..being automated is showing me i need an assistant 🤔
Thanks, Larry! Power Automate is your assistant 😉
@@MyOnlineTrainingHub
Well played Mynda 👍
Thank you for the video, are you able to upload the power automate flow file and excel file for us to make a copy and try it out
I don't have the file to hand, sorry. It's only 5 columns and a few rows so should be quick to recreate. Then you can follow the steps in the written tutorial: www.myonlinetraininghub.com/automatically-email-reminders-from-excel-with-power-automate
Hi Mynda, really great tutorial. Is it possible to break the items pulled from the excel into the body of the email? They load in fine but are all cramped together. Is there a way to add breaks between items in the filter array to better list out the headers and values?
Also, is it possible to list multiple dates in the excel so that the emails could fire on certain assigned dates in the future?
Kind regards from Dublin, Brian
Glad it was helpful, Brian! I'm confident you can do the things you want, however I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thanks Mynda it’s a great tutorial. I used it and it worked for two flows without any issues. The third and fourth time I ran the flow it started sending emails and did not stop. Can you please help me resolve this issue.
Glad you were able to make use of these techniques, Umar. Not sure what the problem would be. You're best to post your question on the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Excellent! I have one question if we have one task and multiple email ids in one cell then how to run the flow
I don't have a tutorial on that. I recommend you post your question on the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you so much! extremely valuable video! only one important thing i felt missing is the output, could you please add the part to see how does the email looks like after running the query ? thank you!
I don't have the email or flow anymore, sorry. However, you can try it yourself and see.
@@MyOnlineTrainingHub I watched that video closely many times and followed the exact steps but from some reason it appears that the distinct list of emails doesn't work for me, the emails sends to all the address multiple times and i cant get it to work, i have no idea what am i doing wrong, please help me figure this out, my company relays on it and it will be so greatly appreciated , thanks in advance!!
Ive found the problem!! When i created the "send email" i inserted inside the subject a variable from the Excel table, (the automation sends seperate emails to each vendor and i wanted the subject of each email to contain the vendor's name in each email difrently) that process created aditional loop, so when i romoved the vendor's name from the subject the loop was romoved and now the distinct adresses are working, but i still need to find a solution to put the specefic vendor name in each emai withot creating aditional loop...
Excellent Tutorial. I created a flow for due date. How about the due hours ??? Please help me out. I’m not expert either that much good in power automate
Glad you found it helpful! I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Excellent video! Very easy to follow :) I would like to set a reminder both 30 days before and 14 days before the deadline. Would I need to create a second flow for this?
Thanks, Matt! I would think you can incorporate the two reminders in the one flow, but honestly, I'm not an expert in PowerAutomate, so I could be wrong.
@@MyOnlineTrainingHub Alright, thanks for the information! I'll try to look into it! :)
@@Matt-lc8qt Did you come across any solution on how to set a reminder both 30 days and 14days before deadline?
@@shahanshilashrestha2304 I have mine set up to send a reminder 7 days before the due date. What I did is make a column in my spreadsheet, i took the due date cell -7 days or 14 days, and then used that column instead of the Due Date column. I called it the reminder column. Hope that helps.
It's so important to follow the direction closely. I wasted 3 days because I missed "Click on the Text icon:" in the Select Step. I hate myself for this because I would have learned so much more in 3 days if I didn't miss this. Well, good thing is that I learned some other skills while trying to fix this.
On the up side, you will never forget that important step 😊
I think the feedback system was partially at fault. It kept telling me that something was wrong with the filter query at step 2. lol
Mynda, do you share or have you posted the Flow Package by any chance anywhere? As always, great content, EZ to follow and practical!
Thank you! No, I haven't posted anything on Flow.
Thank you so much for this! Is it possible for filter query eq the date and older? I want emails to continue to keep coming until the reminder date has been changed to a future.
My pleasure. I'm sure you can modify the flow to dates less than or equal to.
Hi. Great video! How can I change this so it sends an email on both current date and past due reminder dates?
Glad you liked it. Regarding modifying the flow, unfortunately I'm not a Power Automate expert. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Can I include a link in the generated email to a Microsoft form or other file like Excel that could allow me to prompt staff for further questions or information? Thank you for the helpful video, and whatever guidance you can provide 😊😊
Yes you can!
Hi, Thanks for the video, it is very helpful. I want to filter data from excel instead of equal to a specific date, I want to select a range of dates, please let me know if this applicable. thanks
Possibly, but I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you for this tutorial, it is very helpful. Could you please tell me if it's possible to send just one email for multiple entries from the table? Currently if there are multiple lines included in the table, it sends multiple email reminders. Thank you!
🤔My table has multiple entries for the same person and it only sends one email.
Thanks for this video, so easy to follow! I have one issue that I’m struggling to resolve: I’ve set up the flow and tested it on a sample group (10 people) which all works as planned, however when I use the flow for the full list (approx. 900) the flow seems to max out at around 32 emails. Any help would be appreciated! Thanks
So pleased it was helpful! Not sure about the limits. I wonder if it's your subscription with Microsoft that's limiting it. You might need to check your account settings.
Would a Delay help?
Thanks, this is great!
Could you please help me with a problem,
Whenever a new Excel file is placed in a SharePoint folder, I want to read its contents and send emails accordingly.
Each Excel file will have a different name, but the table design in it will be the same.
I'm not an expert in Power Automate. Best to seek help in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
cant wait to try, thank you!
Hope you enjoy!
Great tutorial! How would I change the distinct list part? I need a unique email sent for each row!
Thank, Sarah! I'm not a Power Automate expert, so you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you Mynda for this video! M flow ran successfully as shown in PA, but I didn't get the email notification. What could be wrong? I'd be grateful for your input
Great to hear you were able to get it partially working. Unfortunately, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
This is just what I was looking for! However I wish to know how to send the email to more than one email id for a single task
Glad it was useful. If you're stuck adding more than one email, post your question in the Power Automate Community forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
This is great! I am however running into a problem where I try to run a second filter based on another cell value, multiple emails get sent. Not sure if I'm misssing something obvious? Keep up the great work, thank you!
Glad you like it, Jeff. You might like to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Wow!! Thank you Mynda. I tried past week to create exactly the same with Power Automate, but I messed...
My pleasure, George!
Great video, would you happen to know rather than using eq, can I also get overdue items? (I.e. the ones that have passed the current date)
Thank you! Yes, from memory you can use gt and lt for greater than and less than.
Hi, thank you so much for this tutorial, it helped solved my problem. However, if i only want to send the email where those tasks that have 'Pending' status and ignore those that are 'Completed', how should i do?
Thanks in advance
Great question, however I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Very good thanks. Can you do the reminding not with a new email but somehow following the latest correspondance (using entryid or conversationid or something else)
Probably however, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
@@MyOnlineTrainingHub thanks
Amazing video! thanks for sharing. I got issues on the Date Format "formatDateTime(convertFromUtc(utcNow(),'E. Australia Standard Time'), 'MM-dd-yyyy')" how should I adjust for GMT 0 (West Africa)? Thank you!
You can find the name of your time zone here: bit.ly/3HdmIgF
Looks like it might be: W. Central Africa Standard Time
Excellent!!
Thanks, Philip!
Many thanks
You're welcome 😊
Thank you so much!!!
My pleasure 😊
Hi, I followed the instruction and I did find one error in the flow. I couldn't get it to work until I found the error, but otherwise thank you for putting together and helping me. I would like to know how you can set a rule or add a step in the flow to only send reminders for active tasks and not closed tasks
Glad you found it helpful. Regarding the active vs closed tasks, you're best to post your question in the Power Automate support forum as I'm not a Power Automate expert, sorry: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
So many cool use cases, thank you! For mine, I need to to show any data added in the last 7 days in the output tables say, not just due on todays date. How might I edit the Filter Query expression in the List Rows step? Any tips appreciated! edit: Similar to Gordon Price :)
Great to hear, Brett. Similar to what I said to Gordon, you're filtering for dates that are equal to today OR less than or equal to today -7 days. So it'll be something like:
ReminderDate/all (r: r eq 'formatDateTime(addDays(utcNow(),-7),'yyyy-MM-dd') or r le 'formatDateTime(utcNow(),'yyyy-MM-dd') )
That might need some tweaking as I'm not expert on ODATA functions. You can find out more here: docs.microsoft.com/en-us/azure/search/search-query-odata-logical-operators
@@MyOnlineTrainingHub thanks so much ! Amazing !
Thank you for the video! Can I have multiple email addresses in one excel cell and send to all those address one email asking for input "participant names" for a "meeting" ?
In may case each meeting will be one row hence needing to have in the "email" cell multiple email addresses.
It's not ideal to store multiple records in a single cell. Maybe if they're separated by a delimiter, you can use them, but you'd have to ask your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
I am getting only 4 email out of 9 emails...please help me how I can complete unique emails
Hmm, that's odd. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Excellent tutorial! I would be curious though if there is a way for it to only send the email for a task once (i.e. such as a week before the due date, instead of every day leading up to it)? Also, what happens if you don't remove tasks from the list? Does it only pull from tasks that are after the current date?
Thanks, Christopher! With the method I've shown it will only send it once, on the 'reminder date'. The process runs every day to pick up any new tasks that have a reminder date of today. If you don't remove tasks from the list it won't matter as it filters the list to display only those tasks that have a reminder date of today using the utcNow function.
@@MyOnlineTrainingHub Oh duh! I totally forgot you had a separate reminder date column *face palm* That makes so much sense. I apologize for the silly question! Keep up the great work.
Thank you for your video. I have a small employee chart and we are trying to generate email reminders, but I keep getting this error "There is an unterminated string literal at position 24 in 'REMINDER eq ' 2023-09-28'. inner exception: There is an unterminated string literal at position 24 in 'REMINDER eq ' 2023-09-28'. clientRequestId: cd39f8fb-9753-40a2-9b9e-7eeffc69f53a" It would be a wonderful thing if it works for me.
This error usually means you haven't entered a closing parenthesis or curly brace etc. i.e. you haven't closed the expression.
This is exactly what I was looking for. I tried to duplicate this since I have a similar task at my work, and I found that in the filter array control, when I add the parameters, I see you did from "Value" and the filter query "email is equal to current item". For me, the from is only showing body/value instead of just value and because of this, the flow is skipping every step because of this. Is there a way to fix it? Power automate doesnt seem to add a separate value expression, it just adds body/value together.
I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
I am having the same thing, did you find any solution?
@@sabbirahmed2657 Not yet, let me know if you find a solution.
Base on your video, i can see the column header called "Email". May i know if this is sender email address or recipient email address? If this is for recipient email address purpose, can i put more than 1 recipient address at the same time? if it's allowable, should i just use "Comma" as separator in the same excel row cell?
It's the recipient. If you want multiple recipients, put them on separate rows.
Excellent video. However, I am unable to see "value" in the list of items. Hence flow after "Apply to each" is getting skipped. Please let me know how i can correct here. Really appreciate your response.
Not sure what's gone wrong for you there. I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you for this. In filter array, the option to select current item doesnt come up. Ive followed all steps.
Strange 🤔 I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi, Thank you very mush for the explanation. I have been searching for this type of flow and could not fine one till now. It work on the file and Table I have now. But it is sending email of every status I have. Need your help and suggestion. How do I trigger email based on only two conditions using And Condition.
Glad you found the video helpful. Regarding your question, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thank you for this tutorial. I would be happy if you could assist me in a simple task. I would like to send an Email to myself several times every day to remind me of several task I must do on a daily basis is this possible. The tasks are listed in the excel sheet along with their times and I would like to get an email at the beginning of every task
Thx
Glad you found Power Automate helpful. I'm not a Power Automate expert, so you're best to post your question on the Power Automate community forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi Mynda,
Can I includes other emails in the reminder?
Thanks
Not sure what you mean by 'other'.
@@MyOnlineTrainingHub I mean can we sent the reminder besides ourselves to any others person.
Hello, it is great video! however I would love to find how to add CC email from the table
Glad you liked it 🙏 In regards to adding a CC address, you’re best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thanks, Mynda, for the helpful flow. I am able to run the flow without errors and receive email, but the email content only shows the column headers mentioned in the HTML Table creation step ... there are no values showing up under the column headers. Please help.
Glad you liked it. Please post your question in the Power Automate support forum where someone can help you troubleshoot: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hai nice work by the way, i have a question about filter query. Can i make query that RemainderDate equivalent to today date also after date. Because i wanna keep emailing the remainder task everyday even the date is due. Thanks
Yes you can. If you get stuck, you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
@@MyOnlineTrainingHub can you help me with the queries? or method that i can use?
Is there a way of having the emails generate and pop up on our screen before sending? We often have attachments - that cant be autoattached or we have clients that need an email that covers multiple co-insurer invoices so being able to do a quick tinker to the email on those specific cases would be ideal. thoughts on this?
Probably. However, I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
@@MyOnlineTrainingHub Hey again! So i am trying to replicate this minus the time schedule but when i get to the 2nd step with the Select field i do not have an option to say Value. Any ideas on this? Could it be how i have set up my excel document/table?
Thank you so much in advance!
hi excellent video... can u please let me know how to create table border in the final result... i will be obliged
I'd love to but I'm not a Power Automate expert, sorry. You're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
@@MyOnlineTrainingHub no issue... i just figured it out
Will try once I get to work
Awesome! Hope it's useful 😊
Thanks 😊
Welcome 😊
Hi,
would this work for simple reminders for productivity rates for individual employees? If I have an excel spreadsheet for the productivity rates of employees ( 30days, 60days, 6month with the company ect.) Could I set up my excel to send email reminders to the office personnel regarding those milestone dates?
I'm sure you can. If you get stuck, you're best to post your question in the Power Automate support forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity