Hello! I'm trying to create a popup in an AGOL map using an Arcade expression. The popup pulls data from a related table.
The problem I'm having is that some of the text values in the related table have an ampersand, such as 'fork & spoon', 'dog & cat', and so on. I first create a popup for the table, and data displays fine. But when I create a popup for the feature in the map and add the related content, the ampersand displays as '@#38;'.
I've tried using expressions like Replace({some_field}, "&", "amp;") and similar variations, but it seems to have no effect. If it matters, the expression for the related table includes two fields, such as Replace({some_field}, "&", "amp;") + ' ' + {other_field}.
Any ideas how to deal with this? Thanks!