Automate Emailing Excel Task Reminders with ZERO Coding! 

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?

Thanks, was searching for this. Got Office Prof but not business 365, so will need to wait for that I guess.

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.

Mam I complete my flow but after test the flow means its came on Bad Request Error in list rows present in a table session what im do ? 😢

Hiii mynda how are you

Hi Mynda, the Time Zones names link doesn’t open, showing an error

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.

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

I am getting only 4 email out of 9 emails...please help me how I can complete unique emails

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?

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?

This is the output that is being generated by the UTCNOW function when the parameter is 'India Standard time'. And since the logic is not satisfied there is no list of values. can you please help me out on this?

Love your stuff but would argue the zero code description. You need to know some fairly complex syntax to get this working and imho, if there’s syntax involved then it’s code. Low code but code nonetheless and therefore not zero.

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.

test was succeeded but i didn't receive any email how to solve ActionConditionFailed The execution of template action 'Filter_array' is skipped: there are no items to repeat.

its good but landy process

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

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

hi, there is a error in my excel.Time format wasn't correct Im in Sri lanka.Could you pls send me the correct code for this ? Error Action 'List_rows_present_in_a_table' failed Error Details Unable to process template language expressions in action 'List_rows_present_in_a_table' inputs at line '0' and column '0': 'In the template language function 'convertFromUtc', the value provided for the time zone id 'E. Australia Standrad Time' was not valid. '.

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!!

Great tetorial mem I love you so much

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!

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!

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

Very Informative

Hai Excellent explanation and easy to understand .. i have followed ur instruction when i execute it ,im getting bellow error mesage , could u please do support me for rectifying it? Syntax error at position 31 in 'IntroductionDate eq'2023-09-07''. inner exception: Syntax error at position 31 in 'IntroductionDate eq'2023-09-07''.

