Search function not working instead giving out blank gallery

(0) Share

Report

Posted on by sujitthakur

Hello All ,

I am pretty new to Power apps

I am connecting an excel file which is stored in sharepoint

I am using excel online connector to connect to powerapps

I am using following powerfx formula but it ends up giving blank gallery instead of searching

the table is only 50 row big

formula is
search(maintable,impsearch.text,"Name")

Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (2)

sujitthakur 48 on at

Like (0)

Report

please help @WarrenBelz

Was this reply helpful? Yes No
sujitthakur 48 on at

Like (0)

Report

please help @ADCommunity

Was this reply helpful? Yes No
sujitthakur 48 on at

Like (0)

Report

@Drrickryp

Was this reply helpful? Yes No
Verified answer

Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Hi @sujitthakur

It sounds like you just need to Filter your Gallery, not search. Try this:

1) Add a Gallery
2) For the "Items" property, select your data source
3) Add a text input
4) Add a filter formula to the Gallery "Items" property to use this text input as your search

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/add-gallery#filter-and-sort-a-gallery

The formula would look something like this:
Filter(DataSource,Column = TextInput1.Text)

Was this reply helpful? Yes No
sujitthakur 48 on at

Like (0)

Report

Hello @Rusk it is still giving me a blank gallery please help

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@sujitthakur

Excel is a terrible datasource. Move your data to SharePoint.

Was this reply helpful? Yes No
sujitthakur 48 on at

Like (0)

Report

@Drrickryp I will for sure after my demo to my seniors
But for now it is mandatory to be in excel as there are some external contributors to data

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report

Is there a screenshot or something you can provide so we can troubleshoot why your gallery is blank? Or at least the formula you are using would be helpful

Was this reply helpful? Yes No
sujitthakur 48 on at

Like (1)

Report

@Rusk i tried using filter too but it dint work

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report

@sujitthakur ,

As you tagged me, I will add a small contribution and support @Drrickryp here - the query power of Excel is very limited (compared with SharePoint) and I suspect you have a big list there. There is nothing wrong with your code (which would work perfectly in SharePoint). You could try StartsWith() and see if you get data that way.

Was this reply helpful? Yes No