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

Community site session details

Session Id : LLnooeYXt1Ds4KNQvxNqtK
Power Automate - General Discussion
Unanswered

Convert Time Zone Error

Like (0) ShareShare
ReportReport
Posted on 3 Jun 2021 19:15:49 by 6

I am working on a job to send a custom email to a specific user at a specific date/time. 

 

Here is my setup in Power Automate:

 

Convert Time Zone

Base Time: Sample Date/Time (dynamic content from an excel sheet formatted YYYY-MM-DDTHH:MM:SS)

Format String: Universal sortable date/time pattern [u]

Source Time Zone: UTC -05:00 Eastern Time (US & Canada)

Destination Time Zone: UTC -05:00 Eastern Time (US & Canada)

 

Here is the error I am getting: Evaluation of inputs for the expression action of kind 'ConvertTimeZone' failed: 'Required property 'baseTime' expects a value but got null. Path ''.'.

 

Any ideas?

  • BrittanyBrown Profile Picture
    6 on 08 Jun 2021 at 11:58:39
    Re: Convert Time Zone Error

    Thank you, Scott! I tried this and I am still getting the same error, it is failing on the step Convert Time Zone.

  • ScottShearer Profile Picture
    25,236 Most Valuable Professional on 07 Jun 2021 at 19:46:06
    Re: Convert Time Zone Error

    @BrittanyBrown 

    In you List Rows or Get Row action, try selecting ISO 8601 in the Date/Time format area (advanced options).

    image.png

     

  • BrittanyBrown Profile Picture
    6 on 07 Jun 2021 at 17:49:37
    Re: Convert Time Zone Error

    I tried your suggestion and received the same error message as before. 

     

    The email is supposed to be sent out at 7:00 AM EDT, the value in my spreadsheet is listed at 2021-06-07T07:00:00Z. I do have another similar Power Automate flow that works successfully.

  • Kaito Goto Profile Picture
    Microsoft Employee on 04 Jun 2021 at 01:19:14
    Re: Convert Time Zone Error

    I suggest you compose a math function to add "Z" at the end of your base time. So it is formatted "YYYY-MM-DDTHH:MM:SSZ".

     

    When you say "at a specific date/time", do you mean Base, Source or Destination Time? Because depending on your answer to this, it may require you to convert/uncovert times from/to UTC.

     

    Please accept this as a solution if solved. Please provide any error messages and the answer to my question if still not solved. Including a screenshot of your flow will be ideal. All the best!

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

Telen Wang – Community Spotlight

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

Announcing our 2025 Season 2 Super Users!

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

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