Replicate sharepoint default form search column operation in Power Apps

[AngelCT]

hello
I have a sharepoint list. In it a search field for data from another table.
When I open the form that is created by default in the sharpoint list to register a new record, the search field is able to find any part of the text that I type in the combo box. It is as if the asterisk was placed before and after the text to be searched but without the need to use the asterisks.
Now I want to customize that form with PowerApps, and when I load the form in PowerApps that field doesn't work the same. Within PowerApps it is generated with the Choices formula and when I go to the field and write any text so that it can filter the data, it only looks for the text that "starts" with what I have written, otherwise it doesn't look for anything.
Does anyone know why I lose that functionality and how I can make it work the same from powerApps?
thank you.

[M_Ali_SZ365]

Hi @AngelCT ,

To replicate the SharePoint default form search column operation in Power Apps:

Use the Search function in Power Apps instead of the Choices formula.
Modify the Items property of your combo box:

Items = Filter(YourDataSource, StartsWith(ColumnName, ComboBox.Text) || EndsWith(ColumnName, ComboBox.Text) || IsBlank(ComboBox.Text))

Replace YourDataSource with your data source and ColumnName with the actual column name.

Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

[AngelCT]

Hello,

thanks for answering. I have applied the formula but it still does not work as expected. It only filters the text if the text I type in the combo box matches the origin starting from the left. It is not able to filter if I type text contained in the center of the text string.
Maybe it's because my combo box doesn't have the "Text" property anywhere. The only thing I have found most similar is the "SearchText" property. I don't know if it has anything to do with it.

Filter(MyDataSource; StartsWith(ColumnName; ComboBox.SearchText) || EndsWith(ColumnName; ComboBox.SearchText) || IsBlank(ComboBox.SearchText))

[AngelCT]

I push this issue that I still cannot resolve