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.
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
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.
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
@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.
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional