I'm new to Dataverse and having trouble filtering on a choice column to populate a combobox in Power Apps. I have a Dataverse table 'Staff' that lists employees and their role.
Columns:
EmpName (Text)
Role (Choice)
Role choices are: Manager, Operator
I have a combo box in Power Apps called cmbManager. I want to filter the items so only the names of people with role of Manager are displayed.
Here is what I put in the Items:
This gives me a delegation warning and incompatible type (Table vs OptionSetValue(Role))
Filter(Staff,Role = [@Role].Manager)
Another attempt but again get incompatible type
Filter(Staff,Role.Value = [@Role].Manager)
Solved! Go to Solution.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
185 | |
53 | |
41 | |
36 | |
30 |
User | Count |
---|---|
242 | |
81 | |
71 | |
69 | |
65 |