Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 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.

  • Ben-00-38 Profile Picture
    Ben-00-38 176 on at
    Re: search engine with sharePoint list with more than 10 000 items.

    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";

  • Drrickryp Profile Picture
    Drrickryp on at
    Re: search engine with sharePoint list with more than 10 000 items.

    @Ben-00-38 

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

  • Verified answer
    Ben-00-38 Profile Picture
    Ben-00-38 176 on at
    Re: search engine with sharePoint list with more than 10 000 items.

    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
    )
    )

  • Verified answer
    Drrickryp Profile Picture
    Drrickryp on at
    Re: search engine with sharePoint list with more than 10 000 items.

    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.

    _2.png

    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard