Need to symbolize feature layer by attribute in related table

Question

I have a parcels feature layer and a related table with info (such as sales, property use, etc).  I need to symbolize the parcels layer by attributes in the related table. I tried using a view and symbolizing it and this works great, until I want to publish it to Enterprise Portal as referenced registered data.  Apparently views can only be published as hosted feature layers.  This is a problem as my parcel layer is constantly being updated and would require constant overwriting of the hosted feature layer.

I also tried Arcade expressions "FeatureSetBy" to access the related table features, but this function is not available in symbology (only popups and labeling).  ESRI gives some reason like performance issues for not having this available.

So my question: Does anyone know a workaround so I can symbolize this from the related table and publish as "referenced registered data" ??

I've looked into "representations" but Cannot figure that out (if you think this would work can you point me to some help pages?)

AriLukas · Answer

My "Current Lexington building Structures" is our live and current building structure feature layer that resides in our enterprise sde.  After re-reading your post, you would need to publish your parcel and related table as a hosted feature layer and create a hosted view while on your portal. If you are using the related table for all your symbology settings you  would need to Truncate/Delete table of hosted layer and Append newly updated info to the now empty hosted table. Once the hosted table has had the new info Appended to it, it will all feed down to the view.

You may not actually even need to create a view if you use workflow I described above. You may just be able to work directly on hosted layer and not have to worry about your symbology be messed up because you aren't technically overwriting the layer

AngelaSchirck · Answer

One quick question.  Is your "current lexington building structures" a view or the actual building footprint layer?  If I use my parcels layer there, the info I need is not in it, but the related table.  In order for all the attributes in my hosted view to be populated, should I do it from the view I created in pro?

Thanks

AngelaSchirck · Answer

Thanks, I'll give that a try.