Unanswered

choosing a date in date picker in powerapps automatically records 4pm in excel list

(0) Share

Report

Posted on by PALQD

When I pick a date in my date picker in powerapps, the time that automatically records in excel (source) is 4pm, I want it to record 12am. On the other hand, When I try to edit in excel, I just put the date, and when I come back to powerapps, it reflects 8am. What to do

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

VishalJhaveri 1,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You need to select the date, store it in a variable, and try to convert the hhmmss parameters keeping in reference the UTC time.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @PALQD ,

When you select a date in PowerApps, actually the date and time value is within the time zone of local device. Let's say you are in UTC+8, after saving 5/7/2024 0:00 to Excel, it records 5/6/2024 16:00. So, if you are saving date time to excel, you need to add the time zone offset to the selected date:

DateAdd(DatePicker.SelectedDate, -TimeZoneOffset(), TimeUnit.Minutes)

Best regards,

Was this reply helpful? Yes No
PALQD 56 on at

Like
a
(0)

Report
Copy link

Link copied!
i will put this formula to what property of the date picker?

DateAdd(DatePicker.SelectedDate, -TimeZoneOffset(), TimeUnit.Minutes)

Was this reply helpful? Yes No
VishalJhaveri 1,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni created a Label in which you need to write down the formula. @PALQD

Was this reply helpful? Yes No
PALQD 56 on at

Like
a
(0)

Report
Copy link

Link copied!

I need the steps to do it the correct way so that when i click a date in powerapps, the excel should record the same date 12am. any ideas how

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PALQD ,

It depends on how you add values into Excel table. The whole formula is just the value that you use.

Best regards,

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PALQD ,

Have you solved this problem?

Best regards,

Was this reply helpful? Yes No