Filter Combobox

(1) Share

Report

Posted on 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!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

ivan_apps 2,189 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Cedric0404 116 on at

Like
a
(1)

Report
Copy link

Link copied!

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"

Was this reply helpful? Yes No
developingteal 392 on at

Like
a
(1)

Report
Copy link

Link copied!

make sure there still will be a column visible after status=true

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Is the country table in a separate sheet and hidden? What is your configuration for the Search field?

Was this reply helpful? Yes No