Answered

Microsoft Planner Update a Task Error

(0) Share

Report

Posted on by Community Power Pla...

I'm trying to write a flow which goes through the tasks on my planner and if it has been marked "Not Started" (Percent Complete = 0), then

Create a new Google Calendar Event with selected details of the event (Start Time = value Due Date, End Time = value Due Date, Title = value Title, etc.)
- [This section is working just fine, but a side question, when I add the Planner event to my calendar, it always puts it at 6:00 am. This is annoying but workable Is there any way to take the due date from the planner event and make it an all-day Calendar event?]
Update a task to reflect 50% complete, which is the default value for "In Progress" so that it will not be added to the calendar again the next time the flow runs.
- This is the section where I'm running into problems.

After I run the Flow, I get an error back at the Update a Task action.

Status Code: 400

{
  "error": {
    "code": "BadRequest",
    "message": "Resource not found for the segment '\"JzEtVGFzayAgQEBAQEBAQEBAQEBAQEBARCc='.",
    "innerError": {
      "request-id": "238c061d-f963-4301-9818-fd5e3abb6ec8",
      "date": "2018-09-13T22:48:50"
    }
  }
}

Can anyone help me with this error? I've attached a screenshot of my flow. The switch statement is there to decipher the returned Bucket ID ("QpUCGYLtpE2Ej7hKEmZ2ZGQAIOba") and use a plain text in the event description (To Do List).

Flow Error.png

Any help would be greatly appreciated!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

For your flow run failed issue,Please take a try to recreate the flow to see if the issue still exists.

For your problem to take the due date from the planner event and make it an all-day Calendar event,you couldn't create a all-day Google Calendar event in microsoft flow currently,you could refer to screenshot below to create the flow:

The expresssion of the Start time field in the Create an event action as below:

startOfDay(items('Apply_to_each')?['startDateTime'])

The expresssion of the End time field in the Create an event action as below:

addSeconds(addDays(startOfDay(items('Apply_to_each')?['dueDateTime']),1),-1)

The flow would run successfully as below:

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hi Alice, thank you for your help.

Your solution for Update a Task worked perfectly and would never have occurred to me. The solution for the Start/End times in the Create an Event needed some tweaking to fit my needs, but here's what I came up with:

Start time:
addHours(startOfDay(items('Apply_to_each')?['dueDateTime']),4)
End Time:
addHours(startOfDay(items('Apply_to_each')?['dueDateTime']),28)

I added 4 hours to the Start Time to correct for time zones. I added 28 (4 + 24) to the End Time to create an event that lasts a full 24 hours, this way Google Calendar creates an event as a "all-day" event (at the top of the calendar) rather than an event that runs from 00:00 to 23:59.

I can't thank you enough for your help. I never would have been able to figure out the syntax for string referencing or the startOfDay. It's working wonderfully now 🙂

Was this reply helpful? Yes No