Answered

Now() displays differently depeding on the device

(0) Share

Report

Posted on by Raph1

As the title suggests, I made a sharepoint list on Lists linked to a PowerApps form. One of the labels is a non-editable date, with the formula Default = Text(Now(); "mm/dd/yyy hh:mm").

Despite the format of Now() I put, as you can see on the screenshot I put, the data of the date column comes out in different ways. Note that every different format you see is from a different person, and that person will always keep his specific format when publishing his form.

Is there something wrong with my formula ? Is it a compability problem ?

Thanks in advance,

Raph1

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

PowerAGuy 270 on at

Like
a
(0)

Report
Copy link

Link copied!

I believe this would be to do with the regional settings for the user in SharePoint, as that is what controls the date formatting

Was this reply helpful? Yes No
Raph1 71 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't think so, considering that every user is in the same building as me, and none are using a VPN 😕

Was this reply helpful? Yes No
PowerAGuy 270 on at

Like
a
(0)

Report
Copy link

Link copied!

have you checked SP?
Go to Site Settings - Regional Settings and check the 'Locale' and 'Time Zone' are consistent for all users, as a test check 2 users which get differently formatted dates.

Was this reply helpful? Yes No
Raph1 71 on at

Like
a
(0)

Report
Copy link

Link copied!

I'll keep you updated if it works, but right now I can't access said users' computer.

See you later I guess haha

Was this reply helpful? Yes No
Verified answer

Raph1 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Problem fixed. Quite unusual, but 2 of them were using the actual List and filling it in from the SharePoint instead of the PowerApps form, sorry haha.

Still, thanks for your time on this matter !
Raph1

Was this reply helpful? Yes No