Announcements
Hi I have a combobox that displays the a list of salesmen according to the area selected in another dropdown
can i have this combobox apear the 5th (for examle) salesman from the list? Or if not possible with a combobox , can it be done with dropdown ?
Hi
Set the Items property of the ComboBox to the list of salesmen based on the selected area. For example:Items: Filter(SalesmenList, Area = DropdownArea.Selected.Value)
Set the Default property of the ComboBox to get the 5th item from the filtered list. You can use the FirstN function to get the first 5 items and then use the Last function to get the 5th item. For example: Default:Last(FirstN(Filter(SalesmenList, Area = DropdownArea.Selected.Value), 5))Thanks!If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
Hi @Rajkumar_404 it waorked! thanks
can you help me also to stop this if all choises are slected
for example i have 8 comboboxes that i set the Default property using your formula, however if an area has less options (for example 7) the 8th combobox apears the 7th option again (like previous combopox). I tried to write something like if(Last(FirstN(Filter(SalesmenList, Area = DropdownArea.Selected.Value), 5))=previuscombobox,"",last(FirstN(Filter(SalesmenList, Area = DropdownArea.Selected.Value), 5))) but it does not work
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 401 Most Valuable Professional
11manish 201 Super User 2026 Season 2
MS.Ragavendar 128 Super User 2026 Season 2
