web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter by text box and...

Power Apps

Answered

Filter by text box and combobox

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I previously had my gallery filter by the text in a text search box and this worked fine i.e all profiles would display and it would filter based on the text in the search box.

Gallery items were:

SortByColumns(
Filter(Profiles,
TextSearchBox1.Text in Title || TextSearchBox1.Text in 'About Me' || TextSearchBox1.Text in Option.Value
),
"{Name}",
Ascending
)

I have added a combobox as well now and want to display all items if combobox.selected.value is blank, otherwise filter by the value where it relates to 'Stream' in my data source. How can I update this?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Anonymous

Please consider changing your Formula to the following:

SortByColumns( Filter(Profiles, (TextSearchBox1.Text in Title || TextSearchBox1.Text in 'About Me' || TextSearchBox1.Text in Option.Value) && (IsBlank(Combobox.Selected.Value) || Stream = Combobox.Selected.Value) ), "{Name}", Ascending )

Change any name references accordingly for your app.

I hope this is helpful for you.

Join the conversation