cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rafa_ilumeo
New Member

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @rafa_ilumeo ,

 

Please format the date time with expression below:

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

1.png

 

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.

View solution in original post

10 REPLIES 10
efialttes
Super User
Super User

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


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



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?

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


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



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

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



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"
}

 

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


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



v-alzhan-msft
Community Support
Community Support

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:

1.png

 

 

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.

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"
    }
  }
}

Hi @rafa_ilumeo ,

 

Please format the date time with expression below:

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

1.png

 

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.

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,107)