web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Get error: "String was...

Power Apps

Answered

Get error: "String was not recognized as a valid DateTime".

(1) Share

Report

Report

Posted on by CU16021406-1

1,066

Hi,

What I have made is a flow that first gets today's date and then searches in the SharePoint-list column "Datum" for that exact date.
And if date is a match then get the value of the column "Between" of that day.

But i get an error:

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

P.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @CU16021406-1,

Error usually occurs because the date format in the Power Automate filter query does not match the format expected by the SharePoint Date column. Please change the date format to 'yyyy-MM-dd'. It will work.

Datum eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'

Expects the date in yyyy-MM-dd, so using this format should resolve the issue.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No

Join the conversation