You’re offline. This is a read only version of the page.
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???
Hi @RandyHayes
i finally got permissions to change the site regional settings and now its working correctlly.
thanks a lot for your support
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).
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).
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?
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.
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.
Hi @RandyHayes
thanks for your reply, but it gave same results
thanks for your reply, bbut it gave same results
Consider changing the Default for your Hour dropdown to the following:
Share
Report
All responses (
Answers (
Text(
Hour(
DateAdd(Parent.Default, -TimeZoneOffset(Parent.Default), Minutes)
),
"00"
)I hope this is helpful for you.
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
