This maybe not be possible but trying anyway. I have a Map Service with geometry features published. Two of the columns are 'Zone1' and 'Zone2' with values like 'ABC' or 'DEF'. The values of 'ABC' or 'DEF' can be present in both columns in the same row.
There is also a static 'lookup table' with a column named ZONECLASS and values like 'ABC' or 'DEF'. The static table is also published as layer in the along with the layer with geometry. So far so good.
What I am trying to do is that inside ArcGIS Online's Arcade Expression, query the static table's layer and get that data displayed inside ArcGIS Online. The query works in the browser as: