I have a custom calculated field in SharePoint that populates the date.
The data type I am using is Date/Time
When looking at the list, the output looks correct.
But when I look at this on my Power App - Edit Form it looks as follows.
Any ideas?
Solved! Go to Solution.
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.
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
User | Count |
---|---|
258 | |
110 | |
97 | |
57 | |
39 |