Wildcard search on delegable filters in gallery.

(0) Share

Report

Posted on by Rohit4044041

286

Hello

We have PowerApps with gallery control which is tied to doc library in SharePoint. Gallery shows these specific files and has filters implemented within PowerApps. We have taken care of delegable queries and made sure it work.

Client has now come up with request of wildcard text search which is not delegable . We alredy have filter in palce which is using "starts with" and it works since its delegable. We are havung hard time explaining why it wouldnt work with wildcard and they will end up seeing maximum 2k fikes from 20k files dataset, if we add wildcard text search .

So , question is. Is there a way to have wildcard implemented only on the fetched current data with gallery while other filters continue to work and fetch data from DataSource .

Currently, the moment I add text search whole items data source shows warning and only first 2k files are shown

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 152,843 Most Valuable Professional on at

Like (1)

Report
Wildcard search on delegable filters in gallery.

Hi @Rohit4044041

If I am reading this correctly, you can get your sample down under 2k with a Delegable query and want to Search this ? If so
With( { _Data: Filter( SPLibrary, StartsWith( YourTextField, YourTextValue ) ) }, Search( _Data, YourSearchInput.Text, YourSearchedField ) )

You can search several fields at the bottom if you want - once the top filter returns less than 2k records (although note you will get no warning if it potentially returns more - just the first 2k matching records), the bottom one will return all matching records from the top set.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Rohit4044041 286 on at

Like (0)

Report

Wildcard search on delegable filters in gallery.

Thank you @WarrenBelz . Unfortunately we already have Formula after Scope. Currently we have "ForAll" used on the result set i.e. _Data. We use this to get row number of row to apply alternating color.

Is there any way to use both ForAll And Search function?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 152,843 Most Valuable Professional on at

Like (1)

Report
Wildcard search on delegable filters in gallery.

Hi @Rohit4044041,

If you simply want to also add alternate shading
With( { _Data: Filter( SPLibrary, StartsWith( YourTextField, YourTextValue ) ) }, With( { List: Search( _Data, YourSearchInput.Text, YourSearchedField ) }, ForAll( Sequence(CountRows(_List)), Patch( Index( _List, Value ), {RowNo: Value} ) ) ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No