Search and Filter

(1) Share

Report

Posted on by PioZ

Hi,

I'm beginner and I'm trying make my own first App. I managed to edit and save data, next step is to search and filter.

And I have a problem with use Search and Filter function together. I'm base on PowerApps Multiple Filters on Gallery (youtube.com) tutorial, I'm trying to do something like in 6:41 .

When I use both separately it works great, but I can't use them together, no matter what order I enter, I always get an empty gallery, and no errors.

This works great separately:

Search(Table1,ProgramFilter.Selected.Program,Program)

Filter(Table1,Status<>"x")

But this:

Search(Filter(Table1,Status<>"x"),ProgramFilter.Selected.Program,Program)

and that:

Filter(Search(Table1,ProgramFilter.Selected.Program,Program),Status<>"x")

doesn't.

Any ideas what I'm doing wrong?

Categories:

General Questions

All responses (6)

Answers (0)

Ami K 15,665 Super User 2024 Season 1 on at

Like (1)

Report
Re: Search and Filter

@PioZ - unfortunately Excel is a terribly unwieldy data source. Some tips:

Ensure the Excel file is closed prior to running your app.

Restart your app and/or refresh the Excel file via the data source pane

Blanks often occur when you make changes to your Excel table schema (e.g. renamed/deleted/added columns), Power Apps does not update with the latest changes. I would recommend deleting the table from your data source in Power Apps, and then re-add the table.
PioZ 8 on at

Like (1)

Report

Re: Search and Filter

@Amik Thanks for your engagement.
About tour questions:
1. Program and status are single line Text
2. See below.

But I think problem is else ware.
1. My source is excel file, I cant use anything else, see 3
2. I have table with 1400 rows and 5 columns, I increase row number to 2000
3. I think that will be the most important: my organization make to much restrictions.
I doesn't have menu marked yellow:
And many other things don't works. When they implement SharePoint in my organization last year I was send for 3 days SharePoint training. During first day we was amazed what we can do in SharePoint but also little confused because our SharePoint looked differently. Next day when Trainer sow our SharePoint he told us that we have 10% of what SharePoint can do. And year later we received information about closing SharePoint, so we cant use it anymore and we moves everything to Teams. So I think that's why is doesn't work in my case. I have some ideas how to try solve this case.

Thanks anyway 🙂
Ami K 15,665 Super User 2024 Season 1 on at

Like (1)

Report
Re: Search and Filter

@PioZ -

Could you please confirm what the data types are for those fields (Single Line Text, single-select Choice, Number etc)

What is your data source? (SharePoint, Dataverse, SQL etc)
PioZ 8 on at

Like (1)

Report
Re: Search and Filter

I also used:
Filter(
Table1,
Status <> "x",
Program = ProgramFilter.Selected.Program
)
with the same result, empty gallery. But Filter with one condition no matter which works as expected.
PioZ 8 on at

Like (1)

Report

Re: Search and Filter

No errors, same result like before, empty gallery.
Ami K 15,665 Super User 2024 Season 1 on at

Like (1)

Report
Re: Search and Filter

@PioZ - are you seeing an error message here?

Search( Filter( Table1, Status <> "x" ), ProgramFilter.Selected.Program, Program )