Search Delegation Warning

(0) Share

Report

Posted on by ttseng1023

I am building a inventory Power Apps, and the search function has some warning message.

Here is my search function:

Search('Software', TextSearchBox1.Text, "Title", "Manufacturer")

I already set the delegation to 2000, I can only perform the search on the Title column, the "Manufacturer" column search return empty result.

Please provide some guidance, really appreciate it.

Categories:

Building Power Apps

All responses (12)

Answers (0)

Sort by

Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ttseng1023

What is the error message?
ttseng1023 12 on at

Like
a
(0)

Report
Copy link

Link copied!
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@ttseng1023

I am assuming that your data source is SharePoint. Search() is not delegatable in SharePoint. Instead, to avoid the warning, you can use Filter() and StartsWith(). This combination is completely delegatable and will work on any number of records.

The second problem is the failure to search Manufacturer suggests that you may have changed the name of the column in SharePoint. You can use Intellesense to find the right column name.

Filter( 'Software",StartsWith( 'Title' ,TextSearchBox1.Text )|| StartsWith( 'Manufacturer',TextSearchBox1.Text ) )
ttseng1023 12 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Drrickryp,
I am not familiar with intelligence to find the column name, could you shed some light?

I also copy your entire formula into my search text input bar, it gave me lots of errors, I saw there is a single quote and double quote to read the SharePoint list, is it Single quote?

Filter( 'Software",StartsWith( 'Title' ,TextSearchBox1.Text )|| StartsWith( 'Manufacturer',TextSearchBox1.Text ) )
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ttseng1023

Here is a sample from one of my SharePoint lists. I don't have any quotation marks in my formula. It shows a dependent dropdown and a textinputbox. The Items property for the dropdown is the top formula and the Items property for the gallery is beneath it.
ttseng1023 12 on at

Like
a
(0)

Report
Copy link

Link copied!

I simplified only to filter the second column, still getting the warning and I am unable to search the manufacturer?

Filter('Software', StartsWith(TextSearchBox1.Text, Manufacturer)).

Still getting this error:
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ttseng1023

Do you have something in the Default of the TextSearchBox?
ttseng1023 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Please see screenshot:

This TextSearchBox1 was part of the import when I link to my SharePoint as data source, maybe I should use native Excel file instead?
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try Filter('Software', StartsWith(Manufacturer, TextSearchBox1.Text))

See https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-startswith for the correct syntax and suggestions for using several columns in the filter.
ttseng1023 12 on at

Like
a
(0)

Report
Copy link

Link copied!

This what I got follow your new syntax.