Power Platform Community Forum Thread Details

Please, help to solve the problem.

I have a table 'List of sites'. It has columns: Site Name - the data in this column is generated by a drop-down list, which is taken from the third table and CCCM agency status - the data is taken from Entity, which is called "CCCM agency status list". In an application that fills out another table, I need to create a ComboBox that will display the Site Name column data, filtered by CCCM agency status.

I tried next code:

Filter(Choices('List of sites'.cr15c_SiteName); Value('CCCM agency status') = "Active level 1")

Where:

List of sites - Name of the table, from what i took info
cr15c_SiteName - schema name of the column I want to display in the dropdown list
CCCM agency status - name of the filtered column
Active level 1 - Filtering option

In this code I get the error “Incompatible comparison types. It is impossible to compare these types: Control, OptionSetValue (CCCM agency status list)

Where CCCM agency status list - Entity, from what i take options for dropdown for CCCM agency status3 column

How can I solve the type compatibility comparison types problem and how can I edit the code

Categories:

Building Power Apps