Answered

Filtering Dataverse Choice Column

(0) Share

Report

Posted on by Digital

1,207

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)

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Digital 1,207 on at

Like
a
(0)

Report
Copy link

Link copied!
I used this method to get my combobox items :

Filter( Staff, First('Role').Value = 'Staff Role'.'Manager' )

This populates the combo box with the the correct staff members for that role but I get a delegation warning. I feel like this should be a straightforward thing to do and that I must be doing something wrong.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Digital

Try this,

Filter(Staff, Role='Staff Role'.'Manager')

This will not give any delegation warning.

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Digital ,

Use in ComboBox Items:

Choices('Role (Staff)')

and in Filter() function:

Filter(Staff,Role=ComboBox.Selected.Value)

Hope it helps !

Was this reply helpful? Yes No
Digital 1,207 on at

Like
a
(0)

Report
Copy link

Link copied!

@gabibalaban ,

This gives me the role choices in the combo box but I don't want that. I want the combobox to contain the names of staff whose role is Manager. I'm not using the combobox.selected.value to filter a gallery or anything.

@CNT ,

That is what I assumed would work but I get a delegation and incompatible type warning.

I need the Manager combo box to give the user a list of Managers to select from.

I need the Operator combo box to give the user a list of Operators to select from.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Digital The formula I gave is fine and should work. I have tested it. Your problem could be something else. Send a screen shot of the Table definition in Dataverse and also your App (showing the formula with the error).

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Digital ,

And this formula gives you delegation error too ?

Filter( Staff, 'Role' = 'Role (Staff)'.Manager )

Was this reply helpful? Yes No
Digital 1,207 on at

Like
a
(0)

Report
Copy link

Link copied!
@gabibalaban
@CNT

I appreciate your help.

This is the formula I tried in the Items property of the combobox where I want to display the names of people where 'Crew Role' = Foreperson.

I get an incompatible type error and also a delegation warning

Filter( SM_Ref_CrewMembers, 'Crew Role'='Crew Role'.Value )

This is some example table data
And this is the table definition. I tried making Crew Role Searchable too but it didn't make a difference.

Thanks,
Dean

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Digital The Data Types Choice and Choices are different in Dataverse. As the name suggests, Choice will let you choose one option whereas Choices will let you choose multiple options. If the field 'Crew Role' will have only one value at any given time using the Choice datatype is better and the formula I gave you earlier will work.

But if you want to have the possibility to choose multiple values, you can use Choices and then the formula will be,

Filter( SM_Ref_CrewMembers, 'SM Crew Member Role'.Foreperson in 'Crew Role') )

Was this reply helpful? Yes No
Digital 1,207 on at

Like
a
(0)

Report
Copy link

Link copied!

@gabibalaban
@CNT

I was using the Choices type when I should've been using Choice. I didn't even realise there was a Choices type! Apologies to you both and thanks for your help.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Digital Glad to help!

Was this reply helpful? Yes No