Filter map points based on related table

[ElisJD]

I’m using ArcGIS Experience Builder and trying to filter a points layer using a related table.

I have a filter widget where the user selects the route number, then route operator, which filters the route table.

I’ve configured a Filter Data Records Action in the Map widget where:

• Trigger data: Route table
• Action data: Bus stop points layer
• Condition: StopCode = ATCOCode

The route table is filtering correctly, but the points on the map are not being filtered to the matching records

Is this possible in Experience Builder?

[D_Atkins]

Off the cuff, I believe we've done this by creating a Joined View Layer; Create a Joined Hosted Feature Layer View in ArcGIS Online

There are some tradeoffs here, for sure, but at a basic level, the points would then have the relevant attributes from the Related Table to attach the Filter; you might even be able to power the Feature Table from the join-view layer.

[ElisJD]

Thank you so much for this.

However, I can't have my points layer as a hosted layer. Any ideas if this is possible in this scenario?

[D_Atkins]

If you can't have a Hosted Feature Layer, then I'm assuming you're using Referenced Data from Enterprise... 

In that case you could use the RDBMS to create a joined view while still maintaining the independent feature class and related table?