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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

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

Like (1)

Report
@PioZ - are you seeing an error message here?

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

Was this reply helpful? Yes No
PioZ 8 on at

Like (1)

Report

No errors, same result like before, empty gallery.

Was this reply helpful? Yes No
PioZ 8 on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@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)

Was this reply helpful? Yes No
PioZ 8 on at

Like (1)

Report

@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 🙂

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@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.

Was this reply helpful? Yes No