topic Re: Filter widget -selecting multiples values in ArcGIS Experience Builder Questions

Filter widget -selecting multiples values

JoseBarrios1 — Tue, 20 Jul 2021 15:58:27 GMT

Hello experience builder community,

Does anyone know if is possible to select multiple values on the experience builder filter widget? I know that it is possible in dashboard but I can't figure out how to do it in exp. builder. An example will be an user selecting multiple U.S. States and ethnic groups to filter a data table. Thanks for any suggestions!

Re: Filter widget -selecting multiples values

JoseBarrios1 — Tue, 20 Jul 2021 16:14:47 GMT

Well... I just figured it out! It is possible by just selecting "is any of" on the selecting sql statements.

Thanks,

Re: Filter widget -selecting multiples values

JonathanMcDougall — Tue, 20 Jul 2021 16:25:23 GMT

There's perhaps a couple of ways, some smoother than others. @JoseBarrios1

One approach; allow the user to select the state(s) through a filter with multiple clauses then have a card related to the ethnic group information.

I could put a quick example of what I mean together for you

Re: Filter widget -selecting multiples values

JonathanMcDougall — Wed, 21 Jul 2021 13:03:04 GMT

Sorry for this being rough - buy may give you ideas. Lists, filters, table, map and extents.

Re-published ExpB

Re: Filter widget -selecting multiples values

JoseBarrios1 — Tue, 20 Jul 2021 17:42:39 GMT

Hi Jonathan,

Thanks you for your suggestions. The problem is that I don't have a map associated with the table. The table contains a list of species and the requirement is for the user to select multiple States to see the list. I was able to use the widget filter (using the "is any of " sql statement). The only problem that I still have is the duplication of values due to many - many relationship on species-state. The other problem is that the filter affects ALL the other tables on the app.

Re: Filter widget -selecting multiples values

JonathanMcDougall — Tue, 20 Jul 2021 21:25:29 GMT

@JoseBarrios1

You may not have a list of species in the map, however, the common field in map, or list, and table is State, I assume.
This being the case, when you add the trigger, it will ask for this common field from the two datasets.
If you look at the link above, you will see I've put "states" into a list, from that list you can select multiple which will then populate the table from selected records. I've left the map there, but no map interaction is needed.
I'll add more records to make it a bit more obvious what's going on.

Re: Filter widget -selecting multiples values

JonathanMcDougall — Wed, 21 Jul 2021 13:13:22 GMT

@JoseBarrios1

I've republished for you, it's still rough but should work as an example.

Elements are as follows;
Map - shows nothing more than the selection from the list, I've not set any actions at all. This dataset is just a dataset of states, nothing more.
List - set to allow multiple selections of "states". It's got one action to select records of species to show in the table.
Table - the data is a table of "species" that was published with the "state" feature layer, so two datasets with the state as a common id. The table is set to show selected records.
Filter - speaks for itself.

Happy to give further info and screenshot to develop further.

Re: Filter widget -selecting multiples values

JoseBarrios1 — Wed, 21 Jul 2021 13:50:49 GMT

I clearly understand the workflow. Thank you so much! I created the list that allow me to select multiple States...that work great!. However, if I use this workflow, I will have to duplicate the records many times for each state. I have 18 states with 2,099 species. The result will be an extremely very large table with duplicate records and a very long list of species for the filter. I don't see anyway around to support this many- to-many relationship.

Re: Filter widget -selecting multiples values

JonathanMcDougall — Wed, 21 Jul 2021 14:17:44 GMT

How's your species data held? Are you able to share a grab of a few lines? You wouldn't be creating duplicate records, just ensuring the right species has the right state - you're data would be no bigger than it is just now.

@JoseBarrios1

Re: Filter widget -selecting multiples values

JoseBarrios1 — Wed, 21 Jul 2021 14:41:20 GMT

I am confuse... Attached is a small excel sample of the species table structure. The species occur in many states as shown in "State" field.

Re: Filter widget -selecting multiples values

JonathanMcDougall — Wed, 21 Jul 2021 15:14:59 GMT

@JoseBarrios1

Ah, ok, you've got multiple states in a state field 🙂 So perhaps need to flip this.

Re: Filter widget -selecting multiples values

JavierCMartínezPrieto — Mon, 17 Oct 2022 10:52:09 GMT

hello @JoseBarrios1
I would like to ask about the filtering for multiple select.
the situation is the following, in the survey you can choose several options in a question, that is to say a multiple select.
the problem occurs in the buldier experience, i would like to be able to filter by each unique value that is in that field. i.e. filter by the list that composes that select multiple and not by the records sent. if i use the expression "is any of" only allows me to select by the options that have been sent and not by the values of the table.

Would you know any way to make this filter.

Thanks in advance.

Greetings Javier

Re: Filter widget -selecting multiples values

JoseBarrios1 — Mon, 17 Oct 2022 12:49:20 GMT

Hello Javier,

I'm not sure if I'm clearly understand your requirements. Do you mean using the filter widget on Exp. Builder to filter a table widget on the survey123 field that contains the values separated by commas? Take a look at this example that I created. (https://arcg.is/1fjjzv) If you select the "At Risk List" menu at the top menu you can see a set of filters on the left and a table on the right...the user can filter by State...on the State field that contains multiple values. Does this similar to what you need?

Re: Filter widget -selecting multiples values

JavierCMartínezPrieto — Mon, 17 Oct 2022 14:20:21 GMT

good afternoon,

I have visited the link (thanks for posting it) and if it is something similar to what I need. I need to make a filter that allows me a multiple selection (as in your experience), the problem is that when I create the filter in the experience it does not show me the values of the list that I have in the survey, but the records that have been sent and being a multiple select, these records appear separated by commas.
How could I create a filter that allows me to perform multiple selection and show me the selection values as they are shown in survey123, that is to say separated and not as they were sent after the survey?

thanks

greetings Javier

P,S: if you speak Spanish, we can write to each other in Spanish. hehehehehe

Re: Filter widget -selecting multiples values

JoseBarrios1 — Mon, 17 Oct 2022 16:37:13 GMT

see if this workflow works for you!

Re: Filter widget -selecting multiples values

CenkDemiroglu — Fri, 11 Nov 2022 14:28:30 GMT

Thanks for this workflow, but the filter still doesn't show the options separately (but treats each combination as a different option) as in your case with state abbreviations. How did you get to have that interface on your left?

Re: Filter widget -selecting multiples values

JoseBarrios1 — Sat, 12 Nov 2022 07:15:22 GMT

Here is a graphic representation of the left side panel. The left container of the "slider widget" have a column and a bunch of colored rows inside, separated with a divider and space. Inside the rows are some text box for titles and filters. Very simple. For the "states" I just created a bunch of filters to look the value on the table column with states separated by commas. Let me know if you have any other questions!

Re: Filter widget -selecting multiples values

KimKneifl — Mon, 16 Sep 2024 15:57:10 GMT

Hi Jonathan,

I followed this thread as I have a similar situation.

I have multiple states in a state field, and I attempting to use the Filter Widget to filter the related data on a Map and a List Widget.

For example, one of the state fields is 'zone'. Each plant has more than one zone listed, or multiples states. I the SQL Expression Builder, neither 'contains' or, 'is any of' will work. I also created one state or one state field, but I am not sure how this works and I would prefer to continue with my data as is, multiple states in one state field.

I added the following visuals to hopefully help explain the situation. Any help is greatly appreciated!

Kim

Re: Filter widget -selecting multiples values

ENGEOGIS1 — Mon, 02 Jun 2025 21:48:01 GMT

Hi Jose,

Thank you for posting this. I came across your post while searching for answers for a similar situation - I see you have to type in all the possible values beforehand to configure this "contains" search filter. Is it possible to let the user dynamically put in the potential values for search for? Or is this not possible with EXB? e.g. I have a column with values separated as "A, B, C, ...", and I want the user to be able to type "A" and filter to those rows containing "A" in their values. e.g. "A, B", "A", "A, B, C, D" etc.

Many thanks!

Re: Filter widget -selecting multiples values

JoseBarrios1 — Tue, 03 Jun 2025 11:10:34 GMT

Hello ENGEOGIS1

Absolutely — this is possible!

If your data column contains values like "A, B, C" and you want users to type "A" and return all rows that include "A" (such as "A, B", "A", or "A, B, C, D"), you can configure this using the Filter widget in AGOL Experience Builder.

Take a look at the screenshot to see the exact setup. Here’s how to configure it:

Add the Filter widget to your app.
Select the field that contains the multi-value entries (e.g., "A, B, C").
Choose the "contains" operator.
Under Input settings, select “User input” and check "Ask for values" to allow users to type in their own search terms.
(Optional but helpful) Add a Hint to guide users on what kind of value they should enter (e.g., "Type a letter to search, like A").

This setup enables dynamic filtering based on user-entered values.