Unanswered

Search part in this formula might not work correctly in large data

(0) Share

Report

Posted on by lunalovegood

215

Hello everyone!
im trying to make search box that can searches column named "Keywordss" , i used textinput element and this is the item property for my gallery

Search([@'ABC Lesson Learn'], TextInput1.Text, "Keywordss")

but i got error that the search part might not work correctly

Thank you for helping

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @lunalovegood , The Syntax look good here, however what is the datatype of Keywordss?

Firstly, search is not delegable even if you set the data row limit to 2000 , it is still not delegable. If the number of rows is less than 2000, you could ignore this warning. I think this link will help you a lot:

Please consider delegation: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ 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 Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
lunalovegood 215 on at

Like (0)

Report

the data type is multiple lines

Was this reply helpful? Yes No
cdwhite 1,067 Most Valuable Professional on at

Like (0)

Report
Hi @lunalovegood ,

As @ANB , the warning you're getting is around delegation. This is when Power Apps passes the processing of queries onto the data source. There are only a handful of Power Fx functions that work with this though, unfortunately Search isn't one of them.

Therefore, if your data source goes beyond the default of 500 records it will not pull in anything more. You can expend this limit to 2000 but you may have the same problem again if the data source goes beyond that number.

Where possible, try to build apps without any delegation. A potential easy fix for your scenario would be to use the StartsWith function instead of Search:

Filter([@'ABC Lesson Learn'], StartsWith(NameOfColumnYouWantToSearch, TextInput1.Text))

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net

Was this reply helpful? Yes No