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

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 319 members 5,684 guests
Please welcome our newest community members: