Announcements
I am trying to create this simple dropdown that will display the citys in which the company has clients in. I used a SortByColumns function and specified what I want to display with "i9_name" but it keeps returning the "createdby_type" column with a bunch of "systemuser". What exactly am I doing wrong here?
@vinidegrandi - Please check the display fields property and add the column that you need to be shown.
@Bilakanti you mean the DisplayMode property? What exactly am I supposed to write in it?
Oh, nevermind. I understand what you meant now. The issue now is its telling me it reached the limit of items it can display.
@vinidegrandi - In my case i added a combobox and by default it came with"bk_employeeid" column as part of displayfields, and I want to show "bk_employeeaddress" column to be shown in the dropdown, so I just added"bk_employeeaddress" column in the first item and it worked like a charm. Hope that should resolve your issue.
Yes, I realized I had a regular dropbox and not a ComboBox. It did "work" but it is basically showing me every city ever instead of the ones on the table.
@vinidegrandi "i9_name" is a lookup column pointing to another table? If you want unique city names then you can use Distinct function to retrieve only unique city names.
It is not. Inside this column there is only a handful of cities but its returning me every city on the planet haha
@vinidegrandi Can you please share what is your items property and what is the data in the table.
My items property is the picture I've shown, and the table is right under it, but here it is in more detail:
@vinidegrandi - As per your screenshot, I am sure it will show only the data from that table. Just to cross check, I would suggest you to count the rows in dropdown and count the rows in table whether both of them are matching or not.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 421 Most Valuable Professional
11manish 153 Super User 2026 Season 2
MS.Ragavendar 116 Super User 2026 Season 2
