How to get unique values of a column from my entity to my App dropdown

[sachinns94 (Sachin Ns)]

I have an entity added to my App, I want to add unique values of a column to one dropdown. Help me to figure it out how.

I tried selecting the entity for “List source” and selected column name in “column” properties. But it did not worked.

[Anil_G (Anil Gorthi)]

@sachinns94

Directly you might not get..please check this approach

Group By Entity And Show the List In Drop Down

We used experience from: And did this Quick Prototype: DS Samples: [grafik] Variables: [grafik] DistinctYearList - Array of Text DSFiltered / Prefetch1 = ListSource(Of OURDSEntity) We configured onPageLoad [grafik] Prefetch1 - the normal DS Fetch DistinctYearList: Prefetch1.data.Select(Function (x) x.Col2).Distinct().OrderBy(Function(s) CInt(s)).ToArray Demonstrating Control we reordered DropDown Event: [grafik] DSFiltered = Prefetch1.data.Where(Function (x) x.Col2.Equals(M…

Cheers

[sachinns94 (Sachin Ns)]

I tried using the used case mentioned, it is slightly different I think and unable to replicate it for mine.
I have a DS entity and I want to populate unique values of column “Designation” in one dropdown field in App.

Configured onPageLoad as shown below. (Used the same variable data types as in the used case)

Prefetch1- Fetch(of Enity Name)(Nothing, Nothing, Nothing, Nothing, New ExpansionFieldOption(){addExpansionFieldOption(“CreatedBy”, New String(){“Id”, “Name”}), addExpansionFieldOption(“UpdatedBy”, New String(){“Id”,“Name”})})

Dropdown properties as shown below.

Entity sample as shown below.

Kindly help me to identify the issue for these screenshots. Thanks

[Anil_G (Anil Gorthi)]

@sachinns94

Everything is correct in the Dropdown list source select DistinctSkillList.ToListSource

Column you can leave empty

cheers

[sachinns94 (Sachin Ns)]

Thanks, It worked. Cheers.

Just wanted to confirm one more thing, Can we run any process before the app loads ?

Example:

I have an excel in my local or any spreadsheet. Can I run any process to read this file and load our dropdown to show real time data ?

[Anil_G (Anil Gorthi)]

@sachinns94

you can try calling it in the load …and use loader till it completes

cheers