The "Get calendar view of events" action doesn't accept the Timestamp value of a trigger button and the problem seems to be in the timezone value that is part of the Timestamp.
My scenario: When a user triggers a button in the App, I want to send an overview of all upcoming events in his/her calendar. I am using the new "Get calendar view of events" action for that. You can see the Flow below.
The error I get:
{ "status": 400, "message": "Invalid value ''2017-07-19T18:49:38 02:00'' for parameter 'Start Time'\r\nclientRequestId: e90bdd8b-0052-493a-ace0-3745b361b8de", "source": "office365connectionprovider-westeurope.am2-ase-001.p.azurewebsites.net" }
I did some troubleshooting. I entered the entire value manually (because the + sign seems to be missing in the value), like this: '2017-07-19T18:49:38+02:00'. Same error. When I manually enter the value like this: '2017-07-19T18:49:38', the action works.
Hi @maarteneekels,
I have reproduced your issue:
I will update this to the pg and will notice you if I got any information later.
Regards,
Mona
Hi @maarteneekels,
For now, please use the formatDateTime function to format the date in the compose to make it accepted by StartTime/EndTime field as a workaround.
For your reference:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language
https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
Regards,
Mona
Hi @v-monli-msft,
Thanks for the suggestion. Tried this, the default format specifier 'o' doesn't work. The timezone offset is parsed as well, and again part of the output. The only format specifier I got it to work with, is 's', the sortable date/time pattern. The problem with this one is though, that it doesn't take the timezone offset into account at all, it transforms the value to UTC. I can hardcode the compose action to add hours again, but that only works when I am always in the same timezone, which I am not.
Cheers,
Maarten
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |