Hi trying to create an "outlook" task with flow. Strugeling with the date format.
I have tried a dynamic value (SP list date column) as well as hardcoded a value: 2017-01-25T10:58:56Z
Still getting this :
INPUTS
Due Date-Time
2017-01-25T09:22:45Z
Reminder Date-Time
2017-01-25T12:58:56Z
Start Date-Time
2017-01-25T12:58:56Z
Importance
Normal
ERROR
Body
{
"error": {
"code": "TimeZoneNotSupportedException",
"message": "A valid TimeZone value must be specified. The following TimeZone value is not supported: ''."
}
}
Almost a year and a half later and still no idea on how to format the date started string. Would be nice is someone could post the string format needed to populate the start date of a task.
Hi I manged to hadle the dates in a different scenario using this function.
Farliy new, just found it by random trying to solve something similar.
https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/
After contacting Microsoft I discovered that the template I started with, "Create a task in Outlook Tasks and Wunderlist for flagged Office 365 emails", had the time zone set to NULL. I found this when I exported the flow and checked the values in the zip file. When I created a new flow from a blank template and used the same settings as in the original template the new flow worked with out any problem.
The code provided by Microsoft to test the flow was convertFromUtc(utcNow(),'Central Standard Time','yyyy-MM-dd hh:mm:ss')
Thank you. The solution is create a brand new flow instead of use Microsoft pre-defined template.
As far as I can tell, this is still broken. I've just spent an hour trying various methods mentioned here to get the "Reminder Date-Time" format to be correct, and none of them worked.
Update: Didn't realize what was meant by the comment just before mine. The template provided within Flow is broken.
To get dates (like "Reminder Date-Time") to work, do not use the Template. Instead, create a blank Flow first, then add the "Manually trigger a flow" action and the "Create a task" action.
Then you can add a datetime to the Reminder Date-Time field and it will just work...sort of... no special formatting required.
For example, I used a "Get future time" to set a reminder for 36 hours in the future.
There is still an issue that the "Dynamic content" dialog doesn't offer the Output from "Get future time" to add to the "Create a task" flow. You can add it manually by clicking "See more" in the Dynamic content tab, then clicking the "Future time" (in my case) item.
So... the Template is definitely broken in terms of time zones, and the Create a task Action is also broken in terms of recognizing correctly formatted data from other Actions. Yikes.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
15 | |
10 | |
3 | |
3 | |
3 |