Answered

Now() value patches different time

(0) Share

Report

Posted on by biancadevera

I'm currently following the tutorial about time tracker app by @RandyHayes . I noticed that my ActivityDate column doesn't match the value of Now() I see in Power Apps. How did this happen? The other column ActivityDateTime value shows correct time in yyyymmddhhmm format.

Please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@biancadevera

Since the ActivityDate column is a Date column, it is subject to the regional settings of your list/site in SharePoint.

I would first take a look at your site settings for what region it is set to. This will determine how a date and time is shown.

If you are putting Now() into the ActivityDate column and it shows differently, then it is almost always the regional settings.

I hope this is helpful for you.

Was this reply helpful? Yes No
biancadevera on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response @RandyHayes . Will look into it.

Also, I'm having errors with the Hour dropdown. I'm not quite sure if it has something to do with the ActivityDate as well. Every time I try to edit the time, the dropdown's default shows as 1 instead of the right value:

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

Like (0)

Report
Copy link

Link copied!

@biancadevera

What is the Items property of the Hour dropdown and what is the Default of it?

Was this reply helpful? Yes No