Create a task in Planner when event is created (office 365) which the date of conclusion in the same as the day of the event

[rafa_ilumeo]

Hey Guys, i have a question about connecting the Office 365 Calendar to Planner.

I want to create a task in planner when a event is scheduled in calendar. The point is: I want that the time of the conclusion for the task to be the same as the date which the event will occur.

When setting i see no option like this. Just the option to use the time the event was created (which is not that helpful) and last time it was modified.

What can i do?

I hope it is clear to understanding.

Thanks!

[efialttes]

Hi!
You considered using Planner task Due Date, right?
Which trigger are you currently using? It does not provide event date but it provides the calendar event ID, right? If so, you can use 'get event'
Hope this helps

[rafa_ilumeo]

Thank you so much for aswering.

I dont think i got so clear in my message haha (sorry for bad english)

The scenario is this: https://prnt.sc/rzc76l

And the problem is: https://prnt.sc/rzc86v - I cant set the conclusion date in the task as the date that the event will occur

Understand?

[efialttes]

Understood.
Did you click on ' veja mais' ('see more', top right corner of dynamic content menu)
Hope this helps

[rafa_ilumeo]

Yes, i did that. Doesnt solved my problem. The option i look is not there =(

[efialttes]

Hi again!

Then... just after the trigger add a 'get event' action block. It should provide all event related info, Start time, End time, Subject, etc

Hope this helps

[rafa_ilumeo]

First, thanks for being so helpful.

Secondly, it didnt worked givin an error (after this - https://prnt.sc/rzcpoo) :

{
  "status": 400,
  "message": "Bad Request - Error in query syntax.\r\nclientRequestId: c6f4e6cb-3fe6-485d-be20-167214d04a20\r\nserviceRequestId: 051c1ada-0c7a-4e51-be4e-78fd2894e505",
  "error": {
    "message": "Bad Request - Error in query syntax.",
    "code": "BadRequest",
    "originalMessage": "Bad Request - Error in query syntax."
  },
  "source": "office365-eus.azconn-eus-01.p.azurewebsites.net"
}

[efialttes]

Hi!
I am afraid the ID you are assigning to 'Get event' is wrong.
You need to assign the ID from the trigger's output.
This is the list of outputs your trigger provides:
https://docs.microsoft.com/pt-pt/connectors/office365/#graphcalendareventclientreceive

Let me insist you to search for the triggers name in the dynamic content menu and click on ' veja mais' ('see more', top right corner of dynamic content menu).
Please share a screenshot with all outputs displayed
Hope this helps

[v-alzhan-msft]

Hi @rafa_ilumeo ,

I have made a test on my side and the issue is confirmed on my side.

You could add the Compose to save the start and end time and then use the time saves in the Compose as my screenshot below:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rafa_ilumeo]

Hi, thanks efialttes and azlhan for answering.

I tried this possibility withou success: https://prnt.sc/rzzcnz

The error is in the task creation as follows

{
  "error": {
    "code": "",
    "message": "The request is invalid:\r\nCannot convert the literal '2020-04-22T00:00:00' to the expected type 'Edm.DateTimeOffset'.",
    "innerError": {
      "request-id": "e6915d60-84e7-4e29-a621-a419ce84716c",
      "date": "2020-04-15T17:11:57"
    }
  }
}

[v-alzhan-msft · Accepted solution]

Hi @rafa_ilumeo ,

Please format the date time with expression below:

formatDateTime(outputs('Compose'),'yyyy-MM-ddTHH:mm:ssZ')

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.