How do I get a distinct list of values from a DS entity, for my dropdown?

[David_Hernandez2 (David Hernandez)]

Hello, I can’t seem to figure this portion out! Essentially, in UiPath Apps I have a Table, from Data service, where my STATUS column has a bunch of values.

I want to create a drop down so they can filter by the distinct status, so in the above image for example the drop down would have “PENDING: Document..” , “Sucess! Document Sent..” and “In Progress: Document..”, etc.

Currently I have it set like so:

And the issue is it grabs EVERY status:

I’ve tried doing
STATUS.Distinct.ToArray and that did not work

[ashokkarale]

@David_Hernandez2,

Can you try this expression in List source

Fetch(YourEntity).data.DistinctBy(Function(x) x.StatusField).ToListSource()

Replace entity and fields as per your entity.

[prashant1603765 (Prashant Kumar)]

@David_Hernandez2

I’ve tried doing
STATUS.Distinct.ToArray and that did not work

Hi @David_Hernandez2

Try to use the Group By function instead of DISTINCT. Fetch your data from the Data Service, then apply GroupBy(“STATUS”) to group the data by unique status values. Bind the dropdown to these grouped values, allowing the user to filter the table based on distinct STATUS options.

You can also check below link,

Group By Entity And Show the List In Drop Down

Hello Everyone, I have more than 300 rows in an entity having a year column, that column having the same value like 2020 will be repeated n number of times. I am required to do the Grouping of the same value and show them one time only instead of showing the same values multiple times. How that can be done? Attaching the screenshot for reference. [image] [image]

Happy Automation

[sharazkm32 (Sharaz K M)]

Save your entity to a tempvariable of type ListSouurce of Entity

Create another variable of Type Array of text and use below expression

tempvariable .data.Select(Function(x) x.Column).Distinct().ToArray

While using in Drop Down - use Array variable as the data source

@David_Hernandez2