Trouble displaying related table information in Near Me widget

[masslc]

We have a webmap application for permits. When you search an address, the map zooms to that point and searches cases within a buffer. The search panel will return a display of the cases within that buffer zone. When I click on a case, a list of attributes displays, not only for the original data source, but also for any related table data.

The webmap item page shows the data layers as well as all the related tables, so I know the related table information is linked correctly.

We are rebuilding this app in Experience Builder. I can get all functionality to work, but I cannot get the related table data to display. I have loaded my map and in the Data tab, it shows me all the feature layers including the related tables, however, the point, line and polygon layers are "in use" whereas the related table feature layers are categorized as "other." When I zoom to, and click on, a case in the Experience Builder, the Near me widget I have set up displays the data from the layer itself, but no related table information displays. 

I have created a workaround which consists of working in the web map itself. In the pop-ups, I have added each related table. This shows the related table data but rather than just displaying immediately under the feature layer information as a list, you have to click on a button for each related table's data to view it. There are lots of related tables, so we want to view all information as a list rather than have to click on 1-20 buttons to look at each tables information individually. 

Does anyone know how to get related tables to display in Experience Builder the way we would like it to?

[AlixVezina]

@masslc Maybe this will be helpful - and I am assuming you are in ArcGIS Online or a recent version of Enterprise > you can configure message action based on selected features to select or filter related records.

Here's an example: in this map I have a layer of Tree points, and a related table for inspections. In the Map widget (or any other widget that supports selecting features), I can setup a "Record selection change" message action to select or filter the related records associated to a Tree point I selected.

In my example, this will filter out the inspection records in a Table widget. You could have multiple related layers listed within the same table, or have separate tables for each. There are also other widgets that can display lists for records that you could use to represent the information.

[masslc]

Hello @AlixVezina , thanks for your reply! I have a couple of follow up questions about this while I'm trying it out. First, Are you adding any kind of message or action to the table widget to filter out that data, or is all the filtering happening through the Map actions you have set up?

Second, would this filtering also work if I wanted to display the data in the Near Me widget? I have messed around a little with this but cannot seem to get it to work. It will show a table of data representative of the point itself, but no related information directly under that. 

Thank you again!

[AlixVezina]

Are you adding any kind of message or action to the table widget to filter out that data, or is all the filtering happening through the Map actions you have set up

This is a message action configured at the Map level. You need to configure the message action in the widget where the trigger (e.g. a selection) occurs. So in my example, when I select a feature (tree point) on the map, the action is that it will filter the data in the targeted layer (related inspection record). The message action is only configured in the Map widget and filters the targeted data source (which may be displayed in many widgets along with the Table).

would this filtering also work if I wanted to display the data in the Near Me widget

The Near Me widget cannot display data from table layers; it requires feature layers (with geometries).