Answered

Flow Error on Date String

(0) Share

Report

Posted on by JG-25101045-0

Hi All

I am really looking for some help, I am very new to using Power Automate, Lists, Forms etc. And everything I have learned has been off google or youtube.

I have created a list and flow, that all works. But I have 133 forms already completed that did not go through the flow and I want them to be added to the same list.

I have created a flow doing:

- Manually Trigger Flow

- List rows present in a table

Then connected everything through, the flow works but doesn't like the field for the dates, and that's a really important part of the information. It comes up with this message:

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/LEAVINGDATE' is required to be of type 'String/date'. The runtime value '"45359"' to be converted doesn't have the expected format 'String/date'.

I have tried changing the format in excel and on the list to custom, text, date etc. But nothing seems to be working.

What am I doing wrong :(

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

ran_dale 71 on at

Like (1)

Report

Hi @ JG-25101045-0

you need to format the data with the build-in function "formatdatetime".

This could look like this:

formatDateTime('<dynamic-value>', 'dd/MM/yyyy hh:mm tt')

More about the function:

https://learn.microsoft.com/en-us/power-automate/date-time-values

Hope this helps!

~Dale

Was this reply helpful? Yes No
JG-25101045-0 8 on at

Like (0)

Report

Hi @ran_dale

Thank you for responding.

Don't suppose you know how I would go about doing that?

Gave it a go, but like I said, very new and don't really understand all the actions within PA.

Thanks

Jackie

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (1)

Report

Looks like this date is comming from Excel ?!

If so, just check the connectors advanced options an set the datetime format to ISO-8601

Was this reply helpful? Yes No
ran_dale 71 on at

Like (0)

Report

Hi @JG-25101045-0,

Can you send me a screenshot of the flow? Then I can help you with your example.

Was this reply helpful? Yes No
JG-25101045-0 8 on at

Like (0)

Report

Hi @ ran_dale

Hope this helps.

Thanks

Jackie

Was this reply helpful? Yes No
JG-25101045-0 8 on at

Like (0)

Report

Hi @Chriddle

It is coming from excel.

Not sure how to do what you've asked, looked in CONNECTORS under DATA and there was nothing there.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,443 Super User 2025 Season 2 on at

Like (2)

Report

Click "Show advanced options", then select "ISO 8601"

Was this reply helpful? Yes No
Suggested answer

CU15102006-0 2 on at

Like (0)

Report

I finally found a really helpful walkthrough by Michael Alex on Youtube called "Potential Issues with Importing Excel Date Data Fields in Power Automate with Solutions - Tutorial" that walked me through how to write the expression.

https://www.youtube.com/watch?v=oIFwnE3W6pg

Was this reply helpful? Yes No