time picker not showing the correct hour

[Perez]

Hi i  built a dfate picker with a date and two drop downs for Hours and minutes

my for mula in the hopures default: Text(Hour(Parent.Default),"00")

the Update filed of the data card: DatePicker.SelectedDate + Time(Value(HourDD.Selected.Value), Value(MinutesDD.Selected.Value), 0)

my hour filed have values 1-23 in the item property

i used this article to build it:https://www.spguides.com/date-time-picker-in-powerapps/

the thing is that when im selecting an hoour in the form, it is not reflected correctlly in Sharepoint, but 14 hours ahead, do you have any idea why???

[RandyHayes]

@Perez 

Consider changing the Default for your Hour dropdown to the following:

Text(
   Hour(
      DateAdd(Parent.Default, -TimeZoneOffset(Parent.Default), Minutes)
   ),
   "00"
)

I hope this is helpful for you. 

[Perez]

@RandyHayes ,

thanks for your reply, bbut it gave same results

[Perez]

Hi @RandyHayes 

thanks for your reply, but it gave same results

[RandyHayes]

@Perez 

What part of this are you concerned with?  That the value stored in SharePoint is 3, or are you not seeing the value in your app properly when editing that record?

If it is the first, the SharePoint list, then just change the regional settings of your site for the proper time zone.

[Perez]

@RandyHayes ,

when im selecting an hour in the app, after submission its showing the hour +14 in sharepoint, also when editing the record it will show the wrong vlaue rather than the one i typed.

[RandyHayes · Accepted solution]

@Perez 

Have you set the proper region for your list?

Also, it would be best to store your date as a UTC date/time.

How are you currently submitting the information?  It appears that it is in a form.  If so, what is the Update property of the datacard that contains the date and time pickers?

[Perez]

Hi @RandyHayes ,

so i checked it and you were right my local time is +10 hours from the site regional setting.

how can i overcome it without changing rthe site region (its not my site).

[RandyHayes]

@Perez 

I'm still not sure what you want to correct - how the time appears in SharePoint, or how the time shows in PowerApps.  You can either store your time in SharePoint adjusted to the timezone of the list, and then either adjust in PowerApps to accommodate.  Or, store your time in UTC and then adjust in PowerApps (your list will already adjust because of the region settings).

[Perez]

Hi @RandyHayes 

i finally got permissions to change the site regional settings and now its working correctlly.

thanks a lot for your support