Power Platform Community Forum Thread Details

I'm having trouble wrapping my head around something with Named Formulas.

To keep things fast, I used to filter and load a small subset of records into a local collection via OnStart. I also have a search box to look into various fields for data. Also, I'd have various ClearCollect statements littered through the app where needed to keep the collection up to date after adding / changing records.

I figured Named Formulas would streamline this somewhat. A single named formula defining the collection, and ClearCollects would be a thing of the past. Adding / editing a record would show those changes immediately. This part seems to work.

But, filtering a gallery's items that uses this Named Formula with a search box seems to cause delegation and sometimes other problems. Is this something that can't be done? If I set the collection via Onstart, the filtering works (typically using IN to look for text strings inside fields). But, that same collection as a Named Formula plays havoc with filtering.

Anyone seen this? Anyone figure out how to have a Search Box with a Named Formula?

Categories:

Building Power Apps

When you want to use a text input to search inside a gallery, the best way to achieve this is to simply use a text input up to your gallery and then use Search on your gallery items using the text input as the value to search and columns inside the collection you want to seek in.

Search(CustomGallerySample; TextInput1.Text;SampleHeading)
 

***Note: Use the classic TextInput. The newer one onChange trigger is different and touchy to use.***

I suggest you to use a 'X' icon on the field to reset the text input.

Otherwise, if you try to search for text using 'In', you gonna impact hardly delegation. If you go that way, I recommend to add a column on the collection to grab the related table which contains the text you want to search in before using it in a gallery.

If your situation is not cover from this, please explain a bit more :).

___________________________________________________________________________

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.