SharePoint calculated date column showing incorrect format in Power Apps customized form

(1) Share

Report

Posted on by TrayH

383

I have an old InfoPath form that I'm redesigning as a SharePoint form customized in Power Apps. This list has several calculated columns of type date and time, which are being used to calculate the date based on the value of another field plus a set number of days. While the calculations are working, I've noticed that within the Power Apps form these calculated columns show up as 2025-11-28T06:00:00Z rather than 2025-11-28. I'm trying to figure out if there's a way to get these to show up in the friendlier format without needing to create new columns and perform the calculations within Power Apps rather than use the SP calculated columns.

Using this field as an example, here is how the calculated column is setup in SharePoint:

And here is how it appears in the Power Apps form:

My goal in this example would be for it to only show 2025-11-28, without the T06:00:00Z that follows it. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

TrayH 383 on at

Like (2)

Report
I figured it out. I had to set the Default property of the calculated column's data card in Power Apps to the following:

DateValue(Left(Text(DateTimeValue(Text(ThisItem.'Calc - Filing Limit Date (DoS+1y90d)')),DateTimeZone.UTC),10))

That results in it showing up like this in the form:

1 people found this reply helpful.

Was this reply helpful? Yes No