Great tutorial, but the flow does not work for me :( It keeps adding 'For Each' action to operations when I want to take data from excel.. Spend whole day on it and cannot figure it out..

Great tutorial. But for some reason I was not successful, even though the flow ran successfully. I get "ActionConditionFailed. The execution of template action 'Filter_array' is skipped: there are no items to repeat." at "Filter array" process step. Can you please help what is going wrong here.

how can we setup a RAG using this format?

Hello, I'am trying to figure it out, how it works. Fortunately there have been some updates concerning to Power automate. So I can't let it work for me. Is it possible that there is update about this video. It would be nice, if it works. Tank you in advance.

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.

Thanks Mynda.... I am getting error in Send an email (V2) option. Dynamic content option is missing in To.... Please suggest

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?? :(

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.

Does anyone know how trigger a date in a given row before the actual date? For example, the date in "ReminderDate" is 4/29,but i want to send me the reminder on 4/27.

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! 🤩😘🥰

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

Thanks for sharing! Anyone expert in Power Automate who can help me on refining this process, 1. distinct cc recipients, 2. put commas in a number in the HTML table? Willing to hire someone. Thank you!

Abysmal. Did not work. Thanks for wasting an hour of my time. "Flow Save failed with code .......' Followed this twice now - same result each time.

I tried but got the following error in filter array section, would you please help? ActionConditionFailed The execution of template action 'Filter_array' is skipped: there are no items to repeat.

Hi, I have been trying this but my filter array shows 'Action condition Failed', what I can do to solve this?

I'm having issues with getting rows from my Table... And its stopping on first step... its bit confusing...

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, I am a complete begginer here, I am trying to generate emails from expiry dates in an excel workbook. I have arrived at the filter query and am unsue what to put in here. I have a column titled reminder date. Can you help?

My test flow can be run but ActionConditionFailed The execution of template action 'Filter_array' is skipped: there are no items to repeat.

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?

I tried doing it 2-3 times my program is showing successful after that when i check the program like you showed at 12:07 my data is empty. Please advise how to resolve this problem

Hi. Im getting an error Syntax error at position 11 in 'PO CREATION DATE eq 2023-08-24T00:00:00.0000000'. inner exception: Syntax error at position 11 in 'PO CREATION DATE eq 2023-08-24T00:00:00.0000000'. clientRequestId: c4139616-6c99-4575-83d4-44e65277c05c Kindly need your help

when I add create html table, it will sepreate to apply to each 2 and equired me to select an output from previvous steps. also, when I choose send an email body, could not find create html table-output, could you help on it?

While testing the flow wad successful. But the concern mail ID couldn't receive any mail response. Please help me in this.

Thank you for your explanation! But i received an error says "only work accounts supported in excel online connector" so i couldn't upload the file I can't use my personal email?

I have big question can u software for werhose rent collect software I need reminder for get payment both side Reminder for my email and his email

Hello! Super basic question but when I select a table and try to select the row value it only says Table1 no matter what I do, the data of course is formatted as a table and everything but Power Automate wont recognize the header of any row

hello i am getting this error message : Échec de l’enregistrement du flux avec le code « InvalidTemplate » et le message « The template validation failed: 'The inputs of template action 'Envoyer_un_e-mail_(V2)' at line '1 and column '3372' is invalid. Action 'Appliquer_à_chacun' must be a parent 'foreach' scope of action 'Envoyer_un_e-mail_(V2)' to be referenced by 'repeatItems' or 'items' functions.'. ». can you please help and guide me how to correct ? many thanks

Hi, i followed all the steps in your video however there is an error saying that "invalid Filter clause ; cannot find the column" What will i do?

I have followed this step by step, it all works until I get to filter array. I get the message filter array is skipped, there are no items to repeat. Any ideas please?

Thank you for this. In filter array, the option to select current item doesnt come up. Ive followed all steps.

I have been sending bulk emails and after sometime we have to do a follow up how can we use this function in that VBA sheet. Curious for the comment

hi. Flow Ran successfully but not works . no data in input and output. Dont know what is the problem there. can you please help me

Sadly, it didn't work for me. The test went thru okay, but I never received any email reminders.

How to get the output from 'select'?

Hi , i have been tryin it since long time but my inputs and output r blank . and i dont even receive the emails though it says flow ran successfully. please help

😭powerautomate is just not able to perform some steps, I have a table where I split it to sheets based on depts, but group filtering is not alwazs done correctly

I followed all steps and in testing phase when flow works it sends individual mail for each row, how can i send just one mail with all filtered criteria in mail body?

Hi Mam i Got the Below Error Why ,Please Explain "Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Send_an_email_notification_(V3)' at line '1 and column '3115' is invalid. Action 'Apply_to_each_2' must be a parent 'foreach' scope of action 'Send_an_email_notification_(V3)' to be referenced by 'repeatItems' or 'items' functions.'.'."

all seemed to be going so well and then i got this message in the final step. anybody know what this means:- Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Send_an_email_(V2)' at line '1 and column '3504' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Send_an_email_(V2)' to be referenced by 'repeatItems' or 'items' functions.'.'.

When I go to Select, Email isn't there. So frustrating. Any thoughts?

do you need premium version of power automate to access the scheduled cloud flow. I am not finding it in basic

if 4 rows have the same data in the columns mail and the same date, then it receives 4 mails separately instead of one collective. and the operation is repeated 4 times. How can I change it to get 1 cumulative?

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 😊

Can someone help me, i've tried to use this to make but it goes through the filter query but doesn't proceed to the next steps, even though i've manipulated the dataset to include a dummy date that matches today's date

Hi could pls help after the recurrence- the next row list rrows im getting error showing invalid filter clause. Pls help me

Great job, as always, Mynda. I just recorded a video demonstrating how your use case can be handled using my Visual CUT software: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-T72SbTQLUQI.html

The flow seems to br fine but i want names want to send individual names..like hi micheal..hi sandra..in the emails can you please help with this

Hi I need something far simpler, but can't figure it out. I have a large database where one column is a follow up date for that row. I would like to just send ONE email, to one person (CC'd to another) to follow up when the follow up date is today. I keep getting date format errors.

Hi I am getting Error as below can you please quide me ActionConditionFailed The execution of template action 'Filter_array' is skipped: there are no items to repeat.

I don't like this method. I hate using the mouse navigating from this to that. I'd prefer to use vba.

I created exactly same table you have and followed step by step but I can’t get it works. It gave me error 😢.. i did not see " Value" option only see "Body/value". Also, cannot fine the " Current item" too 😢😢..I must do something wrong

Would it work with for example sending message on teams chat ?

How can I assign task to multiple users through list and make any type of FLow

On my list rows present in a table show error badrequesf when i test it, how can i solve it?

I am getting the email but i am just getting html Headers and I am not getting the data inside the table

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?

Thank you. I had to watch it twice to understand what was happening. Can't wait to try this out.

on 5:07 what is standard time Indonesia.?

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

Can we use same in lower version of Excel example office 2013

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)

Nice explanation, however I am getting error at run, on format date

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

is it free? will it cost me anything if i sign in through my company email?

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.

What if I want to send an email with attachments for each person according to the list

Very nice, it would be cool to set this up to setup takes in Planner and allow recurring events

Is not working! Is so confuse with business account.

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.

somehow im not getting the "current item" option at the "filter array" step, what could be the reason?, thanks.

I find the step by step instruction extremely helpful. However, it says "test failed". How can I find what what the exact error message is? Thank you!

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?

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.