Format date column in Modern Controls Table

(1) Share

Report

Posted on by WebPortal

2,295

Hello all,

How to format a date column in a table?

Basically, I don't need the time. The data source is a Dataverse table with a "date" type.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

MK-04030856-0 on at

Like (3)

Report

Does the column in Dataverse include the time?

Anyway, you could give this a try. Seems to solve the issue.

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (1)

Report

The column is date only.

As you may see, the only available properties of the control are the following:

Was this reply helpful? Yes No
KF-19091006-0 16 on at

Like (1)

Report

I'm having the same problem right now. I'm displaying a Sharepoint list in the modern controls table and would like to format the date in a column. Is there already a solution?

Was this reply helpful? Yes No
nicholaslim1 16 on at

Like (1)

Report

facing a similar issue with Modern Tables. Using SharePointlist as the data source and would like to change to dd/mm/yyyy instead of the default mm/dd/yyyy.

In my SharePoint list its configured to Australia region, dd/mm/yyyy.

Was this reply helpful? Yes No
MauroCoffetti 6 on at

Like (4)

Report

Hello,
I found this solution.
Change the table Items property adding a column to the source (use AddColumns function).
Define the value of the new column appling, to the original date column, the date format you prefer (in my case Italian)

AddColumns(
'SourceTableName',
CreatedFormatted, //name of the new column
Text(Created,DateTimeFormat.ShortDate,"it-IT")
)

Than in the Table fields selection select the new column (CreatedFormatted) instead the original one (Created)

Was this reply helpful? Yes No
Suggested answer

ThePowerPlat 2 on at

Like (1)

Report

So, I had the same issue.

After trying above, I believe I have a better answer.

Using SharePoint list, I have created a calculated column on the source itself(my app is using SharePoint as the backend).

The calculated item (CreatedDateCalculated) has the following formula

=TEXT([Created], "dd/MM/yyyy")

Now all I need to do is use the new item in our app and the table displays the data correctly.

Was this reply helpful? Yes No