Lookup field Search Limitation

(0) Share

Report

Posted on by Jignyasa

Hi Community,

I am working on a project on Power Apps with Dataverse as data source.

There is a requirement to Search Lookup fields in Gallery. I understand Search function expects String type only. I came across a workaround to create a formula column with Text Format and refer it to the lookup field in dataverse table. Later, that can be used in Search function.

I have following queries:

Is there a better alternative to this approach to meet the requirement?
Are there are any limitations in the aforementioned workaround?

Regards,
Koundinya

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Giraldoj 762 Super User 2025 Season 2 on at

Like (0)

Report

Hi Koundinya,

to give you a more accurate answer I will need more detail about what you want to build in power apps, because text limitation is only for Search Function, but you can filter using Filter, or Lookup Functions, and those ones does not have that text limitation.

but if search is the good aproach for you please consider the following, search function does not support delegation, and you are going to find a delegation warning. This means that by default the first 500 rows of your table will be searched and returned, you can increase this limit up to 2000 in the advanced settings.

there is a really good explained article here explaining a lot about search function: https://www.matthewdevaney.com/power-apps-search-function-delegation-warning-workarounds/

If this helps, please mark it as the solution by clicking "Accept as solution." A "Like" would be greatly appreciated if you found the content helpful. Thanks!
Best,

LinkedIn: https://www.linkedin.com/in/jhonatan-giraldo-2b20561b9/

Was this reply helpful? Yes No
Jignyasa 22 on at

Like (0)

Report

Hi Jhonatan,

I guess you replied with an understanding that my data source is SharePoint. My data source is Dataverse. Search is delegable in Dataverse.

I need to have Search functionality. I already have implemented Filter function in my code.

The requirement is to use Search on Lookup field in a table that is connected to a gallery.

Regards,
Koundinya

Was this reply helpful? Yes No