Email confimation based off tomorrows date from excel

[joshspeg]

Looking for a bit of help. I was able to make the flow work with the conditions of utcNow('yyyy-MM-dd') is equal to the date in my excel document. But I am trying to have this send the day prior to the scheduled date to confirm the inspection. I tried 

formatDateTime(addDays(utcNow(),1),'yyyy-mm-dd') is equal to date in the excel document but that didn't work.

Screenshot below. Thanks for your help.

[efialttes · Accepted solution]

Hi!

Your excel column is of type text not date, right? If so, I would try with

formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd') 

Double M with capital letters

Hope this helps

[joshspeg · Accepted solution]

I can't believe thats all it was.

Thank you for the help.

Josh

[joshspeg]

To be clear is was making the mm capital MM. I had the text not date correct.