Share
Report
14Hi, 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
All responses (
Answers (
