web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sorting by calculated ...

Power Apps

Unanswered

Sorting by calculated text column not accurate

(0) Share

Report

Report

Posted on by Schwartz_Cory

184

Hi,

I have a calculated text column called MeasureID that does not sort correctly (see screenshot)

Can someone explain how I can fix this?

For context, the Calculated MeasureID column is using this function:

Concat(at_strategicpillar.at_pillarnumber, ".", at_measurenumber)

aka: it concatenates the pillarnumber from the strategicpillar lookup column + a period + the measure number for the current item.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

Anchov 1,986 on at

Like
a
(0)

Report
Copy link

Link copied!
have you tried converting your string to a value, then sorting as a number?
Value(Concat(at_strategicpillar.at_pillarnumber, ".", at_measurenumber))
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
Schwartz_Cory 184 on at

Like
a
(0)

Report
Copy link

Link copied!
The Value function does not work for calculated columns in dataverse

However, I was able to create a decimal column called M-ID using this function
at_strategicpillar.at_pillarnumber + (at_measurenumber/10)
and I am still getting the same results (see below)

Was this reply helpful? Yes No
Anchov 1,986 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, I missed the part that this was Dataverse, and not power apps.

Was this reply helpful? Yes No
Schwartz_Cory 184 on at

Like
a
(0)

Report
Copy link

Link copied!
The Sorting is for the Power App, I was able to fix it inside of powerapps using this Sort function:

Sort(MyTable,Value(MeasureID))
Wrapping it around a Value() fixes it inside of power apps, but now I have a delegation issue. Any ideas to fix the delegation issue?

Was this reply helpful? Yes No

Join the conversation