Unanswered

String was not recognized as a valid DateTime. Creating query failed

(0) Share

Report

Posted on by mclim

I am following https://www.youtube.com/watch?v=g_SqkW9ZCR0&t=199s which is very straightforward but I am getting error message found in title.

Screenshot 2023-04-28 at 12.57.46 PM.png

I have double checked the spelling of the variable OpenDate. I am not sure why it is throwing the error? Thanks.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

mclim 53 on at

Like (0)

Report

This is OpenDate as screenshot from the the List.

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @mclim

You need to format the date column using the below expression:

expression used for formatting date is mentioned below:
formatDateTime(utcNow(),'yyyy-MM-dd')
assuming, OpenDate stores only date but does hold time.

Pls let me know if you face any problem & remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
mclim 53 on at

Like (0)

Report

@ManishSolanki , in the youtube video screenshot, it uses 'MM/dd/yyyy' which is the US regional date format. So it works without your format of 'yyyy-MM-dd' . But I'm in Malaysia which uses 'dd/MM/yyyy'. And as I have pointed out in the first reply, the format is also 'dd/MM/yyyy'. Thank you.

Was this reply helpful? Yes No
v-peijunz-msft Microsoft Employee on at

Like (0)

Report

Hi @mclim

Could you please show the error message you received in the Get items in detail?

Based on your description, I have made a simple test for your reference.
1. I have a Date and time column with the date showing here:
Here is the flow:
After running the flow, it got the result here:

But when I use the wrong internal column name in SharePoint list, I got the error message "BadRequest.":
So I guess the possible reason that you get the error may be the wrong internal column name for your Open Date column used in the filter query.

Please check the correct internal column name by going to your SharePoint list > Settings >List Settings > Choosing the Open Date column, and the correct name format is showed in the last part of the URL:

Hope it helps.

Best regards,
Sylvia

Was this reply helpful? Yes No
mclim 53 on at

Like (0)

Report

@v-peijunz-msft , I received a bad request as shown in my first screenshot. However, the error message is different from yours. I attach a screenshot showing the 'Open Date' . My error message is "String was not recognized as a valid DateTime". However, in Settings column, I confirm it's a 'Date' only.

Please let me know if you have other suggestions. Thank you!

Screenshot 2023-0...

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @mclim

It does not matter to which location you belong because internally SharePoint store the date in UCT format, please try the below expression:
formatDateTime(utcNow(),'yyyy-MM-dd')
or you may directly put date in format (yyyy-MM-dd) i.e '2023-04-28' and check the flow result.

Thanks
Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No