Multi search with keywords

[Winterkid]

Hi all,

can i ask help for multi search with keywords.
in my sharepoint list the Asset Tag Columns, Employee number, Employee Name
AssetTag ID that is from TAKSG000001 to TAKSG000100 and so-on.

In Employee_number is from 0001 to 1000 and so son

in Employee name is all the different user name (example Christopher/ Amanda Leong. etc etc)

what i want for the search to do is that say if

i want to search AssetTag ID TAKSG000010 i can just type 10 in the search box.
if I want to search a employee number i can just type 0948 and it will show me the employee number, employee name & what asset tag id is under this employee number.
if i want to search Employee name, Say Chris, any employee name with chris will appear.

I am not sure whether is there a way for this to happen but please do let me know.

Currently in the galley the it is set to this

SortByColumns(Filter(IT_ASSET2,(Or(StartsWith(Asset_Tag, TextSearchBox1.Text),
StartsWith(Employee_Number, TextSearchBox1.Text),
StartsWith(UserName, TextSearchBox1.Text)
)
)
),
"Title",
If(SortDescending1, Descending, Ascending)
)

[WarrenBelz]

Hi @Winterkid ,

You will need EndsWith() for the number items if you want to type in the number (also if you need to keep this Delegable). You could use Search or in Filters, but they would not be (Delegable)

SortByColumns(
   Filter(
      IT_ASSET2,
      EndsWith(
         Asset_Tag, 
         TextSearchBox1.Text
      ) ||
      EndsWith(
         Employee_Number, 
         TextSearchBox1.Text
      ) ||
      StartsWith(
         UserName, 
         TextSearchBox1.Text
      )
   ),
   "Title",
   If(
      SortDescending1, 
      Descending, 
      Ascending
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Winterkid]

Hi @WarrenBelz,

Once again thank you for your help.
I have this  Delegration warning. The highligted part of this formula might not work correctly with column "Asset_Tag" on large data sets.

Any recommends how to resolve this error?

[WarrenBelz]

Hi @Winterkid ,

What type of field is Asset_Tag?

[Winterkid]

it just text field in sharepoint

[WarrenBelz]

@Winterkid ,

Can you please supply a screenshot of the error. EndsWith() is Delegable and so is a Single line of Text field.

[WarrenBelz · Accepted solution]

@Winterkid ,

Update - despite the MS documentation that says it is Delegable

(and it was previously), EndsWith() gets a warning, so I suspect MS have changed this.
So back to your problem - if you have less than 2,000 items in your list, you can increase you limit and do this

With(
   {wAsset:IT_ASSET2},
   SortByColumns(
      Filter(
         wAsset,
         EndsWith(
            Asset_Tag, 
            TextSearchBox1.Text
         ) ||
         EndsWith(
            Employee_Number, 
            TextSearchBox1.Text
         ) ||
         StartsWith(
            UserName, 
            TextSearchBox1.Text
         )
      ),
      "Title",
      If(
         SortDescending1, 
         Descending, 
         Ascending
      )
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.