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!
Solved! Go to 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.
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?
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
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"
}
Proud to be a Flownaut!
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.
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')
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
User | Count |
---|---|
26 | |
25 | |
25 | |
25 | |
18 |
User | Count |
---|---|
57 | |
44 | |
36 | |
31 | |
30 |