Unanswered

Gallery shows no items when a filter is applied

(0) Share

Report

Posted on by JoshGG

Hi everyone,

I'm currently getting an issue where no items are showing in a filter on gallery. I have another gallery with the same input box which is going off a different data source (Dataverse) which is working and pull data. But I have another gallery (Excel) which when I put in the filter of:

Filter(Table_BOM_items,TextInput1.Text in 'Bus Trans (project)')

Nothing shows up.

When I just do "Table_BOM_items" the table will show all the data correctly

I don't have an delegation warnings coming up

Does anyone know what I might be doing wrong or suggest a filter/search that could work without delegation issues

Thanks in advance

Josh

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @JoshGG ,

Try:

Filter( Table_BOM_items, Len(TextInput1.Text)=0 || TextInput1.Text in 'Bus Trans (project)' )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan
JoshGG 4 on at

Like
a
(0)

Report
Copy link

Link copied!

This did work but the only problem is using "Or" I get a delegation issue now and can't search past 2000 items
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JoshGG

Can you confirm what connector you're using? Are you using the Excel Online Business connector, or are you using the OneDrive connector?
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JoshGG I should have clarified, Excel is not a delegable data source whatsoever in Power Apps.
JoshGG 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm using the Excel Online Business Connector. I'm going to assume that is my problem