web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Local time zone

Power Apps

Answered

Local time zone

(1) Share

Report

Report

Posted on by judithPA

85

I am adding data to a collection on a canvas app with

moveDate:Now()

How do i get the date and time to pick up my local time zone please

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@judithPA

Now() is supposed to do it automatically to show matching local time and date of your system.

If you want it to show a different one, just use Now() and DateAdd
judithPA 85 on at

Like
a
(1)

Report
Copy link

Link copied!

Ahh, i have just checked that and you are right, it shows the date correctly on the App but when I save back to a sharePoint list it reverts. I save back with:

Collect(stockScan,stockCollect)

Do i need to save the fields back individually and manipulate the date there. I have the sharePoint site set up with the London (UTC) time zone set
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@judithPA

You may need to, yes, to convert to UTC, do this:

DateAdd(Now(), TimeZoneOffset(), Minutes)

Check if writing the date converted with above helps.
judithPA 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Where do I add this? I am collecting the data from a barcode scanner with the OnScan
Collect(stockCollect, {Title:BarcodeScanStock.Value,equipment:BarcodeScanStock.Value,location:User().FullName,moveDate:Now(),stockBox:"S"})
And then a Save button OnSelect is where I set
Collect(stockScan,stockCollect)

The scan seems to pull back the data OK so I am guessing it should be on the Collect statement but I am not familiar with this at all

Thanks

And a Save button

Join the conversation