Handling delegation warnings

[bchager6]

Hi everyone...

I inherited a Power App with a page connected to a SharePoint list that's returning a delegation warning. I've been able to handle a different delegation warning by using the StartsWith function within the Items property of a gallery, but I need help with the below formula. 

Can anyone suggest where I might insert, "StartsWith?"

SortByColumns(Filter('SharePointList',(Title_search.Text in Title || Title_search.Text in Author.DisplayName || Title_search.Text in Owner.Value) || IsBlank(Title_search.Text)),"Title")

Thanks in advance to anyone who can help.

[Ramole]

Hi @bchager6 

Let me give you an example here is a code am using multi StartsWith and is delegable which you can amend to your requirements

Filter(Customers,
         (
            Or(
                  StartsWith(Company,InpSearchCustomerMain.Text),
                  StartsWith('Business Phone',InpSearchCustomerMain.Text),
                  StartsWith(City,InpSearchCustomerMain.Text),
                  StartsWith(Address,InpSearchCustomerMain.Text),
                  StartsWith('ZIP/Postal Code',InpSearchCustomerMain.Text)
                 
                  )
                 
         )))

[Ramole]

@bchager6 

That this Solve what you have asked? 

[WarrenBelz]

Hi @bchager6 ,

Try this

SortByColumns(
   Filter(
      'SharePointList',
      Len(Title_search.Text) = 0 ||
      (
         StartsWith(
            Title, 
            Title_search.Text
         ) || 
         StartsWith(
            Author.DisplayName
            Title_search.Text
         ) ||
         StartsWith(
            Owner.Value, 
            Title_search.Text
         )
      )
   ),
   "Title"
)

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.

Visit my blog Practical Power Apps

[Ramole]

Hi @bchager6 
Let me know if you need any more assistance.