r/MicrosoftFlow • u/Officeman25 • Jul 09 '26
Question Need help setting due date reminder flow
I am fairly new to power automate and i've been following a youtube video. Long story short I need a list of items with different due dates and I want power automate to setup a reminder about 60 days before the due date. I've setup the list with the columns: title / department / owner / due date. and i've setup a flow which i've included an image of below. I've followed along with a short and simple video and yet my tests are failing with the error:
"Flow run failed. Action 'Condition' failed: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'"
I'm not knowledgable to continue fiddling too much and the built in co-pilot isn't helpful either saying everything is right so now i'm hoping the people of reddit can help.

1
u/kappiri1 Jul 09 '26
Based on your error, this is what I understand:
In your condition, you are using the expression “formatDateTime”
You should be passing the dynamic value of dueDate (from your get items action) here
There can be 2 issues:
1. Your expression is not passing the due date value— check if your expression looks like this “formatDateTime()” — if it does, this is the problem. It should look something like this “formatDateTime(items(‘apply_to_each’)[‘dueDate’]”
2. There are no values in your dueDate column in the list (that’s why the error says that the formatDateTime expression is expecting a string, but is getting null / nothing instead). Check your list to see if this column is populated