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.
Go to Solution.
Team - Nerver mind. I got the solution. Here is below that did the trick.
Filter(SQLTable,Column1="YES" && Dropdown.SelectedText.Value in column2)
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.