Skip to main content

Notifications

Power Automate - Building Flows
Answered

Unable to add date to SharePoint list date column

(0) ShareShare
ReportReport
Posted on by 19

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:

  1. 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.
  2. 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
     

 

 

 

 

  • Verified answer
    Akuner Profile Picture
    Akuner 19 on at
    Re: Unable to add date to SharePoint list date column

    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.

     

  • SueB Profile Picture
    SueB on at
    Re: Unable to add date to SharePoint list date column

    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! 🙂

    Excel2SPDates1.png

    Excel2SPDates1a.png

    Excel2SPDates2.png

     

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard