Answered

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

Like (0) Share

Report

Posted on 28 Apr 2023 05:09:56 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.

All responses (6)

Answers (1)

Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on 28 Apr 2023 at 07:08:51

Like (0)

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

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.
mclim 53 on 28 Apr 2023 at 06:57:22

Like (0)

Report

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

@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...
v-peijunz-msft Microsoft Employee on 28 Apr 2023 at 06:13:04

Like (0)

Report

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

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
mclim 53 on 28 Apr 2023 at 05:43:57

Like (0)

Report

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

@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.
ManishSolanki 15,085 Super User 2025 Season 1 on 28 Apr 2023 at 05:35:01

Like (0)

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

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
mclim 53 on 28 Apr 2023 at 05:34:12

Like (0)

Report

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

This is OpenDate as screenshot from the the List.