Unanswered

Create calendar event from assigned task

(0) Share

Report

Posted on by Community Power Pla...

We're trying to use the Tasks app in Teams to organize a lot of what we do, and members of the team want Outlook calendar events created automatically when a task is assigned to them. I've got a screenshot of the issue below, but the crux of the issue is the date formatting:

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_event_(V4)': The parameter with value '"@triggerOutputs()?['body/startDateTime']"' in path 'item/start' with type/format 'String/date-time' is not convertible to type/format 'String/date-no-tz'.'

In the end, I'd actually like to create a 1 hour event for 9am-10am on the due date, but at the moment I can't get it to save and run at all, pulling the date string from the Planner event. Any help?
Thanks!

Categories:

Building Power Apps

Screenshot 2021-0...

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
The DateTime values you are supplying are probably in UTC mode. They need to be converted to TimeZone independent format. You can do that with the following format. just substitute your input values for the UTCNow() in the fuction below.

formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ss.fffffff')

Was this reply helpful? Yes No
mickyb23uk 50 on at

Like (0)

Report

Hi all, just bumping this one as I can't see a resolved/solved answer for it.
I'm having exactly the same request, when creating a planner task with a due date in the future and it creating a calendar event on that due date from 9-10am every time.

I've tried using these 2 expressions but it keeps reverting back to Zulu/UTC time.
Note: These were from the Power Apps Template Library for "Create an event in Outlook on New Planner task"

coalesce(triggerBody()?['startDateTime'],convertFromUtc(utcNow(),'AUS Eastern Standard Time'),'dd-MM-yyyy')
coalesce(triggerBody()?['dueDateTime'],convertFromUtc(utcNow(),'AUS Eastern Standard Time'),'dd-MM-yyyy')

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

You are converting the date/time from UTC, but then formatting it to be date only. That will automatically become midnight UTC. The Start and End time should be input using UTC. The Timezone setting is used to determine what time zone the user should see the event in, not what time zone is used in the Start and End time.

Was this reply helpful? Yes No
mickyb23uk 50 on at

Like (0)

Report

After following a very similar guide (here) I was able to get the desired results I was after.
Hope this helps the next person.

The expressions I used in the below screenshot are:

Compose Function
Inputs : formatDateTime(triggerBody()?['dueDateTime'],'MM-dd')
Note : I'm using just the dueDateTime value here.
In Planner, I'm just using the quick card which only has the 'Set due date' option (along with task name & assignee)

Create Event (V4)
Start Time : addToTime(outputs('Compose'),8,'Hour') - This sets the event start time to 8:00am
End Time : addToTime(outputs('Compose'),9,'Hour') - This sets the event end time to 09:00am

Was this reply helpful? Yes No
BW-04020315-0 2 on at

Like (0)

Report

mickyb23uk did you have to create this flow for each of your Team members or just the creator of the task in planner? The link in your solution appears to no longer work could you please share that again? Any thoughts on creating a reminder event say one week before the due date? My team would like an outlook event reminder to pop up one month before due date, one week before due date and then on the due date.

Was this reply helpful? Yes No