cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vshah804
Helper I
Helper I

String match

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.

1 ACCEPTED SOLUTION

Accepted Solutions
vshah804
Helper I
Helper I

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

 

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

 

Thanks.

View solution in original post

1 REPLY 1
vshah804
Helper I
Helper I

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

 

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

 

Thanks.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (48,441)