Filtering List Data Based on a ComboBox Selection

[golfnutt82]

Hello,
I have a list and I want to filter and display the data based on a combobox choice.
However, when I try to do this I am getting an error.
You will notice that I am attempting to create a variable as well to use on other data to display as a result of the search result.
The "Role" field in the "Roles" List is a text field that is updated after a workflow runs.
The combobox field is grabbing the list column data.

[RandyHayes · Accepted solution]

@golfnutt82 

You cannot use the Choices function on a Text column.  If you are looking for distinct values, then use the Distinct function:

    Filter(Distinct(Roles, Role), ComboBox2.SearchText in Result)

You really don't need a variable for this as your control already serves as a dynamic variable that will already contain the information you need.

I hope this is helpful for you.

[golfnutt82]

Hi Randy,
Thanks for the reply.
I received this error.

In the OnChange event on a separate form, I use the following to populate other fields when a choice is made from a lookup which I was trying to use with a combo box.

How could I display other list data on the form when a choice is selected if I am not able to use a variable as I was able in my other form?

[RandyHayes]

@golfnutt82 

Well first, you can use a variable, but I was stating that you don't need a variable as your source control already has what is needed.  A variable would just be a static snapshot that you need to maintain in your app.

As for the formula...re-read what I wrote for the formula - you are missing a closing paren.

[golfnutt82]

Thanks, missed that.
I appreciate your assistance.