@oappdev
Actually, if you use the SEARCH function it will look at the whole contents of the column.
If you just wanted to SEARCH on the last name only you'd need to put it in a separate column within your datasource or a collection. I am thinking a collection is the better way to go here.
Assuming 'Center' is a single-line text field in SharePoint use this code to create a Collection in the OnVisible property of the screen.
ClearCollect(colComboOptions,
AddColumns(
your_datasource_name,
"LastName",
Split(Center," ")
)
)
Then use it as the Items property of your gallery
colComboOptions
And change the SearchFields property to this
["LastName"]
Now your ComboBox will only search on the last name.
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
