Answered

How do I fix the DateTime string in my flow?

(1) Share

Report

Posted on by LB-20090315-0

Hello,

I've been trying all the troubleshooting suggested here on the Microsoft community to fix my problem but nothing is working. If anyone could take a look at what I've done and figure out what's wrong I'd be really grateful.

Every time I run my flow I receive this message:

The error indicates that the flow failed because the date string being used in the filter query is not recognized as a valid DateTime. This issue is likely caused by the format of the date being passed in the filter query, which may not match the expected format for SharePoint. To resolve this, have you considered ensuring that the date string is formatted correctly before using it in the filter query?

This is the variable:

dateDifference(convertFromUtc('2018-01-01T08:00:00.0000000Z', 'AUS Eastern Standard Time'), addDays(convertFromUtc('2018-01-01T08:00:00.0000000Z', 'AUS Eastern Standard Time'), 7))

This is the Get Items action that is failing:

And this is the column "field_7" that it is trying to read for "eq":

Thank you

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Sort by

CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Mate,

Format the date string to ISO 8601 before using it in the filter query.

Try the following, Add a Compose and use the Formula

'formatDateTime(yourDate, 'yyyy-MM-ddTHH:mm:ssZ')

Then past the output of the Compose to Filter.

field_7 eq '<Compose>'

Was this reply helpful? Yes No
Suggested answer

CU15102032-0 10 on at

Like
a
(0)

Report
Copy link

Link copied!

It seems like you're using Due Date in a variable. Check is that variable a string?

Was this reply helpful? Yes No
LB-20090315-0 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thank you for the suggestions.

The Due Date variable is a string.

I attempted to add a compose but it would not accept formatDateTime(yourDate, 'yyyy-MM-ddTHH:mm:ssZ') as a valid formula. I assume I'm supposed to change yourDate but I don't know what to change it to.

Kind Regards,

Lauren

Was this reply helpful? Yes No
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Mate,

You need to replace yourDate with 'Due Date'

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
David_MA 14,864 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The expression you are using is going to return a string representing days,hours:minutes:seconds (in your example, 7.00:00:00). You are trying to use a query filter where one date equals another date. Since your expression returns a string and not a date, this is the cause of your error. Since I don't know what you are trying to do, I cannot help you fix it, only give you the reason it does not work.

To use equals in a query filter, the two sides of the filter must use the same data type (number to number, date to date, string to string, etc.). And when filtering on dates, both dates must be formatted using the ISO 8601 date format (yyyy-MM-dd). If the screen shot of field7 is from a SharePoint list, that will be stored in SharePoint in that format even though it displays in the list differently.

Was this reply helpful? Yes No
Verified answer

LB-20090315-0 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

It's always the simplest thing. Turns out I was using the wrong function. I've changed it to the correct one now and it's working fine. Thank you all so much for your help!

Was this reply helpful? Yes No