Combobox lists filter by Active (Sharepoint List Column Value)

(3) Share

Report

Posted on by CU10041356-0

Hi,

Wondering for any help/advice.

(I am using Canvas Apps not a Form.

I have a Sharepoint List called : Venue List

There are 2 columns in the List : Venue and Active

I have a combobox "cmbVenue" which has this fx code in it's "item" setting

Sort(Distinct(Filter('Venue List',StartsWith(Venue,Self.SearchText)),Venue),Value)

which does show all items in the Venue List sharepoint list.

But what i want is to only show items where the Active column (in the sharepoint list) is equal Yes and hide items that are not active (Active column - No)

Please can someone suggest how to adapt my fx code in its "item" setting to facilitate this.

Thanks in advance.

Categories:

Building Power Apps

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Suggested answer

timl 37,214 Super User 2026 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!
Hi @CU10041356-0

You can do this by extending your call to Filter to include the active column.

The code would look like this:

Sort( Distinct( Filter( 'Venue List', Active = true, StartsWith(Venue, Self.SearchText) ), Venue ), Value )

Was this reply helpful? Yes No
CU10041356-0 96 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Many thanks for replying.

I get an error message - "Incompatible typesfor comparison. These types can't be compared: Text, Boolean"

The Active column in the sharepoint List "Venue List", is not a yes/no field(boolean) it is a plain text column. So the values are strings "Yes" or "No".

Do you know how i would make it work with Strings NOT boolean, but also with avoiding Delegation Issues.

Thanks again!

Was this reply helpful? Yes No
Verified answer

timl 37,214 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @CU10041356-0

Changing the syntax of the condition to 'Active = "Yes"' will treat it as a string rather than a boolean.

Sort( Distinct( Filter( 'Venue List', Active = "Yes", StartsWith(Venue, Self.SearchText) ), Venue ), Value )

The issue is that Distinct isn't delegable. If you try grouping by Venue instead, that should give you a distinct list that's delegable.

Sort( GroupBy( Filter( 'Venue List', Active = "Yes", StartsWith(Venue, Self.SearchText) ), Venue, GroupData ), Venue )

Was this reply helpful? Yes No
CU10041356-0 96 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks that works.

Just asking your advice, would i be better to stick to a Boolean for "Active" or a string?

Obviously, delegation in mind.

Thank you

Was this reply helpful? Yes No
Verified answer

Haque 3,653 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @CU10041356-0,

venues : Active = Yes

In ComboBox cmbVenue, let's update Items property formula to include a filter on the Active column like this:

Sort(
Distinct(
Filter(
'Venue List',
StartsWith(Venue, Self.SearchText) && Active = "Yes"
),
Venue
),
Value
)

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
CU10041356-0 96 on at

Like
a
(1)

Report
Copy link

Link copied!

Haque that is awesome.

Thank you so much - that also works exactly as i was looking for.

It is much appreciated.

Was this reply helpful? Yes No
timl 37,214 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CU10041356-0

>>Just asking your advice, would i be better to stick to a Boolean for "Active" or a string?

In answer to this question, a Boolean would probably be better. Both strings and Booleans are delegable, so it makes no difference from a delegation perspective.

The benefit of a string is that it would provide more flexibility if you want to add additional options over yes/no at a future date (ie pending, deleted, etc).

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi - depends,

Boolean is better from comutational POV in contrast string is always expensive. If you don't foresee any any addition of options in future, you can pick up boolean one, string otherwise.

Was this reply helpful? Yes No