Primary Column Sorting (When a Number as Text)

(0) Share

Report

Posted on by RJF61

1,265

I have a Primary Column (text) for a vehicle fleet that contains a number. With record entry, I see...

Is there a way to sort the Primary column by the numeric content?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@RJF61 - You can wrap the Primary Name column with a non-delegable Value function. For example:

Sort( 'Your Data', Value('Primary NameColumn'), SortOrder.Ascending )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report

@Amik Thanks for the response. I assume this would occur in a Power App and not the Dataverse table?

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi @RJF61 ,

Sorting with text fields are incorrect though,
I suggest you create a new Field that will hold numeric values of the text field.

Then you can sort with respect to that field.

Hope this helps

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

Correct. As explained in the other thread, a Primary Name column can either be Text or Auto-Number.

@Ethan_R - this is regarding Dataverse.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report

Yes @Amik ,

That's why the suggestion of having a numeric field makes sense.
As per below Image, I had to create a sequence number to show proper sorting, since string sorting doesn't work properly. As string (red) will consider 1 -> 10 -> 2 than the numeric (blue) 1 -> 2 -> 10

Hope this helps

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@Ethan_R - ok I misunderstood you before. Makes sense to me

Was this reply helpful? Yes No