Skip to main content
Community site session details

Community site session details

Session Id : ePLCqqlTpffYQGax/AesPk
Power Automate - Building Flows
Unanswered

Convert date from UTC

Like (0) ShareShare
ReportReport
Posted on 12 Jun 2020 17:31:56 by

 

Hello Everyone,

When building a flow, i'm having trouble with the date when adding a row into excel. I know i must convert the time zone to my location, but i can't run the flow with succes with this expression:

convertFromUtc(items('Herfstvakantie_toevoegen')?['Start'],'W. Europe Standard Time','dd-MM-yyyy')

 

When running the flow, i get the next error box:

 

"

Cannot process the template language expressions in the input for the Vakantie_toevoegen_aan_tabel on line 1 and in column 2875: For the template language function convertFromUtc, the first parameter is expected to be a string containing a UTC date / time. The value is 2020-01-08T00: 00: 00.0000000. Go to https://aka.ms/logicexpressions#ConvertFromUtc for usage information.

"

As you can see, the value is a date in UTC format.

 

Note: The "convert time zone" must be an expression and not an action. The expression is adding an row in Excel.

Excel zoomed in.png

Al the expressions with the text "start" and "eind" are going to changed with the expression exaple above.

There is no room any more for more actions...

Excel zoomed out.png

 

Thanks in advance 🙂

 

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 12 Jun 2020 at 21:06:53
    Re: Convert date from UTC

    Hi @Anonymous 

     

    Try using Convert Time Zone action step

     

    See below

     

    image.png

  • Community Power Platform Member Profile Picture
    on 12 Jun 2020 at 20:46:54
    Re: Convert date from UTC

    Hi @abm ,

    Thank you for your comment. Unfortunnaly your idea didn't solve the case. Got the same error result mentioned above.

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 12 Jun 2020 at 17:41:29
    Re: Convert date from UTC

    Hi @Anonymous 

     

    Try the below.

     

    convertFromUtc(string(items('Herfstvakantie_toevoegen')?['Start']),'W. Europe Standard Time','dd-MM-yyyy')

     

    Thanks

     

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

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete