Answered

Problem with power apps table showing "000"

(0) Share

Report

Posted on by David1966

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

David1966 97 on at

Like (0)

Report
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")))

Was this reply helpful? Yes No