I have a cemetery dataset with lots (polygon feature). These lots have a related table of people buried in the lots. There could be many people in one lot. (one to many relation). I can query a lot, select and zoom to a lot by querying the lot data. I can query related data but cannot zoom to the lot associated to the related data.
I can Flash and Filter the feature on the map via the related data but cannot zoom to it ( even though the actions available in the Actions Tab are Export, Stats, Set filter, pan to, show on map, and Zoom to )
In Experience Builder, you can use Data Actions between layers to select / filter other layers based on a query or selection, but you're correct, you cannot zoom to it, as the geometry information is not on the "action" layer (the people).
The only way to really accomplish this in EB is to create a joined layer that includes the lot information / geometry as part of the related table, which is an awful lot of trouble just to get one thing to work.
What about a Dashboard? With a Data Expression, you can include the geometry in the related table on the fly, no bothering with republishing anything or making joins.
Yes, It appears that the Zoom functionality for related data in Query, that was once available in Web App Builder, is not in Experience Builder. It seems like zoom to would be an important feature to include since the software in mainly used to view data on a map.
If you deploy the Esri cemetery management solution it will automatically give you layers that can be used for labels.query that has info from the related tables.