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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Option set choice diso...
Power Apps
Unanswered

Option set choice disorder after importing

(0) ShareShare
ReportReport
Posted on by 14

Hi, Everyone,

 

I have a problem with an option set type of column in a table where I ordered the option set choices in an exact way in the classic interface of the solution.  After I import the solution into another environment as managed, the order is off and since it's managed, not possible to rearrange it.  We think possibly there's an unmanaged layer of customization on the table that's preventing the ordered set to display, but checking out the solution layers of the table doesn't show managed/unmanaged, and has no way of removing the unmanaged layer like for an app.  Anyway possible we can fix this relatively painlessly?

 

I've considered removing a managed component in Update a solution - Power Apps | Microsoft Docs

which is more like deleting the managed solution entirely since we can only delete a column but not remove it from the solution temporarily to add it back.  I've considered manipulating the order in the Power App but don't know if there's a way to SortByColumns with custom sort on an option set (mainly I don't know if there's a way to reference the column to sort as a string), like so

SortByColumns(Choices(Table.'Option set').Value, "string name for the aforementioned column", ["sort item 1", "sort item 2"])

Unfortunately, the order we want isn't any ascending or descending order, otherwise we would just use Sort

 

Appreciate your thoughts!  Preferably on fixing the solution, or manipulating option set choice order in the app barring that

I have the same question (0)

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 836 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 231 Super User 2025 Season 2

Last 30 days Overall leaderboard