web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Outlook to Sharepoint ...
Power Automate
Suggested Answer

Outlook to Sharepoint List Flow All Day Event

(1) ShareShare
ReportReport
Posted on by 2
I have a flow which pulls Outlooks events that are added, updated or deleted and then creates a SharePoint list item. For timed events the flow works great and the time that's listed is correct. However, if the event is marked as all day in Outlook, the event is sent as a UTC time that then is converted to the Pacific standard regional time in SharePoint, so it ends up being 8 hours early. All day events should start at 12AM and go to 12AM the next day, but instead they start at 4PM the previous day and go till 4PM the next. I have not been able to figure out a solution to this issue in Power Automate and am looking for suggestions. I've tried manually writing the date inline, using conditional actions to convert the time zone, changing the column settings to only date, none have worked so far. The attached picture shows a recent test of the flow. I removed the other switches so I could just focus on the all day events trigger, so please ignore that there is only one case.
 
Thank you for your time and help!
Jack 
Screenshot 2026-01-07 165129.png
I have the same question (0)
  • Suggested answer
    trice602 Profile Picture
    15,589 Super User 2025 Season 2 on at
    Hi there!
     
    Here's what I would add if this was my flow.  For all day events, use the following expression to move the time 8 hours:
     
    addHours(your_dynamic_time_content, 8)
     
    So before you write the Item, check the start time and use:
     
    if(equals(formatDateTime(your_dynamic_time_content, "HH", '16'), addHours(your_dynamic_time_content), 8), your_dynamic_time_content)
     
    You may need to clean that up in your expression but you can see here if the start time is 16 hours, add 8 else use the orginal time.
     
    That should get this resolved for you.
     

    ------------------------------------------------

     

     

    ⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

     

     

    Always glad to help! 💯💯💯💯💯

     

    Tom

     

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 185 Super User 2025 Season 2

Last 30 days Overall leaderboard