Announcements
Hello,
I have an Excel file and I want to populate my combobox with all users having WorkDeskNo blank. How can I do This?
Hi @catalinaA ,
Assuming you are already connecting to the worksheet table on OneDrive as a data source in your app, the combobox Items: property might then look like this;
Filter(myExcelSource, WorkDeskNo=Blank())
You can then set the DisplayFields: property of the combo to whichever other field you want it show in the dropdown.
Hope this helps,
RT
Great. It works.
One more question,please : how can I populate the other combobox with the value from WorkDeskNo?It only returns me the column related to first name.
Thank you very much!
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.
11manish 393 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 278 Most Valuable Professional
