cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vshah804
Level: Powered On

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
Level: Powered On

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
vshah804
Level: Powered On

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
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 452 members 4,202 guests
Please welcome our newest community members: