Unanswered

@formatdatetime issue

(0) Share

Report

Posted on by 46m4art

Greetings

I am trying to format date time from UTC to iso 8061 I have tried formatDateTime(utcNow(),'yyyy-MM-ddThh:mm:ss') and it spits out both of the time stamps together like "2021-09-21T15:30:00.02300002021-10-15T11:13:43" How do I get it to just spit out the later half and not the utc as well?

Categories:

Using connectors

All responses (5)

Answers (0)

Sort by

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @46m4art,

You can specify the format also within the utcNow function.

Can you try this expression instead:

utcNow('yyyy-MM-ddThh:mm:ss')
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @46m4art :

I've made a test and it worked as expect:

Is that you want?

Best Regards,

Bof
46m4art 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay I tried the above and this is the error it kicked back, these are the types of errors I am seeing regardless of what I am trying. I feel like I am missing something
The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/TimeS' is required to be of type 'String/date'. The runtime value '"2021-09-21T15:30:00.02300002021-10-18T03:03:49"' to be converted doesn't have the expected format 'String/date'.
46m4art 6 on at

Like
a
(0)

Report
Copy link

Link copied!

I have tried multiple times, would it help to see the whole flow? It is not working on my end
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @46m4art :

Could you provide a screenshot of your flow in edit mode?

Could you create a compose action and then set its value to

@{formatDateTime(utcNow(),'yyyy-MM-ddThh:mm:ss')}

and check the result after it runs?

Best Regards,

Bof