Filter on Dataverse column value after space - CanvasApp

(1) Share

Report

Posted on by ctedesco3307

977

Hi - looking for a simple way to search on a split the "employee's" name by first few characters of the last name

Column is a Dataverse single line of text column

Currently search code is

StartsWith(

'Employee Name',

Trim(tbEmpNameFilter.Text)

) ||

EndsWith(

'Employee Name',

Trim(tbEmpNameFilter.Text)

I tried

StartsWith('Employee Name',Trim(tbEmpNameFilter.Text)
) ||
StartsWith(Last(Split('Employee Name'," ")).Value,Trim(tbEmpNameFilter.Text))

but I get the delegation error

Client wants to see a result for the first few characters of the last name ...

ex: Ted returns

Christina Tedesco

Thank you

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Michael E. Gernaey 53,968 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ctedesco3307

You should share a screen shot of the error, so we can validate where or if there are many delegation errors.

1. Do you have more than 2,000 records that will be searched??? if not ignore the delegation warnings

2. Can you please share the whole Filter/Search, as in are you truly doing a Search or a LookUp or a Filter or a combination?

If you just want to get rid of the Delegation, please share the whole thing

Thanks

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

StartsWith is delegable in Dataverse, but you can also use Search() for your text search.

take a look at this Delegable function table from the docs: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-common-data-service#power-apps-delegable-functions-and-operations-for-dataverse

if you look at the footnotes it states that with the text searches Trim() is not delectable with text fields. Try removing your transformations and use Search to get your desired results.

Was this reply helpful? Yes No
ctedesco3307 977 on at

Like
a
(1)

Report
Copy link

Link copied!

@ivan_apps - Thanks - trying to use Search but getting error

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

When you see 'Employee Status (Employees)' it's actually trying to give you the values of that dropdown. If you put a period after it, you'll see all the options in the choice column.

The syntax is: Search(Table*, SearchString, Column1 [, *Column2*, ... ] )
so likely you just need 'Employee Status' as Column1 instead of 'Employee Status (Employees)'

Was this reply helpful? Yes No
ctedesco3307 977 on at

Like
a
(1)

Report
Copy link

Link copied!

@ivan_apps I had the wrong field in the first screen shot- it's a text field I am working with. Same error

Was this reply helpful? Yes No