Skip to main content

Notifications

Community site session details

Community site session details

Session Id : RxAA+H59vN8bMgrw71c3D1
Power Automate - Building Flows
Answered

Input parameter is required to be of type 'String/date

Like (1) ShareShare
ReportReport
Posted on 9 Dec 2022 07:28:20 by 57

Hello Everyone

 

I am getting this error, Input parameter 'item/PlannedStartDate' is required to be of type 'String/date'. The runtime value '"44869"' to be converted doesn't have the expected format 'String/date'.

 

PlannedStartDate  is coming from an Excel file as a Date which i have placed in the SharePoint library. In Sharepoint the column is set up as a date. Below is the screen shot of the errored record

 

Error.PNG

 

 

Below is the flow screenshot.

 

error_record.PNG

The Flow is capturing the date as "44869" as value. I am not sure how the actual date is converted to this format.

 

Note :- This is only happening when I am doing the Copy paste on excel. I have also cross checked the source sheet from where i am copying has also the Date format column.

 

 

  • RGB5 Profile Picture
    57 on 09 Dec 2022 at 11:05:19
    Re: Input parameter is required to be of type 'String/date

    @v-chengfen-msft ,

     

    Thank you it worked as expected.

  • Verified answer
    v-chengfen-msft Profile Picture
    on 09 Dec 2022 at 09:11:24
    Re: Input parameter is required to be of type 'String/date

    Hi @RGB5 ,

    I mean:
    Not using IOS8601,
    Then all dates will be numbers
    Then convert all date in number format to date by formula

     

    if(empty(item()?['Timesheet Completed Date']),null,addDays('1899-12-30',int(item()?['Timesheet Completed Date']),'yyyy-MM-dd'))

    vchengfenmsft_1-1670576862264.png

     

     

    Here is result:

    vchengfenmsft_0-1670576645557.png

     

    Here is a link for your reference:

    Working with Date & Time data of Excel in Power Automate (bythedevs.com)

     

    Best Regards

    Cheng Feng

     

  • RGB5 Profile Picture
    57 on 09 Dec 2022 at 08:44:26
    Re: Input parameter is required to be of type 'String/date

    @v-chengfen-msft ,

     

    Can you please suggest exactly where I need to chip in the below formula.

     

    Coalesce(formatdatetime(Exceldate,"MM-DD-YYYY"), " ")

     

    Currently I am using the below expression in the Date fields.

     

    if(equals(item()?['Planned Start Date'],''),null,item()?['Planned Start Date'])

     

  • v-chengfen-msft Profile Picture
    on 09 Dec 2022 at 08:00:24
    Re: Input parameter is required to be of type 'String/date

    Hi @RGB5 ,

    Sorry,

    This may also be a BUG.


    To avoid this problem,


    You can use formulas all over to get the time. (This may be a relatively inefficient method, but it can solve the random occurrence of this format time)




    Here is a link explaining how to convert, for your reference:

    Excel Date changes in Power Automate - Power Platform Community (microsoft.com)

     

    Best Regards

    Cheng Feng

  • RGB5 Profile Picture
    57 on 09 Dec 2022 at 07:41:04
    Re: Input parameter is required to be of type 'String/date

    @v-chengfen-msft , Thank you for the quick replay.

     

    This has been already set at the time of building the flow.

     

    DateFormat.PNG

     

    I have total 4 Date columns in the sheet. This error coming up randomly on any of the column.

  • v-chengfen-msft Profile Picture
    on 09 Dec 2022 at 07:33:25
    Re: Input parameter is required to be of type 'String/date

    HI @RGB5 ďĽŚ

    Please set  DateTime Format: ISO8601

    vchengfenmsft_1-1670571393388.png

     

    Here is a test :

    vchengfenmsft_3-1670571657455.png

     

     

     

    Best Regards

    Cheng Feng

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard