OpenApiOperationParameterTypeConversionFailed

Hello,

I have a flow created to track feedback for a specific team here, one of the fields we had on the MS Form was "When was the error made" but after discussions we removed it from the form and the MS list the automation is feeding into.

I kept getting the following error randomly

OpenApiOperationParameterTypeConversionFailed

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

So I created a brand new flow, it worked for a bit but after the weekend that error is back.

So I added a new hidden column on the Microsoft List with the same name, but that doesnt seem to be fixing the issue.

This is the flow

And this is the Raw Inputs for the Create item

The ""item/WhenwastheErrorMade": ""," was deleted from the list, then I re-added it, but its showing as ""item/WhenwastheErrorMade0": "","

Any idea how I can fix this?

{
 "host": {
 "connectionReferenceName": "shared_sharepointonline",
 "operationId": "PostItem"
 },
 "parameters": {
 "dataset": "https://X.sharepoint.com/sites/X",
 "table": "19118760-0a6e-430e-9458-7b0440c69554",
 "item/Title": "Feedback",
 "item/FeedbackStatus/Value": "New",
 "item/CriticalError": "",
 "item/Test/Claims": "email",
 "item/AgentName": "Name",
 "item/FerryRoute/Value": "No Route",
 "item/BookingNumber": "",
 "item/WhenwastheErrorMade": "",
 "item/ReasonforFeedback/Value": "Kudos",
 "item/PositiveFeedback": "Test",
 "item/ProcessImprovementIdea": "",
 "item/KnowledgebaseUpdateRequest": "",
 "item/DocumentationError_x0028_F9Notes/Value": "",
 "item/DetailtheDocumentationError": "",
 "item/InformationProvidedError/Value": "",
 "item/Detailtheincorrectinformationpro": "",
 "item/Refund_x002f_PaymentError/Value": "",
 "item/BookingError/Value": "",
 "item/Detailthebookingerror": "",
 "item/Missing_x002f_IncorrectBookingIn/Value": "",
 "item/Detailthemissing_x002f_incorrect": "",
 "item/ReasonNotListedAbove": "",
 "item/WasAPriceAdjustmentRequiredtoCor/Value": "",
 "item/Whatwasthedollaramountoftheadjus": "",
 "item/Whodiscovered_x002f_reportedthee/Value": "",
 "item/Anyadditionalnotesabouttheerror": "",
 "item/WhenwastheErrorMade0": "ignore"
 }
}

The

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate