Answered

Search bar with dropdown. Gallery uses If statement.

(0) Share

Report

Posted on by TobiasSQA

Hello there!

I'm making an app which has a gallery that shows a numbers of items that are delegated into categories. However I have run into an issue.

I had the search field working when I didn't need to have a blank item choice in the dropdown menu, however now that I do, the "If" Statement is occupied so to speak.

I would like it to work like this: If anything is in the search field, it should filter the items in the gallery based on that, if not, filter it based on the dropdown.

Below is a PNG Attached explaining the different elements

Thanks in Advance!

Regards

Tobias SQ Andersen

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TobiasSQA ,

Sorry, could you please provide your formula separately? The formula in your screenshot is not very clear.

Best Regards,
Charlie Choi
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @TobiasSQA ,

Based on your description: If anything is in the search field, it should filter the items in the gallery based on that, if not, filter it based on the dropdown.
I have made a test for your reference.

1. Here is my SharePoint List.
2. Select the Gallery Control and try to apply the formula like this:
If( !IsBlank(TextInput1.Text), Filter( datasource, TextInput1.Text in columnname ), If( !IsBlank(Dropdown1.Selected.Value), Filter( datasource, Dropdown1.Selected.Value = choicecoulumnname.Value ), datasource ) )
Result Screenshots:

In addition, if you want the search bar and dropdown to work together, maybe you could try the following formula:
Search( If( !IsBlank(Dropdown1.Selected.Value), Filter( datasource, Dropdown1.Selected.Value = choicecolumnname.Value ), datasource ), TextInput1.Text, "columnname" )
Result Screenshot:

Best Regards,
Charlie Choi
TobiasSQA 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Charlie

Once again this worked perfectly, thank you so much for the stellar assistance! You're almost doing too much 🙏

Kind Regards,
TobiasSQA