Filtering two related tables using Filter Widget and Actions

[LJackson29]

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  🙁 . 

[JasonBOCQUET · Accepted solution]

Hi @LJackson29 ur front of a big problem in experience builder : there is no way to made dynamic action between two different sources linked by a globalID by using filters.

I've writed an idea to submit a change about this : https://community.esri.com/t5/arcgis-experience-builder-ideas/improve-filter-widget-to-bring-more-dy... 

Actually to avoid this problem the "best" solution is the following : add the collumn that you want to filter on your source 1 in the source 2 data table and use group filters to filter both source in the same time. 

[LJackson29]

@JasonBOCQUET Thanks for this confirmation - so frustrating. I will give a thumbs up to your idea.