Format Date Using Date Filter for Tables in Power Apps Portal

When showing the datetime field values on Portal, it’s a common requirement to show only the Date part on the portal and not to show the Time part. This post explains how to achieve that when fetching data from Dataverse ‘Datetime’ field and show only the Date part.

Requirement: Its always an issue with the format when we try to retrieve and showing date in a table in power apps portal. Default date format is “dd/MM/yyyy HH:mm”, but it is not always necessary for show the time also.So lets see how to format date in Power Apps Portal Using Liquid-Filters.

Fig.1

Step 1:  First open the portal management app from power apps and select the website you want to work on.

Step 2: Open the web template and select the webpage where the table is (if you don’t find the template of your page in web templates, just check in the page template section).

Fig.2

Step 3: Now just use the following code in the <td> where you want to show your date.

                              {{variable used to retrieve the date data | date: ‘dd-M-yyyy’}}

Fig.3

Now save the changes and sync the changes in power Apps portal, now the date will show without the time.

Fig.4

Refer for more available liquid filters:  https://learn.microsoft.com/en-us/power-apps/maker/portals/liquid/liquid-filters

Hope this helps!