Answered

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

(1) Share

Report

Posted on by RGB5

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

Below is the flow screenshot.

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.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

v-chengfen-msft on at

Like (2)

Report

HI @RGB5 ，
Please set DateTime Format： ISO8601

Here is a test :

Best Regards
Cheng Feng

Was this reply helpful? Yes No
RGB5 57 on at

Like (0)

Report

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

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

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

Was this reply helpful? Yes No
v-chengfen-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
RGB5 57 on at

Like (0)

Report

@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'])

Was this reply helpful? Yes No
Verified answer

v-chengfen-msft on at

Like (1)

Report
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'))

Here is result:

Here is a link for your reference:
Working with Date & Time data of Excel in Power Automate (bythedevs.com)

Best Regards
Cheng Feng

Was this reply helpful? Yes No
RGB5 57 on at

Like (0)

Report

@v-chengfen-msft ,

Thank you it worked as expected.

Was this reply helpful? Yes No