You’re offline. This is a read only version of the page.
Announcements
41
I've created a flow using the template "Create a SharePoint List Item when an Office 365 event is added or updated" the flow creates and updates as needed with the exception of the time, all events are coming into the SharePoint list with the start and end time of 11:00. I'm not sure what is going on???
The events being tested are all on the same day but at different times of the day but as per the list below they are all at the same time:
Unfortunately that didn't work 😞 I got this error when I tested it:
Unable to process template language expressions for action 'Convert_start_time_zone' at line '0' and column '0': 'In function 'converttimezone', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.
But then it ran successfully on it's own after that? But the times are still wrong. It's very strange
Pls try using 'Convert time zone' action and use custom format string in each action:
yyyy-MM-ddTHH:mmZ
Pass the converted start & end time to create and update items.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Hi @LauraleeG
Pls go to "Site Settings" and verify time zone setting under "Regional Settings". It should be matched with local time zone:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
So that gives me different times for start and finish of each meeting and well as different times throughout the day, but they aren't the correct times?
Below is the list in SharePoint
This is the calendar with the events in it
Hi @LauraleeG
Alternatively, I think we can write an expression directly in SharePoint column to get this done. Please use the below expression for start & end time:
Expression used for Start time:
formatDatetime(triggerOutputs()?['body/start'],'yyyy-MM-ddTHH:mmZ')
Expression used for end time:
formatDatetime(triggerOutputs()?['body/end'],'yyyy-MM-ddTHH:mmZ')
I hope these expressions will resolve the problem.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks @ManishSolanki
I don't have that as an option, I'm assuming that is something to do with our IT department and either allowing access or not updating the servers to the most current version?
Hi @LauraleeG
It seems you have taken lower version of trigger. You need to use higher version (V3) to get those fields or properties:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
