Alphabetically sorting Tables in the Contents Pane

Bsmith_DPW

I know that you can sort layers in the table of contents, but this approach doesn't sort tables.  I have lots of standalone tables, and if they get knocked out of order for any reason, it is very time consuming to drag and drop to reorder them.  The following script seems to do the trick, and sorts all standalone tables in a new group in the TOC.  I'm posting here to help anyone who has a similar problem, and to see if anyone else has a better approach.

# get active map in current project
p = arcpy.mp.ArcGISProject("CURRENT")
m = p.activeMap

# sort table names
sortedtables = sorted([t.name for t in m.listTables()])

# create new group
g = m.createGroupLayer("Sorted Tables")

# for each table, add to group and remove the original
for x in sortedtables:
    t = m.listTables(x)[0]
    m.addTableToGroup(g,t)
    m.removeTable(t)

 

Clubdebambos

Thank for posting @BrennanSmith1 

Here is an alternative, not a perfect alternative but another option using the CIM.

This will not update while the APRX is open, if you run in an open CURRENT project you will need to close and reopen. If you run in a standalone script, one you reopen the APRX the layers are sorted.

import arcpy

## access the aPRX
aprx_path = "path/to/your.aprx"
aprx = arcpy.mp.ArcGISProject(aprx_path)

## access the Map
m = aprx.listMaps("Map")[0]

## get the CIM definition
m_cim = m.getDefinition("V3")

## current order
##for tbl in m_cim.standaloneTables:
##    print(tbl)

## sort
m_cim.standaloneTables = sorted(m_cim.standaloneTables)

## set new definition
m.setDefinition(m_cim)

## open aprx and see the change.