Unique/Distinct values in a List widget

AroldoRocha

It would be good to add the option to return a single occurrence of a given attribute to the Experience Builder list widget, avoiding having to choose to use a support table, or even use the query and filter widgets, which have the same feature.

BlakeMorrison

 

 

 

I managed to almost achieve what I wanted. Perhaps this method can help someone else in the future:

1. "Add data" to your app. Select "Arcade".
2. Copy and adjust the below code to suit. Apply. OK. Add.
3. Point your list widget at the 'category' field in this new data source

 

 

var portal = Portal('https://www.arcgis.com');

var fields = [
    'OBJECTID',
    'category',
];

var fs = FeatureSetByPortalItem(
    portal,
    '1234567890123456789012345',
    0, // or whatever index the layer is
    fields,
    False
);

var filterfs = Filter(fs, "category IS NOT NULL");

return GroupBy(
    filterfs,
    [
    'category',
],
    [
    {
        name: 'Category',
        expression: '1',
        statistic: 'Count',
    }
    ]
);

 

Limitations I found: Not able to filter by map extent (as there's no geometry)