Hello Xander Bakker and other Arcade gurus,
I have had a lot of success with Arcade returning lists from tables where a relationship class exists -- thank you Xander for your excellent documentation! I now have a stand-alone table that I would like to search using a drawing number retrieved from a feature layer. If the drawing number exists in the table of restricted records, the feature layer popup (e.g. pump station, water main, etc.) will have a expression returning Yes (for restricted record). If the drawing number is not found the expression will return No.
I've have tried changing the name of the table and using $datasource and $map. The original table was published from an XLSX to ArcGIS Online using ArcGIS Pro 2.5. I subsequently created a view using the Create View Layer option. I have tried changing the name as well as using double quotes and single quotes. I always get an execution error where the identifier cannot be found with the expression associated with the feature layer. There is no problem when I apply this variable to an expression for the actual table.
The feature layers are in a hosted service on our Portal Instance. At the moment it is not feasible to recreate the REST services to include an attribute for restricted record for every endpoint.