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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Maintain date/time ent...
Power Apps
Unanswered

Maintain date/time entries submitted in other timezones as pacific time zone via PowerApps

(0) ShareShare
ReportReport
Posted on by 49

I have a powerapp where the users select the start and end date/time for a request. If a user is in the Mountain Standard Time zone and submits the request where the start date/time is 5/15/2019 at 8:30 am, the time is stored as 5/15/2019 at 7:30 am on the SharePoint site and for users in the Pacific Time zone that are processing the request. Would it be possible to have all date/time entries submitted the PowerApp to be submitted as if they are from the Pacific Time Zone? Using the example above, I am looking for the time to be stored as 5/15/2019 at 8:30 am on the SharePoint site and for users in the Pacific Time zone.

 

 

 

Chris

Categories:
I have the same question (0)
  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @CLS720 ,

    Which Time Zone does your SP Site set to? It is also set to Pacific Time zone?

    Do you want to store the Date time values submitted from your PowerApps app to your SP list as they are from the Pacific Time zone?

     

    Actually, the date time value stored within your SP list is based on the Time Zone of the end user who run this app.

     

    Currently, when working date time values within PowerApps, the date time value would be converted into UTC format automatically.

    In other words, the date time values submitted from your PowerApps app would be converted into UTC format time value firstly, then pass the formatted UTC time value to your SP list. Within your SP list, the formatted UTC time value would be converted to local time zone based on the time zone your SP Site set to.

     

    If the Time Zone is different when the end users run this app, the time value submitted from this app would be converted into different UTC format time value, so the time value stored in your SP Site would be different.

    If you want to maintain date/time entries submitted in other timezones as pacific time zone via PowerApps, I afraid that there is no direct way to achieve your needs in PowerApps currently.

     

    As an alternative solution, when the end users submit date times from this shared app, you could consider ask them to convert the submitted time value into a Pacific Time zone (UTC-7) format firstly (using DateAdd function and TimeZoneOffset function), then submitted the formatted Pacific Time zone value into your SP Site.

    I have made a test on my side, please take a try with the following workaround:12.JPG

    Within my Edit form, unlock the Start Time data card, set the Update property of the Start Time data card to following:

    DateAdd( /* <-- Convert the UTC format value into Pacific Time zone value */
    DateAdd( /* <-- Convert the end user's picked time value into the UTC format firstly */
    DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0),
    TimeZoneOffset(),
    Minutes
    ),
    -7,
    Hours
    )

    More details about how to convert a specific time value into a UTC format, please check the following article:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff#converting-to-utc

     

     

    Best regards,

  • CLS720 Profile Picture
    49 on at

    Hi @v-xida-msft ,

     

    That is correct- the regional setting for the SharePoint site is set to PST. That is also correct that I want the date/time values submitted from the PowerApp to automatically be converted to PST and be stored in the SP list as PST, even if the user is not submitting from the Pacific Timezone.

     

    It sounds like I would need to add a field to the form so that the user could select which timezone they are in and then use that selection to determine how many hours must be subtracted from the UTC time to convert it to the PST time. Is that correct?

     

    Thank you for your help!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard