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?
Thank you, Scott! I tried this and I am still getting the same error, it is failing on the step Convert Time Zone.
In you List Rows or Get Row action, try selecting ISO 8601 in the Date/Time format area (advanced options).
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.
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!
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2