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

Like (1) Share

Report

Posted on 9 Dec 2022 07:28:20 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.

All responses (6)

Answers (1)

RGB5 57 on 09 Dec 2022 at 11:05:19

Like (0)

Report

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 on 09 Dec 2022 at 09:11:24

Like (1)

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

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
RGB5 57 on 09 Dec 2022 at 08:44:26

Like (0)

Report

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 on 09 Dec 2022 at 08:00:24

Like (0)

Report

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 57 on 09 Dec 2022 at 07:41:04

Like (0)

Report

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.

I have total 4 Date columns in the sheet. This error coming up randomly on any of the column.
v-chengfen-msft on 09 Dec 2022 at 07:33:25

Like (2)

Report

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

HI @RGB5 ，
Please set DateTime Format： ISO8601

Here is a test :

Best Regards
Cheng Feng