Announcements
Hi just starting out and enjoying i trying to make a list of item that have a due day that store on a share point list i have a column that cal days remaining as in pic.
but when it loads on power apps table it look like this can some one guild me on how i can fix this.
What is your calculated column for that? You'll likely need to utilize days() or int() to return the value into a whole number since the modern table control you are using you can't change the values for each column like you can a gallery etc.
It's either that, or you will have utilize AddColumns() function around your datasource and add a column and utilize Int(). So something like AddColumns(Listdatasource,"DaysRemaining",Int('Days Remaining')) then add the DaysRemaining field to your grid. etc.
I ended up using this formula in my list column in SharePoint thanks for the help.
=IF(ISBLANK(DueDate),"",IF(DueDate<=TODAY(),TEXT(DATEDIF(DueDate,TODAY(),"D"),"-0"),TEXT(DATEDIF(TODAY(),DueDate,"D"),"0")))
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 342 Most Valuable Professional
11manish 234
Valantis 187
