You’re offline. This is a read only version of the page.
Announcements
2
Hi there,
Thank you for your help in advance.
I have created a flow for updating a list on SharePoint from Excel. I am having an issue with the date bit.
The error that appears is :
OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/LastReviewDate' is required to be of type 'String/date'. The runtime value '"44682"' to be converted doesn't have the expected format 'String/date'.
The date in the excel file
Hello @MissDelafuente ,
Excel can return dates in two formats:
1. serial number starting from 1.1.1900
2. ISO date
Only the ISO dates can be updated into SharePoint. Go into the advanced settings of the 'List rows present in a table' action and select to return the date as 'ISO 8601' date.
Share
Report
All responses (
Answers (
