Unique values in a List widget

Question

Hi all,

New to Experience Builder, so apologies if this has already been answered, but haven't found it anywhere.

I have a feature layer that contains sampling results from various sites. Each site can have from one to several hundred records. I'd like to be able to create a List widget where the values are the unique site names, i.e. each site listed just once, not one for each record. When I try setting Site Name to Unique in the builder, I get an error message telling me the SQL is incomplete (Site Name | is | Unique). I'm looking for the equivalent to "SELECT DISTINCT([Site Name]) FROM Layer". I can do this in Dashboard with Arcade. Is it possible in Experience Builder? Thanks!

AndreaB_ · Answer

Hi @TonghuiMing ,

I'm looking in both the Filter widget and the Query widget. I don't see the "List values based on All unique values of this field" if I choose "Unique (predefined)" option but I do see it if I choose "Unique" from that dropdown.

So that seems to work. The Query widget gives more options for Actions so I'm going to use that.

ZenMasterZeke · Answer

I ended up having to create a separate feature layer of just the sites. Even if I got distinct values from the first layer, it didn't help. The distinct values weren't tied to a particular location, so couldn't do actions like zooming the map.

BlakeMorrison · Answer

Good idea, but no dice. This works well for the filter widget, but doesn't perform as expected for the list widget.

I'm in the same position as @ZenMasterZeke - trying to display values in a list widget from distinct features only. Short of writing a python script to automate this, I'm absolutely stumped.