Unanswered

time picker not showing the correct hour

(0) Share

Report

Posted on by EP-29071004-0

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

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

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

Was this reply helpful? Yes No
EP-29071004-0 on at

Like (0)

Report

@RandyHayes ,
thanks for your reply, bbut it gave same results

Was this reply helpful? Yes No
EP-29071004-0 on at

Like (0)

Report

Hi @RandyHayes
thanks for your reply, but it gave same results

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
EP-29071004-0 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
EP-29071004-0 on at

Like (0)

Report

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

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
EP-29071004-0 on at

Like (1)

Report

Hi @RandyHayes
i finally got permissions to change the site regional settings and now its working correctlly.
thanks a lot for your support

Was this reply helpful? Yes No