Unanswered

Outlook events to SharePoint List - flow creates and updates but has the same time in each event

(1) Share

Report

Posted on by LauraleeG

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:

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report

Hi @LauraleeG

The trigger also contains start & end time with time zone information that does not require adjusting the time zones.

Please try those fields directly in creating or updating SharePoint list item as shown below:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
LauraleeG 41 on at

Like (1)

Report

Thanks @ManishSolanki

I don't seem to have those options

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
LauraleeG 41 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
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.

Was this reply helpful? Yes No
LauraleeG 41 on at

Like (1)

Report

Hi @ManishSolanki

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

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
LauraleeG 41 on at

Like (1)

Report

@ManishSolanki

Yep they are correct

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
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.

Was this reply helpful? Yes No
LauraleeG 41 on at

Like (1)

Report

Hi @ManishSolanki

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

Was this reply helpful? Yes No