SortByColumns not working with "Created" column for one SP list

Like (0) Share

Report

Posted on 18 Jan 2024 10:27:51 by romankorchak2

125

Hi All

I have a strange issue where SortByColumns gives blank collection if used with "Created" column
SortByColumns(MySPlist, "Created", SortOrder.Descending) - gives blank collection

but it works with other columns, like ID

SortByColumns(MySPlist, "ID", SortOrder.Descending) - gives collection with lots of items

And it only happens with one particular SharePoint list

Any idea why it could be happening?

Thanks

Categories:

Power Platform Build Tools

All responses (3)

Answers (0)

DJ_Jamba 2,828 Super User 2025 Season 2 on 05 Mar 2024 at 17:59:44

Like (0)

Report

Re: SortByColumns not working with "Created" column for one SP list

Have you tried just using Sort instead of SortByColumns?
romankorchak2 125 on 23 Jan 2024 at 14:55:53

Like (0)

Report

Re: SortByColumns not working with "Created" column for one SP list

Sorting collection does work, but I still need to filter the list as its bigger then 2000 items and filter needs to be editable by the user
Authoring version is 3.24012.8
v-mengmli-msft on 19 Jan 2024 at 01:41:22

Like (0)

Report

Re: SortByColumns not working with "Created" column for one SP list

Hi @romankorchak2 ,

Have you ever tried copying the List into a collection and then sorting it? What's your version number?

Best regards,
Rimmon