web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Runtime value to be co...
Power Automate
Unanswered

Runtime value to be converted doesn't have the expected format 'String/date'- trying to move a date from Excel to Sharepoint List

(1) ShareShare
ReportReport
Posted on by 17

Hello!

 

I'm running into this issue in my Flow- Error details: Input parameter 'item/First_x0020_Steps_x0020_Due_x002' is required to be of type 'String/date'. The runtime value '"44137"' to be converted doesn't have the expected format 'String/date'.

 

Here is what I'm trying to do- create a flow that takes rows on the Excel spreadsheet and enter them (if they don't already exist) to a Sharepoint List.  Here's what the spreadsheet looks like-  I would manually enter Columns A-E and all the due dates are calculated based on a formula that subtracts days from Column C.

 
 

Excel Sheet.jpg

 

My flow works with Columns A-E, but it fails on the calculated date columns-  here's what that section looks like with the Error message- Flow Details.jpg

 

 

 

(In a separate flow, I'm using this Sharepoint List to create Tasks in Planner with Due Dates- so the dates are critical.)  

Categories:
I have the same question (0)
  • Pablo Carceller Profile Picture
    Microsoft Employee on at

    Hello,

     

    Please can you check the type of column on excel of all the columns, may you have a issue with the format.

    Also, please can you share the operations you are doing with the columns.

     

    Thank you, Pablo.

     

     

     

  • LaurenLong Profile Picture
    17 on at

    See below!  I have simple formulas and the cells are formatted as dates.   

     

    LaurenLong_1-1598883855072.png

     

    Here is the format type for the date-

    LaurenLong_2-1598886353650.png

     

     

  • Pablo Carceller Profile Picture
    Microsoft Employee on at

    Hello @LaurenLong 

     

    May you can  do a test initialize variable and use this dynamics content on this fields

     

     

    variable.png

     

    once you know the type of data you can use the formulas to change the format

     

    https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#conversion-functions

     

    Hope this can help!

  • LaurenLong Profile Picture
    17 on at

    Thank you!  I still haven't been able to get it working- but that's definitely due to my lack of knowledge and time to research right now.  

     

    I did find this on Youtube that gave me a greater understanding of how dates work between Excel and Flow- hope it can help someone in the future!

     

    https://www.youtube.com/watch?v=X6Sn0RZNfyA&t=0s

  • JQuast Profile Picture
    14 on at

    Hello,

     

    I recently got this error in Power Automate and after below changes I was now able to update date field from Power Automate. 

    Giving error:

    string(formatDateTime(utcNow(), 'dd-MM-yyyy'))
     
    Fixed:
    string(formatDateTime(utcNow(), 'MM-dd-yyyy'))
     
  • JQuast Profile Picture
    14 on at

    Edit to above post, you do not need the String

     

    Giving error trying to update an item date field by PowerAutomate:

    formatDateTime(utcNow(), 'dd-MM-yyyy')
     
    Fixed:
    formatDateTime(utcNow(), 'MM-dd-yyyy')
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @LaurenLong that video just saved my day 😊 THX

    /Frank

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 605

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard