Skip to main content Build an agentic enterprise Get Started Guided Tours Security & Governance Dataverse Connectors Power BI Desktop Pro Premium Embedded Report Server Power Apps Power Automate Power Pages Copilot Studio Pricing Resources by Product Power Platform Learn Power Platform Blog Documentation Power Platform Topics Contact us Start free
1 min read

Does how you submit date and time data matter?


The answer is “Yes” if you are using Canvas apps. Depending on if you are submitting your date and time data through the Power Apps UI or using direct oData API call your data will behave differently, but only for User Local data.

The Power Apps Canvas UI performs calculations on submitted date and time data so that it will display properly. When a date and time for a User Local column is added through an app, an offset will be added or subtracted from the data based on the submitting user’s time zone. This is because when the Canvas UI retrieves and displays a User Local field, it will process the current user’s offset of the value. This results in the expected date and time.

Example: The Pacific time zone has a UTC offset of -8. So submitting 4/4/2021 12:00 in the Pacific time zone will add +8 to the time to make sure when it is retrieved the correct original time is displayed. This results in the UTC value 4/4/2021T20:00:00Z.

When you submit directly using the API, the UI is not involved at all. This means submitting4/4/2021 12:00 through the oData API will result in a stored value of 4/4/2021T12:00:00Z. When the API pulls this value for the Pacific time zone user, it will apply the UTC -8 and the displayed result will be 4/4/2021 4:00, Depending on the UTC offset and the time stored, this can result in your data being off by up to an entire day.

This can be easily fixed by applying your own UTC calculation or offset value when submitting via API.

I’ve recently updated this document to outline this information to help ensure your data works as you intend it to.

  • Power Pages
    Two coworkers working in cubicle looking at computer monitor
    1 min read

    Modern List in Power Pages is now generally available

    Today, we’re announcing the general availability of Modern List in Power Pages, a refreshed data presentation experience that helps makers showcase Dataverse data with modern Fluent UI components, seamless infinite scrolling, inline filtering, shimmer loading, flexible low-code customization and custom JavaScript support.
  • Power Apps
    Power Platform Feature Update (hero image)
    20 min read

    What’s new in Power Platform: September 2026 feature update

    Power Platform Build hands-on Power Platform and AI expertise with Power Series Developed by the Power CAT team, Power Series is now available with 20 hands-on labs that help customers, partners, and field teams build practical Power Platform and AI skills at their own pace.