Options for Displaying Labels from Multiple Rows of Data for a Single Feature in ArcGIS Online

Question

I am currently working on a project using ArcGIS Online and have come across a scenario where I need to display labels for a single feature, which has multiple rows of data associated with it. I’ve looked into using relates and relationship classes to achieve this, but I am still exploring my options and would like to know if there are any other methods or tools within ArcGIS Online that could help me out.

My primary goal is to have labels displaying information from multiple rows of data on a single feature in my map. Each label would represent data from a different row of the related table.

Does ArcGIS Online offer any options for me to do this? Or is this simply not possible in ArcGIS Online, where a single feature can have multiple rows of data attached to it, somehow, and the availability to label from one of the rows?

Bonus question: Can I style a feature by one of the rows of data I have for it in ArcGIS Online, or is this also just not a thing in Arcgis Online?

PS for info I have Arcgis Pro Basic license with no add-ons, but willing to upgrade or purchase add-ons if this can help me accomplish my goal in Arcgis Online.

AlinaTarmu_SCGIS · Answer

Well, there it is:

Function bundles | ArcGIS Arcade | ArcGIS Developers

" Warning

All FeatureSet functions are not included in rendering profiles, such as visualization and labeling, because they require querying data from a server or database. Allowing these functions in rendering profiles would severely hinder the performance of apps executing the expression.

For example, if an expression were to access data with one query within the visualization profile of a layer with 1000 features, then the expression's execution context would need to make 1,000 queries in behalf of the user."

AlinaTarmu_SCGIS · Answer

Theoretically it should be possible in Arcade, from what I could see. If I get to pull this off, will let you know.

JonJones1 · Answer

Hey! I sadly ended up giving up on this and put all my data in a single row for each object. Not ideal at all, but it's what I managed to make work. I think I might have eventually gotten it to work, but the need to get the job done versus taking all the time needed caused me to do it the way I described :( .