PowerApps - Formatting Date columns in PowerApps Data Tables

When displaying a Data Table in a PowerApps form overlaying a SharePoint list, you may have noticed that Date Fields display in US format by default, e.g.,

So how do we display in UK format, e.g., dd/mm/yy? Easy! In your PowerApps Data Table control, select your Date Column in the Tree View, and in the Formula Box at the top, note the formula displayed, e.g.,

... simply update this Formula as follows:

e.g., Text(ThisItem.'Early Start Date',"dd/mm/yy")

Publish your App et voilà! Your dates are now in UK format!

59 views0 comments