Convert Time Zone Error

[BrittanyBrown]

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?

[kaitogoto]

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!

[BrittanyBrown]

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.

[ScottShearer]

@BrittanyBrown 

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

[BrittanyBrown]

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