Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

String/date-time issue - The runtime value '""' to be converted doesn't have the expected format 'String/date'.

(0) ShareShare
ReportReport
Posted on by 28

I have been trying to figure this one out for weeks and can not find a solution. I hope someone can help. The goal is to add the missing dates (if they exist) for that record already in the SharePoint list from the Excel file. I have done this many times for other flows but this one is not working. 

 

My Excel Spreadsheet:

Here is my data from the Excel spreadsheet . As you can see columns DB 'Planner Next Update (NU:)' and DC 'Planner Complete Date (NU:)' is what I am trying to import into my SharePoint list. Both columns have both dates and blanks. 

Armyrunner_6-1634330107709.png

 

Column B of the Excel file has the matching column values in 'CIR' to the list that I want the dates added to. The list column with the matching value is 'ProjCIR'.

Armyrunner_7-1634330152009.png

 

My SharePoint List:

The SharePoint list fields 'NU' and 'CD' are formatted as Date/Time (Date only). The matching field to the Excel file is also 'ProjCIR' formatted as Single line of Text.

 

My Flow:

Armyrunner_3-1634329412398.png

 

Second Step Detail:

Armyrunner_4-1634329485049.png

Third step detail

Armyrunner_0-1634333052439.png

 

with condition length(outputs('Get_items')?['body/value']):

Armyrunner_5-1634329611141.png

 

***In my 1st fail I used the Excel values in Apply to each 2:

Armyrunner_2-1634329349809.png

Flow error:

Armyrunner_0-1634329204733.png

Update item error:

Armyrunner_1-1634329288400.png

***My 2nd fail I used addDays('1899-12-30',int(),'yyyy-MM-dd'in Apply to each 2:

Armyrunner_8-1634330318019.png

Flow error:

Armyrunner_9-1634332677274.png

Update item error:

Armyrunner_10-1634332720296.png

Armyrunner_0-1634338220334.png

 

 

 

  • Armyrunner Profile Picture
    Armyrunner 28 on at
    Re: String/date-time issue - The runtime value '""' to be converted doesn't have the expected format 'String/date'.

    Getting this error but appears  to be filling in data. Thoughts?

    Armyrunner_0-1634689388405.png

     

  • v-LilyW-msft Profile Picture
    v-LilyW-msft on at
    Re: String/date-time issue - The runtime value '""' to be converted doesn't have the expected format 'String/date'.

    Hi @Armyrunner 

    I set up a Flow according to the information you provided, you can refer to the screenshot below to see if it helps.

    This is my test excel and list.

    vLilyWmsft_0-1634523411003.pngvLilyWmsft_1-1634523445438.png

    Flow in details:

    vLilyWmsft_2-1634523506374.png

     

    vLilyWmsft_10-1634525256082.png

     

    Note:'Planner Next Update (NU_x003a_)' and 'Planner Complete Date (CD_x003a_)' is 'Planner Next Update (NU:)' and DC 'Planner Complete Date (NU:)' column internal name.You can find it by add a compose action,then select the column,then hover the mouse on the column name, and its internal name will be displayed

    vLilyWmsft_4-1634523813948.png

    vLilyWmsft_5-1634523999521.png

    vLilyWmsft_6-1634524024831.png

    vLilyWmsft_7-1634524057826.png

    Expression1:formatDateTime(addDays('1899-12-30',int(items('Apply_to_each')?['Planner Next Update (NU_x003a_)'])),'yyyy-MM-dd')

    Expression2:formatDateTime(addDays('1899-12-30',int(items('Apply_to_each')?['Planner Complete Date (CD_x003a_)'])),'yyyy-MM-dd')

    vLilyWmsft_8-1634524136561.png

    Save and test.

    After flow runs, the list will be update like this:

    vLilyWmsft_9-1634524773466.png

    Hope the content above may help you.

    Best Regards

    If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

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,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard