String match

[vshah804]

Hello Team,

I have a dropdown and whatever value user selects, I want to do the datatable (source is SQL) fileting based on contains logic.

Meaing, If the user selects "ABC" in dropdown, I want the datatable to display all the records where SQL column CONTAINS "ABC".

I'm thinking to use IsMatch function something like  IsMatch(Dropdown.SelectedText.Value,SQLColumn,Contains)) but It's not working. It says systex issue. 

Also Once I got the contains values, I want to AND those results with another SQL table. 

Please suggest. Thank you.

[vshah804 · Accepted solution]

Team - Nerver mind. I got the solution. Here is below that did the trick.

Filter(SQLTable,Column1="YES" && Dropdown.SelectedText.Value in column2)

Thanks.