Remove Default Collection Sorting

(0) Share

Report

Posted on by Jeff_VS

Hi Community

I have created below collection but it seems by default it gets sorted alphabetically. How do I keep same column order as created (i.e. Column 2, 3 and 1)?

ClearCollect(
    MyCollection,
    {
        Column2: "test2",
        Column3: "test3",
        Column1: "test1"
    }
);

Below image shows how this is currently coming up. I need this to show as Column2 | Column3 | Column1 same order as indicated above.

Note: I have used ShowColumns function to specify the order but it keeps coming back sorted alphabetically.

Any idea how to override the default collection sorting?

Thanks

Categories:

Power Platform Build Tools

All responses (2)

Answers (0)

Jeff_VS 18 on at

Like (0)

Report

Remove Default Collection Sorting

Hi @Ram

I did try that before but still same result. I actually asked Copilot and that was one of the suggestions to use ShowColumns but as I mentioned in my original post, I had tried that and it did not work.

No matter what I do It seems the end result is always that collection will be sorted alphabetically.

Any other idea?

Thanks

Jeff
Suggested answer

Ram Prakash 5,289 Super User 2025 Season 1 on at

Like (0)

Report

Remove Default Collection Sorting

Hi,

Try Storing the Values in a Collection first then try like below

ClearCollect(
CollectionDuplicate,
ShowColumns(
MyCollection,
"Column2",
"Column3",
"Column1"
)
);