Sort Descending

(0) Share

Report

Posted on by CC-19121430-0

240

Hello,

Hope everyone is well,

Please could I have some advice on how to sort my date column within my gallery, I would like this to be Descending.

I currently have the property text input as:

Text input of Month as: Text(ThisItem.'Month found',DateTimeFormat.ShortDate)

Item Property of Gallery as: If(IsBlank(TextInput7.Text),Payroll,Filter(Payroll,(TextInput7.Text in 'Ignore if mass issue -->') || (TextInput7.Text in 'Ignore if mass issue -->2') || (TextInput7.Text in 'SAP or Workday') || (TextInput7.Text in 'Closest main cause (list can be refined - add to notes)') || (TextInput7.Text in 'Correct but unclear = where pay was correct but not understood and you see an improvement opportunity. ') || (TextInput7.Text in 'If we might need to discuss the prevention idea') || (TextInput7.Text in 'If we might need to discuss the prevention idea3') || TextInput7.Text in 'If large numbers impacted enter on one line and add volume here'))

Many thanks and Happy Christmas !

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Appy1 ,

I'm assuming you want to sort by 'Month found'?

If so, try:

Sort( If( IsBlank(TextInput7.Text), Payroll, Filter( Payroll, (TextInput7.Text in 'Ignore if mass issue -->') || (TextInput7.Text in 'Ignore if mass issue -->2') || (TextInput7.Text in 'SAP or Workday') || (TextInput7.Text in 'Closest main cause (list can be refined - add to notes)') || (TextInput7.Text in 'Correct but unclear = where pay was correct but not understood and you see an improvement opportunity. ') || (TextInput7.Text in 'If we might need to discuss the prevention idea') || (TextInput7.Text in 'If we might need to discuss the prevention idea3') || TextInput7.Text in 'If large numbers impacted enter on one line and add volume here' ) ), 'Month found', Descending )

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (1)

Report

Thank you! that worked perfectly 🙂

Was this reply helpful? Yes No