Unanswered

Date Format Error

(0) Share

Report

Posted on by KL-14051439-0

Hi I am running into this error when I am updating my Sharepoint list from excel. This is the error I am receiving:
OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item_Jess' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_13' is required to be of type 'String/date-time'. The runtime value '"45785"' to be converted doesn't have the expected format 'String/date-time'.

The Flow was working until yesterday and I do have ISO 8601 selected in the List Rows Present in Table step.
Any advice would help thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@KL-14051439-0 When working with Dates in Excel, you must select ISO 8601 as the DateTime Format. If you don't do this, your date will return in serial date format which will cause your flow to fail.

You might also be interested in this YT Tutorial:

How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate. I’ll cover some common use cases and concepts that can help you to build better Power Automate flows.

Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

IN THIS VIDEO:
✓ 4 Date Functions You Need to Know
✓ How to use the Convert Time Zone Action
✓ How to Get a Future Date
✓ How to Get a Past Date
✓ How to Return SharePoint Items Due in a Number of Days
✓ How to Return SharePoint Items Due within a Date Range
✓ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days
✓ How to Calculate the Number of Days between Two Dates
✓ How to Check for a Birthdate and Anniversary Date
✓ How to work with Dates and Times in Excel
✓ How to use a Manual Trigger with Date Input
✓ How to Output Dynamic Text with an Expression
✓ How to Check if a Date Falls on a Weekend

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
KL-14051439-0 2 on at

Like (0)

Report

@creativeopinion I have ISO 8601 enabled. The first set of dates come through no problem; it's one specific column of dates that is giving the error.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@KL-14051439-0 It's hard to offer any specific recommendations without seeing your full flow and the logic behind it. If you are using the new designer, toggle it off and click each action to expand it. Upload a screenshot of your flow in edit mode.

In the meantime, you might also be interested in this YT Tutorial:

Fix Your Flows: 5 Power Automate Errors Explained with Solutions

In this tutorial, I’ll cover 5 common flow errors and how to fix them.
1️⃣ Creating a filter query failed
2️⃣ formatDateTime() function requires first parameter to be a string—got Null
3️⃣ formatDateTime() function string must match ISO 8601
4️⃣ Mis-match value types when comparing
5️⃣ Value Cannot be Converted to the Target Type

IN THIS VIDEO:
✓ How to fix common Power Automate errors that cause flows to fail
✓ Best practices for writing filter queries in SharePoint and Excel
✓ How to convert string to integer and decimal correctly using expressions
✓ The difference between int(), float(), and formatNumber() functions
✓ How to handle missing or null values in filter conditions
✓ Why formatDateTime fails—and how to pass a valid ISO 8601 value
✓ Preventing unnecessary flow runs with Terminate actions
✓ Pro tips for formatting and calculating values in Compose actions
✓ How to identify value types and debug expression issues fast

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No