Share
ReportHello,
I have a power automate flow that runs on a recurrence (every 3 hours). It goes out to a series of Excel files, checks if there are any new items added to them, then if so exports the data to SharePoint list. The issue I am having is that I am getting a failure at my SharePoint "create item step when trying to create a date.
"OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/SubmittedDate' is required to be of type 'String/date'. The runtime value '"45628"' to be converted doesn't have the expected format 'String/date'."
I am only getting this error with one of my 5 files that I am cycling through. The users inputting the data are located in Japan (not sure if this has any effect on the error). I have watched user input the data and it is no different from how I enter the data in the US. All 5 of the excel files started as exact copies.
If I try to resubmit the failed run, it will fail again. Any ideas on how I can resolve this error? From the Excel side, everything looks correct. I cannot figure out why I am getting this error only with one version of the file.
Thank you!
Categories:
All responses (
Answers (
3,490
