String/date-time issue

(0) Share

Report

Posted on by ThimiosSp

113

Hi all,

Read a zillion posts but could not make it work...

My excel has a DueDate column formated as dd/mm/yy. When using that in setting a Due Date for a Planner Task, I get an error saying

The 'inputs.parameters' of workflow operation 'Create_a_task' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'body/dueDateTime' is required to be of type 'String/date-time'. The runtime value '"31/12/20"' to be converted doesn't have the expected format 'String/date-time'.

Could anyone pls give some clear instructions on that?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Paulie78 8,424 Moderator on at

Like (1)

Report
Copy link

Link copied!
This is so well covered on this forum, check this first:
https://www.tachytelic.net/2020/11/convert-excel-dates-power-automate/
I guess the expression you want is something like:

addDays('1899-12-30', int(item()['Date']), 'yyyy-MM-dd')

But you need to substitute item()['Date'] with your own value from Excel.
Post details of your flow and we will figure it out

Was this reply helpful? Yes No
ThimiosSp 113 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Paulie78,

The expression I'm using is
addDays('1899-12-30', int(item()['DueDate_Formatted']), 'dd-MM-yy')
where DueDate is my Excel column formatted as Date (appears as DueDate (Formatted) in content).

The error I get now is
Unable to process template language expressions in action 'Initialize_variable' inputs at line '1' and column '15570': 'The template language expression 'addDays('1899-12-30', int(item()['DueDate_Formatted']), 'dd-MM-yy')' cannot be evaluated because property 'DueDate_Formatted' cannot be selected.

Was this reply helpful? Yes No
Paulie78 8,424 Moderator on at

Like (1)

Report
Copy link

Link copied!
It is simply saying that you don't have the field DueDate_Formatted within the current scope of whatever you are in. Are you in a loop when executing this? Maybe you just need:
addDays('1899-12-30', int(outputs('DueDate_Formatted')), 'dd-MM-yy')'
But really it is just a guess based on what you put. What is DueDate_Formatted?

Was this reply helpful? Yes No
ThimiosSp 113 on at

Like (0)

Report
Copy link

Link copied!

DueDate is the column from Excel in need to use.

'DueDate_formatted' also appears in the dynamic content.

Was this reply helpful? Yes No
ThimiosSp 113 on at

Like (0)

Report
Copy link

Link copied!

I thought that maybe a full view of my flow will help to better understand to setup.

Was this reply helpful? Yes No
pennieln 2 on at

Like (0)

Report
Copy link

Link copied!

I find that converting the form's submission time from UTC to your needed time zone with the General time/date pattern helps with this error.

Was this reply helpful? Yes No