UiPath Apps | Show "n" number of values in the drop down

[Kavindu_Dilshan]

Hi Team,

I am using a dropdown in UiPath Apps and need to show only n number of values.
Example: Show only latest 6 values.

Could you please support me on this?

Thanks

[Anil_G (Anil Gorthi)]

@Kavindu_Dilshan

you can use something liek this

Listsrc.Data.Take(6).ToListSource

this will get only 6 items from list…if you want to make it variable then can add input for it and use that variable here
cheers

[Kavindu_Dilshan]

@Anil_G

Listsrc.Data.Take(6).ToListSource

Hi @Anil_G ,

Thank u and could u please share an example or screenshot of this how to use please?

[Anil_G (Anil Gorthi)]

@Kavindu_Dilshan

If you want to use for a specific number always then just copy paste the above formula in listsourcefield of dropdown…ensure you use your listsource variable my variable is listsrc…you need to change

If you need to fetch how many to display from user then

Create a app variable of listsource type…

And link that variable to dropdown listsource

Now create a event rule on input firld where you would ask the user to input the value…now use a set value in create field and set the list source variable usign listsec.Data.Take(valuefromlabel).ToListSource

Hope this is clear

Cheers

[ashokkarale]

@Kavindu_Dilshan,

Try this expression in your List Source of Drop down.

Thanks,
Ashok

[Kavindu_Dilshan]

Hi @Anil_G & @Anil_G ,

Thanks a lot and I need add the sort according to the descending order as well to the same query. How do I achieve that?

Thanks

[Anil_G (Anil Gorthi)]

@Kavindu_Dilshan

try like this

Listsrc.data.OrderByDescending(Function(x) x.DisplayName).Take(6).ToListSource

cheers

[ashokkarale]

@Kavindu_Dilshan,

If you want to take first 6 rows and then sort those in descending order then try this query.

dtDropdownSource.ToListSource().data.Take(6).OrderByDescending(Function(row) row.Item(0)).ToListSource()

Thanks,
Ashok

[Kavindu_Dilshan]

Hi @ashokkarale ,

I am getting below error

[ashokkarale]

@Kavindu_Dilshan,

Remove Item and check what are the available columns there. Select the suitable one.

Thanks,
Ashok