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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Time Issue
Power Automate - Building Flows
Answered

Time Issue

(0) ShareShare
ReportReport
Posted on by JR-15101929-0 58
Compose-DateTime formatDateTime(convertTimeZone(utcNow(), 'UTC', 'Eastern Standard Time'), 'MM-dd-yyyy HH:mm:ss') get result 12-05-2024 08:58:39 then i use this to add a day Compose-Add 1 Day addDays(outputs('Compose-DateTime'),1,'MM-dd-yyyy') get result 12-06-2024. Then i do Create Item to add these items to the SharePointList and the results are:

DateTime (Compose-DateTime): 12/5/2024 3:58 AM should be 12-05-2024 08:58:39
 
Email (Compose-DateTime): 12/5/2024 3:58 AM should be 12-05-2024 08:58:39
 
Call (Compose-Add 1 Day): 12/5/2024 7:00 PM should be 12-06-2024 08:58:39
 
The SharePoint site is set to (UTC-05:00) Eastern Time (US and Canada) which we are.
 
cant for the life of me figure out why this is doing this. Thank you in advance.
Categories:
Business Process Flows
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    Pstork1 68,271 Most Valuable Professional on at
    Time Issue
    The problem is that Power Automate operates at the storage level of SharePoint. SharePoint stores dates and times in UTC. So when you run a Create Item you should be giving it the Date/Time in UTC ISO 8601 format.  If you try to feed it a Date time string that it recognizes, but that is not in UTC then it will try to use it as UTC. If it can't it will throw an error. In your case its taking the Eastern Time values that you are giving it (without a timezone reference) as a time zone independent format and using it as UTC.  To get the right values you should be converting the values to UTC before using them.
     
    When working in the SharePoint UI, SharePoint will do all that for you. But in a flow you need to make sure everything is in 8601 UTC for input to get the right values.

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 722 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 461 Moderator

#3
developerAJ Profile Picture

developerAJ 283

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans