cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Incorrect time displaying in SharePoint item

I have built a flow that creates a SharePoint item when an Outlook calendar event is created. As part of the flow, I have converted the source time from UTC (since the Outlook time zone is converted to UTC within Flow) to the destination time of "Outlook time zone" (so that the output time zone matches the time zone of the Outlook calendar from which the event was created). When I look at the run history of my flow the conversions work just fine, but when I look at the SharePoint calendar, the item displays the UTC time rather than the converted time. I have checked the Regional Settings for my SharePoint page and the time zone is set correctly. Any explanation for why this is happening and, more importantly, how to fix it is greatly appreciated. Thank you.

 

Pictures below show the output for SharePoint "Create item" command as well as the SharePoint calendar where that item is created. 

 

conversion flow output.pngSP calendar.png

7 REPLIES 7

Hi @sstrickland I recently answered a similar post where I witnessed the behaviour you described.

 

Without seeing your Flow I can't really comment, but can you have a look at this first and see if this helps?

https://powerusers.microsoft.com/t5/Building-Flows/New-calendar-entry-outlook-to-event-webpart-SP-si...

 

If you have found this post useful, please give it a thumbs up. If it has answered your question, please accept it as the solution so others can benefit.

@MattWeston365





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
If you liked my response, please consider giving it a thumbs up. THANKS!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

@MattWeston365 Thank you for the quick response. I have tried using that expression, rather than the Convert Time Zone command, but I get the same result. The output of the expression is correct when I look at the run history of my flow, but the time that appears in the SharePoint calendar does not match the conversion output.

 

Here are relevant pictures of my flow:

flow.PNG

flow2.PNG

 

The Output photo included in my original post was the run history output of the converted start and end times that appear above.

I saw similar strangeness when I was working with the SharePoint calendar when I was working in that other thread. The SharePoint event list starts doing it's own thing if you try to tell it what timezone to use, so by including Z you're telling it that it's the UTC time, but then it's doing it's own conversion based on the site regional settings.

 

In your create item, try using the expression I suggested for both the start and end times:

formatDateTime(<dynamic content>,'yyyy-MM-ddTHH:mm:ss')

 

It will format the datetime you've converted (so the one you're expecting to be correct) but it strips off the Z. SharePoint should then interpret this and do what it wants to do, and should give you the correct time in the calendar.

 

If you have found this post useful, please give it a thumbs up. If it has answered your question, please accept it as the solution so others can benefit.

@MattWeston365





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
If you liked my response, please consider giving it a thumbs up. THANKS!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

@MattWeston365  Thank you. Adding that expression within the Create Item command worked for events that were not marked as all day, but it is not working for those events that are marked all day. Do you know how to fix that problem?

Hi @sstrickland excellent, good to see we're making progress. What is the behaviour that you're seeing with a full day event?

 

If you have found this post useful, please give it a thumbs up. If it has answered your question, please accept it as the solution so others can benefit.

@MattWeston365





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
If you liked my response, please consider giving it a thumbs up. THANKS!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

When I enter a full day event, the event is showing up on the SharePoint calendar over 2 days. For example, I created an all day Outlook event for Friday, May 17 (event started at 12:00am May 17 and ended at 12:00am May 18 in Outlook). I didn't make any changes to my flow, and what showed up in SharePoint was an event that started at 8:00pm May 16 and ended at 8:00pm May 17. I know that the 4 hour difference is related to the difference between UTC and Eastern time, but what I don't understand is why this behavior is occurring when the exact same flow results in the correct time appearing when the Outlook appointment is not an all day event.

 

I hope that makes sense and I can send screen shots if that would help.

Hi @sstrickland ,

 

About the issue on All day event, you may consider using action Send an HTTP request to SharePoint.

 

Please take the following thread for a reference:

https://powerusers.microsoft.com/t5/I-Found-A-Bug/All-Day-Event-in-a-SharePoint-Calendar-is-not-reco...

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (88,813)