Answered

Search to Include Text with Space

(0) Share

Report

Posted on by indhaa

Hi I'm trying use the search function on SharePoint, I have column as Full Name instead of separate columns as First and Last Name. Issue is search is not retrieving if I search by Last Name. No issue if I search by First Name. So is there a way to include the full text of a record with search. I don't want to have separate Fields

Categories:

Building Power Apps

All responses (13)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @indhaa

Filter(spList, Textinput1.Text in 'Full Name')

Be aware of some limitations. First, the "in" operator is not delegatable in SharePoint, meaning that you may miss some records if your list is >2000 items and PowerApps will show a yellow triangle warning that can be ignored for lists smaller than 2000 items. Also, fyi, it is preferable to use camel case and avoid the use of spaces in your column names. ie FullName instead of Full Name.
indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Quick question, when checking > 2000 is it including the latest records in the search or I might miss in between? If so better to create two column as FirstName and LastName, right?

Yah, the column is named as FullName. I just mentioned it with space just for reference only
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!

Hi @indhaa

It will only search the first 2000 items in the list. To search the newest 2000 records, Sort the list by ID in descending order first. SharePoint assigns an ID to every record in the order in which the record is created. Delegation in SharePoint will only work for StartsWith(). If you separate the names, you will be able to search any number of records with StartsWith(). https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-startswith

There are some work arounds for the delegation issue. @WarrenBelz 's blog has a good discussion here.

https://warrenbelz.blogspot.com/2020/08/power-apps-delegation-is-word-not.html
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the kudos but if it answers your question please accept it as a solution.
indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I tried to use as instructed but it is not prompting any records now. Can you let me know what is the issue with the below code.
Filter(WiFiAccess, TextSearchBox1.Text in "FullName")

I want to include the above inside the below code after it is working correctly

SortByColumns(Filter([@WiFiAccess], StartsWith(FullName,TextSearchBox1.Text)||StartsWith(Organization,TextSearchBox1.Text)), "ID", If(SortDescending1, Descending, Ascending))
indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Can I get some feedback on how to correct this!!
I tried to use as instructed but it is not prompting any records now. Can you let me know what is the issue with the below code.

Filter(WiFiAccess, TextSearchBox1.Text in "FullName")

I want to include the above code inside the below code (need some alteration) after it is working correctly

SortByColumns(Filter([@WiFiAccess], StartsWith(FullName,TextSearchBox1.Text)||StartsWith(Organization,TextSearchBox1.Text)), "ID", If(SortDescending1, Descending, Ascending))
indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Now ok. Got it working now
indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I want to ask about Sort the list by ID descending order. If i have more than 2000 items, it is not retrieving the latest items. I was in the impression it will retrieve the latest 2000 items if delegation is not supported.

Regards
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Put the sort inside the filter.
indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

If my code is like this. How to arrange it. Still New to this, so dont know what you meant above.

SortByColumns
(
Filter
(
SharePointList,
If
(         ),
   "ID",
   Descending
)