Using StartWith and Search

[Anonymous]

Here's the situation:
I have a DataTable whose Item property is set like this:

Search(DataTable;Input_Search.Text;"Column1";"Column2";"Column3")

I'd like to apply the [@StartWith] tag, meaning the result of search would consider only the fields starting with what the user types in Input_Search. The problem is I can't get it to work, tried out a couple solutions (The StartWith() function...) but it doesn't work out. Any help ?

[RezaDorrani · Accepted solution]

Hi @Anonymous 

Filter(DataTable,StartsWith(Column1,Input_Search.Text) || StartsWith(Column2,Input_Search.Text) || StartsWith(Column3,Input_Search.Text) )

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly