web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : c1u7jXdOuIBQm5OqtvU6GL
Power Platform Community / Forums / Power Automate - Using Connectors / @formatdatetime issue
Power Automate - Using Connectors
Unanswered

@formatdatetime issue

Like (0) ShareShare
ReportReport
Posted on 15 Oct 2021 23:40:58 by 46m4art 6

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?

 

 

I have the same question (0)
  • v-bofeng-msft Profile Picture
    v-bofeng-msft on 19 Oct 2021 at 01:57:56
    Re: @formatdatetime issue

    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

  • 46m4art Profile Picture
    46m4art 6 on 18 Oct 2021 at 15:23:18
    Re: @formatdatetime issue

    I have tried multiple times, would it help to see the whole flow?  It is not working on my end

  • 46m4art Profile Picture
    46m4art 6 on 18 Oct 2021 at 15:07:03
    Re: @formatdatetime issue

    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 

    46m4art_0-1634569568445.png

    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'.

  • v-bofeng-msft Profile Picture
    v-bofeng-msft on 18 Oct 2021 at 06:40:53
    Re: @formatdatetime issue

    Hi @46m4art :

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

    vbofengmsft_1-1634538955596.png

     

    vbofengmsft_0-1634538930069.png

    Is that you want?

    Best Regards,

    Bof

     

  • Expiscornovus Profile Picture
    Expiscornovus 32,205 Most Valuable Professional on 16 Oct 2021 at 12:41:05
    Re: @formatdatetime issue

    Hi @46m4art,

     

    You can specify the format also within the utcNow function.

     

    Can you try this expression instead:

    utcNow('yyyy-MM-ddThh:mm:ss')

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans