Related post by @DougBrowning that prompted this: https://community.esri.com/t5/arcgis-pro-questions/pro-3-5-5-broke-all-our-arcade-datastore-calls/m-p/1685167
Please add $datastore (and $map) into the Layout Profile in Arcade. This allows the cartographer to create dynamic expressions drawing on multiple tables in things like dynamic text.
As the linked post notes, this functionality, although not officially supported, was present and functional up until version 3.5. Until that time, people built templates and workflows around the use of $datastore.
Please add $datastore and $map to the Layout Profile.