Sort alphabetically Sharepoint list attached filenames not ID

(0) Share

Report

Posted on by Sormick

566

Hello,

I have this formula below which sorts my items on a gallery by ID.

I need to sort them by the filenames of attached files on my sharepoint list.

Please find below my formula:

OrderedCollection = With({SortedData:Sort(ListData;ID;SortOrder.Ascending)};
Ungroup(
ForAll(Sequence(CountRows(SortedData));
{
MyRecord: Table(Index(SortedData; Value)); 
RowID: Value
});
"MyRecord"));;

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Sormick 566 on at

Like
a
(0)

Report
Copy link

Link copied!

I managed to sort by filename with this: "Title" but the issue i have is that my filenames are sorted like this:
1.jpg
10.jpg
2.jpg
20.jpg
I need to sort them like this:
1.jpg
2.jpg
3.jpg
......
Verified answer

Sormick 566 on at

Like
a
(0)

Report
Copy link

Link copied!
Finally i managed to sort my files numerically!

please find below my rectified formula:
OrderedCollection = With({SortedData:Sort(ListData;Value(Titre);SortOrder.Ascending)}; Ungroup( ForAll(Sequence(CountRows(SortedData)); { MyRecord: Table(Index(SortedData; Value)); RowID: Value }); "MyRecord"));;
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Sormick,

Thanks for your sharing.