web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Sorting Issue that inv...
Power Apps
Unanswered

Sorting Issue that involved using number in a text-based column

(0) ShareShare
ReportReport
Posted on by cferv_77 71

Hello,

 

My PowerApp is connected to a list where I am using the Title column as an ID column (yeah, bad idea) by auto-generating the incrementing number (1, 2, ...9, 10, 11). However because the Title column is a text column the order is not right (1, 10, 11, 2, 3, ... ). I was  wondering if there is a way to convert/display the column as an integer type on PowerApp (frontend) and sort it correctly.

 

The sort icon is using this code: UpdateContext({SortDescending1: !SortDescending1}) 

I tried tweaking with it but no luck. 

 

Any help would be greatly appreciated. Please and thank you. 

Categories:
Building Power Apps
I have the same question (0)
  • Ethan_009 Profile Picture
    Ethan_009 4,838 Moderator on at

    Hi @cferv_77 ,

     

    Convert text to number using Value() function

    For example: 

    Value(Title) will convert "1" -> 1 

     

    Use this in your Sort function.

     

    Hope this helps

  • cferv_77 Profile Picture
    cferv_77 71 on at

    Hello @Ethan_R 

    It does not work with Sort(). I tried to add a calculated column based on the Title using VALUE() to the list, and using that column name ("NumOrd") in the PowerApp. However I am getting a Delegation warning when I update the formula to use that column instead within the BrowseGallery. x.x

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 294 Most Valuable Professional

#2
11manish Profile Picture

11manish 210

#3
Valantis Profile Picture

Valantis 169

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans