Filtering two related tables using Filter Widget and Actions
Hi - I am hoping someone can help me. I have an Experience Builder app in ArcGIS Online. The primary layer in the app is the Project layer which is related to the Nomination layer on GUID/Global ID. A nomination can have multiple projects (a project can have only one nomination). Using a filter widget, I filter the Projects table, and I would like the Nominations table to automatically filter at the same time. However, I cannot get the Nominations table to filter when the Project table filters. There is no option to action in the filter widget to filter data. I have an action setup in the Projects table - When Record selection changes -> Data -> Filter Records and connect the Projects and Nomination on GUID/Global ID. See the attached images (in the action image SNP_Phase = Projects layer and SNP_Projects = Nominations). Does anyone have any suggestions?
Many thanks!
PS. My first option for this work flow was to create a joined table using a data expression, but the table widget no longer sorts and the search option no longer works when using a data expression and the data was slow to load with the data expression despite limiting it to the records and fields that I needed and no geometry 🙁 .
