cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
golfnutt82
Super User
Super User

Power App Date Field Not displaying the Date Correctly

I have a custom calculated field in SharePoint that populates the date.
The data type I am using is Date/Time

golfnutt82_0-1663349827587.png

When looking at the list, the output looks correct.

golfnutt82_1-1663350012063.png

But when I look at this on my Power App - Edit Form it looks as follows.

golfnutt82_2-1663350117041.png

Any ideas? 

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@golfnutt82 

PowerApps does not handle SharePoint calculated columns well.  My suggestion is to do the calculation in PowerApps and save it to a date and time type of column in SharePoint. 

View solution in original post

2 REPLIES 2
Drrickryp
Super User
Super User

@golfnutt82 

PowerApps does not handle SharePoint calculated columns well.  My suggestion is to do the calculation in PowerApps and save it to a date and time type of column in SharePoint. 

I wound up adding and hiding the "Month Count" field to reference along with the "Last Calibration" date field.
I used the below formula and it works.
If(DataCardValue9,Date(Year(DataCardValue14)+Sum(DataCardValue9/12),Month(DataCardValue14),Day(DataCardValue14)),Date(Year(DataCardValue14),Month(DataCardValue14)+DataCardValue9,Day(DataCardValue14)))
The only issue is handling a field that has a month count of 0 because that returns a Calibration Due Date of 12/31/1899

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,785)