I am am working on an experience to replace some dashboards. In the dashboards I used a spatial filter from a selection in one list to apply a filter to a second list. My understanding in searching here is that this type of spatial filter isn't available in experience builder. I added a condition and it works to apply a filter but I cannot make it dynamic enough.
List 1 is a list of PMs and a polygon of territory.
List 2 is a list of Projects with footprints.
I want to filter List 2 by selection in List 1. However, the projects footprints can overlap multiple territories. So if Project A is PM ZZ's and YY's territory, if I select either one, I need to it show in Project A to show in List 2.
https://community.esri.com/t5/experience-builder-tips-and-tricks/using-one-datasource-to-filter-anot...
You can configure a List Widget so that it filters the data in another List Widget. It sounds like this could work in your case.
Thanks. I have done that but I can only filter a single attribute from the first list to a single attribute in the second. What I really need is in List 1, PM ZZ to filter a field containing the values "ZZ YY" in List 2?
Unless I didn't understand the linked article well enough. I am currently doing it with a spatial filter but linking it out to a text field would be better so a supervisor elsewhere might also filter data.
Yes, I think it would have to be a simple one-to-one correlation to make that kind of filter work.
If you have access to the Select Widget, maybe you can do something with the Spatial Selection option in there.
https://doc.arcgis.com/en/experience-builder/latest/configure-widgets/select-widget.htm
I could set it up in a one-to-one way. Just every time it happens I have to generate multiple features for the same thing. Then I am increasing my storage on AGOL as well. I am trying to make it as simple as I can.