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.
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";
Where does varUser come from and nohire is it related to your client list?
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
)
)
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.