
I have a date field in powerapps with backend as SharePoint list. The date is being shown in gallery using the below formula.
If(
ThisItem.Date_Posted = ThisItem.Modified_Date,
DateAdd(
ThisItem.Date_Posted,
0,
TimeUnit.Hours
),
(DateAdd(
ThisItem.Modified_Date,
0,
TimeUnit.Hours
) )
)
For some users, when they access the powerapp in Desktop, it shows dates as MM/DD/YYYY format whereas for all other users, it shows up in DD/MM/YYYY format which is the expected format. May I know how can I show the same format across all users?
A few things control dates:
1. Set Format using Text(control, "DD/MM/YYYY")
2. Location settings set up in MSO365 account
3. By Auto-Detection language in the browser (Chrom is a pain for that it will change date format in apps not matter what if You have wrong region set up)
To ensure all dates show correctly, all users need to set up their own Location and Date settings, as in most cases Auto-Detection language future of a browser will overwrite Your set date formats in the app.
Double-check with affected users if they set up an MS365 account with the correct location. Also, if they use Chrome, it's important to set it to the right region.
If users use Power Apps App, MS365 account settings are essential and when they use an in-browser to use App, not only MS365 account settings matter but also Browser Settings.
Hope that helps