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?
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!
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.
In you List Rows or Get Row action, try selecting ISO 8601 in the Date/Time format area (advanced options).
Thank you, Scott! I tried this and I am still getting the same error, it is failing on the step Convert Time Zone.
User | Count |
---|---|
27 | |
14 | |
12 | |
10 | |
9 |
User | Count |
---|---|
51 | |
29 | |
28 | |
24 | |
21 |