cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Helper I
Helper I

Re: String match

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
Highlighted
Helper I
Helper I

Re: String match

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,824)