Answered

Modern Table Change date format

(1) Share

Report

Posted on by GT-05111229-0

I have a power app connected to MS list which shows dates in DD/MM/YYYY. Within power apps i select dates using date pickers. I want to be able to see my dates within the table as dd/mm/YYYY.

There are fields for DateOnlyFormat and DateTimeFormat where you can change to None, ShortDateTime and ShortDate.

Copiltot suggested using this but hasnt worked

Text('PowerAppsOneGrid.DateOnlyFormat', "dd/mm/yyyy")

Any ideas if it is possible to change the date format presented in the table?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

The table generally picks up whatever your browser or device settings are.

To change them in Modern table, you might need to update your data first.

So, you will use addcolumns command to format your date field to the type that you want and then display in the table control.

Hope this helps.

Cheers!

Was this reply helpful? Yes No
GT-05111229-0 39 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply. I am not sure if i understand what I need to do, is that in power apps or SharePoint? My problem is in PowerApps

Below is example of my modern table in power apps. as you can see the dates are in mm/dd/yyyy

My MS list where i connect to is shown in dd/mm/yyyy

I have tried changing the format here but didnt work either. Any

Was this reply helpful? Yes No
Verified answer

timl 36,774 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi GT-05111229-0

At present, the modern table control doesn't appear to support date formats other than mm/dd/yyyy. My browser language is setup for UK and the control doesn't apply the dd/mm/yyyy format.

The workaround is to modify the Items property of your table control and to add formatted columns by calling the AddColumn function. The syntax would look like this.

AddColumns( YourSharePointList, EngagmentDateFormatted, Text(EngagmentDate, "dd/mm/yyyy", AdvertDateFormatted, Text(AdvertDate, "dd/mm/yyyy" )

You can then go to the Fields section of the table control editor add these XXXFormatted columns.

Was this reply helpful? Yes No
CU10020901-0 2 on at

Like (0)

Report
Copy link

Link copied!

Have you found a solution yet?

Was this reply helpful? Yes No