Solved: StartsWith issues - else delegation issues

Hello

I have a canvas app, with SP List as the data source.

I have been trying to get around delegation and the only way I could do so, was using StartsWith, the issue with StartWith in my scenario is we have accounts both with First Name/Surname and Surname/FirstName, which means any user I'm looking for who has Surname/FirstName will not be found by the search text:

Below is my Items property of my gallery, is there a workaround:

Filter(
 SPLIST,
 (IsBlank(TxtInputSearch.Text) || StartsWith(FullName.DisplayName, TxtInputSearch.Text))
 && (IsBlank(DDLevel.Selected.Value) || Level.Value = DDLevel.Selected.Value)
 && (IsBlank(DDStatus.Selected.Value) || Status.Value = DDStatus.Selected.Value)
 && (IsBlank(vDateFilter) || ReviewDate <= vDateFilter)
)

Thank You

Categories:

Using Apps Using Formulas

General Questions

Hi @PAppsAlways1 ,

Firstly, I will be clear that this may not be a total solution as the top filter needs to return record numbers under your Data Row Limit

With(
 {
 _Data:
 Filter(
 SPLIST,
 (
 Len(DDLevel.Selected.Value) = 0 || 
 Level.Value = DDLevel.Selected.Value
 ) && 
 (
 Len(DDStatus.Selected.Value) = 0 || 
 Status.Value = DDStatus.Selected.Value
 ) && 
 (
 IsBlank(vDateFilter) || 
 ReviewDate <= vDateFilter
 )
 )
 },
 Filter(
 _Data,
 Len(TxtInputSearch.Text) = 0 || 
 TxtInputSearch.Text in FullName.DisplayName
 )
)

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.

MVP (Business Applications) Visit my blog Practical Power Apps