Existing functionality: Currently, when you insert an "Table Attribute" dynamic text element into a layout in ArcGIS Pro, you set the input source to a table (layer) in a single map frame.
IDEA: Add an expression option to the "Table" parameter so that Arcade can be used to generate a new or modified input table based on multiple map layers/tables.
USE CASE: I have many scenarios come up in my map production where we try to minimise the amount of manual input required by our users over elements in the layout. This feature would hopefully enable us to perform an intersect between 2 layers in the map, so that a focus feature set by a definition query or map series (e.g. a Plantation) can be used to select one or multiple intersecting features from another layer (e.g. Local Government Authority) to then display on the layout. In the image below, it would return only feature "P" instead of all features (A-Z) or all visible features (A,M,P & Z) from the grey layer.
This would open up more possibilities than simply adding in another option to the Query parameter (e.g. a "Search Table" option with distance settings) that could be used to find features in the "Table" that are within X of the "Search" table, but I've listed that as a separate idea as well (potentially 'simpler' option to implement?) Include "Search Table" option for 'Table Attribute... - Esri Community
