Announcements
Dear All,
i have a drop down that contain a data that i want to set them on sequence of small to large amount:
here is and example:
data in drop down:
apple - 20
apple - 10
apple - 7
i could not do it as :
because in excel it starts with a word so can not do good sequence of the numbers. any ideas on how to do that in power app?
Please can you show a sample of the Table.
Also what is your current code on your dropdown
------------If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Hi @Anonymous add a collection with another column and have the nuber to that column as
ClearCollect(NewCollection,(AddColumns(YourTable, "Total",Value(Trim(Mid(NameOfColumn, Find("-",NameOfColumn)+1,4))))))
This will give you
hope this helps
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 234 Super User 2026 Season 2
WarrenBelz 207 Most Valuable Professional
Mohsin Ali 169