You’re offline. This is a read only version of the page.
Announcements
379
I have created an additional column in my sharepoint list named Age, this column is a calculated column that needs to show the Age (days) how old a purchase is and this is based upon the order date. The formula that I used is this:
=DATEVALUE(TEXT(NOW(),"mm/dd/yyyy"))-DATEVALUE(TEXT([Order Date],"mm/dd/yyyy"))
In my SharePoint list the Age is showing the correct number of days, in addition, the sorting works perfectly, but when I add this new column to my Datatable in my power apps application that column is not showing correctly, this is how it is formatted:
I also noticed that when I expect the data type for the Age column that it is being listed with data type string:
I have tried refreshing the data source but no success with that, I really have no idea why the Age column is not showing up in the correct format?? Any help is appreciated!
Hi @Lorem1960 ,
I will give you a bit of advice (if you will accept it) - SharePoint calculated columns are for SharePoint and do not play well with Power Apps - do the calculation in Power Apps (in a label if you like, but better the Default of a control).
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Share
Report
All responses (
Answers (
