search engine with sharePoint list with more than 10 000 items.

(0) Share

Report

Posted on by Ben-00-38

176

Hello,
I have a sharepoint list with 10,000 items.
this customer account list can be updated by the user (dynamic).

here is how it works:
a page with only the textsearchbox and the results that appear in the gallery.

the gallery is not visible at the start of the page it is by using the search that the results are displayed.
(like a search engine)
when we do a search the gallery displays the results of the items in the sharepoint list.

I need to know how to structure with a basic code because I am limited in item 2000.
I did not find the solution on the forum.
Thanks for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Ben-00-38

You are not necessarily limited by 2000 if you can Filter your list based on StartsWith() as this fully delegatable in SharePoint. If you go to your SharePoint list you can find a dropdown that will build a complete app for you using the proper functions that make it work.

Many functions are not delegatable and so there are limits but if you can build your app within the limits, you may be ok.

For example,

Filter( SPlist, StartsWith( FirstName, TextSearchBox1.Text ) )

will work on a list containing 20,000 names and will be very quick.

Was this reply helpful? Yes No
Verified answer

Ben-00-38 176 on at

Like (0)

Report
Copy link

Link copied!

thanks! this works with the basic code.
new code :
Filter(
'Compte client';
StartsWith(
'ID (Title)';
TextSearchBox_2.Text
) || StartsWith(
'Nom (NM1_ADD)';
TextSearchBox_2.Text
) || StartsWith(
'Ville (VIF_ADD)';
TextSearchBox_2.Text
)
)

I would like keep
-user filtering
'ATC_nom (ATC)'. Email = varUser.Email || ChefVente.Email = varUser.Email || || varUser.Email = "xxx@xx.fr"
Can you help me write the code?

my base code was this.

With(
{
acct: Filter(
'Compte client';
'ATC_nom (ATC)'. Email = varUser.Email || ChefVente.Email = varUser.Email || || varUser.Email = "xxx@xx.fr"
)
};
Filter(
acct;
searchQuery in 'Ville (VIF_ADD)' || searchQuery in 'Nom (NM1_ADD)' || searchQuery in Title
)
)

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ben-00-38

Where does varUser come from and nohire is it related to your client list?

Was this reply helpful? Yes No
Ben-00-38 176 on at

Like (0)

Report
Copy link

Link copied!

no: varuser is the list of users of the application.

the code works
Filter(
'Compte client';
'ATC_nom (ATC)'. Email = varUser.Email || ChefVente.Email = varUser.Email || varUser.Email = "automateriel@durandservices.fr" || varUser.Email = "xx1@test.fr" || varUser.Email = "xx2@test.fr" || varUser.Email = "xx13test.fr";
StartsWith(
'ID (Title)';
TextSearchBox_3.Text
) || StartsWith(
'Nom (NM1_ADD)';
TextSearchBox_3.Text
) || StartsWith(
'Ville (VIF_ADD)';
TextSearchBox_3.Text
)
)

I made a list (user access) to try to give different accesses according to the user mails for example an access 1 access 2.
example:
'user access'
user xx1@test.fr level 1
xx2@test.fr level 2
depending on the level I filter

this is the part of the code that I need to modify to make it simpler to apply user access...
Filter(
'Compte client';
'ATC_nom (ATC)'. Email = varUser.Email || ChefVente.Email = varUser.Email || varUser.Email = "automateriel@durandservices.fr" || varUser.Email = "xx1@test.fr" || varUser.Email = "xx2@test.fr" || varUser.Email = "xx13test.fr";

Was this reply helpful? Yes No