Filter Combobox

Like (1) Share

Report

Posted on 11 Jul 2024 13:04:57 by Cedric0404

116

Hello guys,

I'm using a combobox with the search function.

The source of the Combobox is a table "Countrytable", which has a column "Country" and a column "Status".

I'm trying to filter the combobox for countries with Status true. But as soon as im using the search in the combobox im getting an error: "...Try to make all columns visible".

Code of combobox: Filter(CountryTable;Status=true)

thanks for your help!

All responses (4)

Answers (0)

ivan_apps 2,187 Moderator on 11 Jul 2024 at 22:03:12

Like (1)

Report

Re: Filter Combobox

Is the country table in a separate sheet and hidden? What is your configuration for the Search field?
developingteal 392 on 11 Jul 2024 at 16:47:10

Like (1)

Report

Re: Filter Combobox

make sure there still will be a column visible after status=true
Cedric0404 116 on 11 Jul 2024 at 13:47:46

Like (1)

Report

Re: Filter Combobox

sorry I forgot to say that. The data source is an excel. And both columns are text columns. So it should be like Status= "True"
ivan_apps 2,187 Moderator on 11 Jul 2024 at 13:36:28

Like (1)

Report

Re: Filter Combobox

What's your data source? SharePoint? What data type are the columns "Country" and "Status"? Is "true" really a status option the Status column? Assuming they are choice columns ->
Filter(
CountryTable,
Status.Value = "true"
)

Click on the "Fields" property of your combo box, be sure to set your Display column & Search column appropriately.