Announcements
This is a strange issue.I have 3 Dataverse Tables.Departments - With the 'Department Name' a Primary key.Offices - With the 'Office Location' a Primary key.Roles - Has Fields Office and Department who are the Lookup field.I want to filter the Roles Tables to display the Office values for a selected Department value.The Following formula works great on a Gallery: Filter(Roles, Department.'Department Name' = fld_Dept.Text).OfficeWhen I apply it to a Combo-box to generate drop down values, it works but values are not visible, like white on white. I send the selected value to a label and its correct. Tried in a new app and same issue.
You need to initialise the primary text of Combo boxClick on edit fields and Initialise it.
It was graded out.This worked: ort(Distinct(Filter(Roles,Department.'Department Name' = fld_Dept.Text),Office.'Office Location'),Result,Ascending)
Hi @ezFlow,
Glad that you have resolved your problem.
Could you please mark your reply as an answer to help more users?
Thanks for your cooperation.
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 382 Super User 2026 Season 2
Mohsin Ali 329
WarrenBelz 187 Most Valuable Professional
