Date format in PowerApps Gallery

[Doddy83]

Hi Everyone,

I'm trying to get the Date to display exactly as it is on the SharePoint list it's being pulled from. In the SP list it's displaying as 26/06/2020, however when this is pulled through into the PA Gallery, it's displaying it as 2020-06-26T10:19:46Z. The list column is Date & Time but set to Date only and displays fine in the list, however I can’t get it to display the same in the Gallery.

Should also probably note as it may or may not be relevant, the Close_Out_Date column is calculated from another selection (Risk_Rating) the user makes, so it adds 30, 60, or 90 days to the created date using the following:

=IF(Risk_Rating="Low",Created+90,IF(Risk_Rating="Medium",Created+60,IF(Risk_Rating="High",Created+30,Created)))

The current Text formula in PA is: ThisItem.Close_Out_Date (Close_Out_Date being the column name)

I've also tried: Text(ThisItem.Close_Out_Date, "[$-en-GB]dd/mm/yyyy") This doesn’t error either but brings back the same results.

 What am I doing wrong here? Any help would be much appreciated.

[mdevaney · Accepted solution]

@Doddy83 
Calculated columns are already stored as Text so converting them using the Text function won't work by itself.  You will need to use the DATEVALUE function to convert the Text to Date so you can reformat it.

Text(DateValue(ThisItem.Close_Out_Date, "en"), "[$-en-GB]dd/mm/yyyy")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Doddy83]

Thank you so much!! Works a treat!

[Gilmour]

I have a SharePoint list with date fields in the European format d/m/yyyy. The site the list is in is set to Locale: Italy. My PowerApps gallery receiving data from the list displays dates in the US format. If I use the "Text" formula (like the ones shown in this blog), the dates change to completely different ones... years off, and become unusable for calculations (i.e. DateDiff). Can anyone help?

[RatanKP]

Any Solution for the above issue, am also facing the same issue

[RatanKP]

Any Solution for this issue, am also facing the same issue

[DataGuyMSIS]

This fix no longer works in 2024.