Unable to add date to SharePoint list date column

(0) Share

Report

Posted on by Akuner

Hi All

Would anyone please advise me on the error below:

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Cargo_x0020_Ready_x0020_Date' is required to be of type 'String/date'. The runtime value '"30-06-2020"' to be converted doesn't have the expected format 'String/date'.

I am trying to get the date value from excel and write it to SharePoint list.

I have a few issues:

Get table row is returning the value in numbers, even though I have used ISO format as date and time. Strange enough, some date columns from excel is returning date and time values.
I have used below expression to write into the list. No luck.
if(empty(outputs('Compose')?['Cargo Ready Date']),null,addDays('1899-12-30', int(outputs('Compose')?['Cargo Ready Date']),'dd-MM-yyyy'))

Thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

SueB Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Akuner
Have you looked at Norm Young's guide on importing Excel data to SharePoint? There is a segment on handling dates that is helpful. Here are screenshots of that section.
I hope this helps! 🙂

Thank you for using Microsoft Power Platform Communities!
Sue
Support Engineer
Microsoft Power Platform

If this post helps, then please consider accepting it as the solution to help other members find it more quickly! Have a great day!

Was this reply helpful? Yes No
Verified answer

Akuner 19 on at

Like (0)

Report
Copy link

Link copied!

Hi @SueB
Thank you for your reply. It seems to be the date format issue. The correct date format for me is yyyy-MM-dd instead of dd-MM-yyyy.

Was this reply helpful? Yes No