I'm currently using ArcGIS Pro 2.9.3 and have set up a Map Series in one of my Layout tabs. I have also set up a Dynamic Text box that presents a list of attributes for each of the polygons that are present within each Map Series page. This way, each Map Series page will produce a separate map that focuses on an area of interest of my choosing. The Dynamic Text has a Query that lists "visible rows" and accurately lists the attributes of the polygons in question separated by a comma (e.g. " ,"). However, the entries (which are integer numbers) are listed in order of OBJECTID.
I'm curious: is there a way to sort the values within the Dynamic Text (or within a Table Frame to link to the Dynamic Frame text box) so that the values are sorted from smallest to largest? I expect that I could produce a new shapefile with the polygons in the "correct" order, but I wanted to see if there was an Arcade expression that might complete the task for this project and for others in the future.
