Filtering Shapefile Using Inputs from .csv

[StickyNoteEnthusiast]

In ExB, I am trying to create a filter/query based on a relatively simple concept but cannot figure it out.

What I wish to do is:

1. Create a filter/query with inputs (populates the options that the user can select) that are based on a .csv file. For example: "A", "B", "C".

2. Have the records in a webmap embedded in the ExB filtered based on if the selected inputs from the filter/query are CONTAINED (aka in) any of the records of the shapefile. For example, if the user picked "A" and "C" from the filter (which is based on the inputs of the .csv), and the shapefile contained the following records: {"A, "C"}, {"D", "E", "F"}, {"A", "E", "F"}, then the 1st and 3rd records would be chosen and the second record would be filtered out/not selected.

I cannot create a traditional "connection" between the filter and webmap because the records are not a 1:1 match between the selected .csv inputs in a UID field and the webmap because they inputs would be CONTAINED within the shapefile records that are lists; I need the shapefile records to be filtered based on if any of the selected .csv inputs are contained within a field in the shapefile. I cannot create the filter/query based on inputs of the shapefile because they do not have singular options for each input available, because each record is a list of multiple objects as shown above.

[DanJiang]

Hi @StickyNoteEnthusiast , I am afraid that many-to-many relationship can be achieved in ExB only through the related data. Here are some references. 

Related data configuration in Pro: https://pro.arcgis.com/en/pro-app/3.3/help/data/tables/joins-and-relates.htm#ESRI_SECTION1_2538FFE72...

Related data relationship in ExB message action: https://doc.arcgis.com/en/experience-builder/latest/configure-widgets/action-triggers.htm#ESRI_SECTI... 

Thanks, 

Dan