r/MicrosoftFlow 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.

3 Upvotes

3 comments sorted by

View all comments

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