cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Perez
Helper IV
Helper IV

time picker not showing the correct hour

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???

 

 

image.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User III
Super User III

@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?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

9 REPLIES 9
RandyHayes
Super User III
Super User III

@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. 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

@RandyHayes ,

thanks for your reply, bbut it gave same results

Hi @RandyHayes 

thanks for your reply, but it gave same results

RandyHayes
Super User III
Super User III

@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.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

@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
Super User III
Super User III

@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?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

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
Super User III
Super User III

@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).

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Hi @RandyHayes 

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

thanks a lot for your support

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (52,013)