Time Zones for Apps

(1) Share

Report

Posted on by ctedesco3307

847

Using lastUpdatedby as an example ... it shows as 1:48 PM - The system job ran at 8:48 AM... how Do i get the times to sync up? Column is set to user local

The correct time shows in the table column - (job runs every hour) just not on the form

Categories:

Building Power Apps

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Fredrik_A 3,644 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Try this:

Text(DateTimeValue(ThisItem.lastUpdatedBy), "[$-en-US]hh:mm AM/PM")

If my response solved your issue, please mark it as ✅ Accepted Answer and give it a like.

Was this reply helpful? Yes No
ctedesco3307 847 on at

Like (1)

Report
Copy link

Link copied!

@Fredrik_A Its a set value that displays - not a text label - this is a model driven app - thank you for replying though

Was this reply helpful? Yes No
Suggested answer

Valantis 5,118 on at

Like (1)

Report
Copy link

Link copied!
Hi @ctedesco3307,

The different time is caused by time zone conversion. Dataverse stores DateTime in UTC and “User local” fields use the user’s Dataverse time zone on model-driven forms, while canvas apps/custom controls may use the browser time zone.

Try this to align the times:

In Dynamics/Power Apps, set Personal Options > General > Time zone to your local time.

Ensure the form uses the same “Last updated/Date last calculated” column and its Time zone adjustment is User local.

If it’s a canvas app or uses custom JS/PCF, remove extra conversion or normalize the display (e.g., DateAdd/TimeZoneInformation) to show the Dataverse user time.

After this, the form time should match the grid/system job timestamp.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

Was this reply helpful? Yes No
ctedesco3307 847 on at

Like (1)

Report
Copy link

Link copied!

@Valantis Thank you for replying but This is a model driven app. The column is already set to User Local. This a roll up column value - I can't change anything - see screen shots above the FORM is the only object that is displaying it in UTC the table column and system jobs show it correctly.

Was this reply helpful? Yes No
Suggested answer

11manish 2,265 on at

Like (1)

Report
Copy link

Link copied!
In view of this situation, it is necessary to modify the behavior of the column.

Set the column to:

Time zone adjustment = Time zone independent

Then the time will show exactly as stored, with no conversion.

Example:

Stored: 08:48
Displayed: 08:48

Only possible when creating the column.
After data exists, behavior usually cannot be changed.

Keep User Local (Best for business fields)

Use when time should reflect the user's location, e.g.:

Appointment time

Customer meeting

Service schedule

Then the current behavior is correct.

Microsoft Best Practice

Column Type
Recommended Behavior

System timestamps Time Zone Independent

User actions User Local

Business dates Date Only

Was this reply helpful? Yes No