Sort on Collection not working

(0) Share

Report

Posted on by caharland

Hi All,

As per the title I am trying to sort a collection by a date column before sorting but it isn't working:

This is my code:

 Sort
        (
        ClearCollect
            (  coll_Payment_Temporary,
                    
                    ShowColumns
                    ( Payments_1,
                    'Pay Date', Amount, 'Declared Craig', 'Declared Debbie', 'Payment Reference', GUID,  'Payment Currency'
                    )
            ),
             cref3_paydate, SortOrder.Descending    
            
        );

And this is the collection contents after running the code (2nd of October is above 4th of October and so on, )

The only thing that occurs to me, is that the sort is thrown out by the use of the ShowColumns function? 

Hopefully, one of you bright sparks can help 😊

Best Regards, Craig

Categories:

Power Apps Pro Dev & ISV

All responses (4)

Answers (0)

Sort by

Suggested answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey

can u try this modification:

Sort( ClearCollect( coll_Payment_Temporary, ShowColumns( Payments_1, 'Pay Date', Amount, 'Declared Craig', 'Declared Debbie', 'Payment Reference', GUID, 'Payment Currency' ) ), DateValue(cref3_paydate), SortOrder.Descending );

if it helped please mark as verified answer,

cheers
caharland 94 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi mmbr1606,

Thank you for your reply. Unfortunately, the results are unchanged.

Kind Regards, Craig
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for trying

Can u give this a shot:

Sort(

ClearCollect(

coll_Payment_Temporary,

ShowColumns(

Payments_1,

'Pay Date', Amount, 'Declared Craig', 'Declared Debbie', 'Payment Reference', GUID, 'Payment Currency'

)

),

DateValue(Text(cref3_paydate, "[$-en-US]mm/dd/yyyy")), SortOrder.Descending

);

Cheers
Craig1 110 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi mmbr1606,

Thank you for your reply. Unfortunately, I'm still getting exactly the same results.

Kind Regards, Craig