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.