String/date-time issue

Like (0) Share

Report

Posted on 19 Nov 2020 12:59:41 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?

I have the same question (0)

All responses (6)

Answers (0)

pennieln 2 on 07 Nov 2023 at 17:08:44

Like (0)

Report

Re: String/date-time issue

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
ThimiosSp 113 on 19 Nov 2020 at 16:09:44

Like (0)

Report

Re: String/date-time issue

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

Was this reply helpful? Yes No
ThimiosSp 113 on 19 Nov 2020 at 15:25:51

Like (0)

Report

Re: String/date-time issue

DueDate is the column from Excel in need to use.

'DueDate_formatted' also appears in the dynamic content.

Was this reply helpful? Yes No
Paulie78 8,416 Moderator on 19 Nov 2020 at 15:04:45

Like (1)

Report
Re: String/date-time issue

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 19 Nov 2020 at 14:50:49

Like (0)

Report

Re: String/date-time issue

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,416 Moderator on 19 Nov 2020 at 13:04:31

Like (1)

Report
Re: String/date-time issue

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