PowerApps Sorting

(0) Share

Report

Posted on by LU-06011735-0

I have a dashboard of my team's work orders that I'm populating from a SharePoint list. I'd like the items to sort based on the Work orders that are upcoming but the sort by date does not work correctly. I also tried adding a field that calculates the number of days before the work orders are due, but I can't filter based on those fields.The items are being pulled from an oracle database. I've attached screenshots of the code if anyone can assist.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

abc 123 789 Moderator on at

Like (0)

Report
Copy link

Link copied!

Dates are just strings, so sorting is going to be an Alphanumeric Sort. Consider creating a column formatted as YYYY/MM/DD HH:MM:nn such that the sort behaves better.

Was this reply helpful? Yes No
Suggested answer

Mark Nanneman 991 Moderator on at

Like (0)

Report
Copy link

Link copied!

Could you provide more details about your "Scheduled Start" column? Could you show it in SharePoint? Is it a Date/Time column or Text?
Also, where are the dates coming from? I notice that almost all of them are the same date and set very far in the future. Same with your "Due in" days calculated column. They're almost all due in 8935 days.

The SortByColumns might be working, it's just that the dates are all the same so you don't notice it.

Was this reply helpful? Yes No
LU-06011735-0 2 on at

Like (0)

Report
Copy link

Link copied!

@Mark Nanneman I'm pulling data from a read only oracle database to a SharePoint list. PowerApps is using the SharePoint list since I can't right to the oracle database. This is what I used for the "date due"

Was this reply helpful? Yes No