Unanswered

How to return results from an array that contain a substring from a column in another array?

(0) Share

Report

Posted on by tsnowden

I want to create a flow that uses data from a Dataverse table to compare to results from a SQL query and return any rows from the SQL query that contain the values from the Dataverse table. The problem is when extra characters exist in the results from the SQL query. I'm able to find exact matches between the two arrays, but can't figure out how to search the SQL query array that contain the substring value in Dataverse.

Example:

SQL Query: "ABC DEF1234"

Dataverse: "DEF1234"

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (0)

Report
Re: How to return results from an array that contain a substring from a column in another array?

Hi @tsnowden

while iterating over SQL rows try contains operator
you can try the below code in composing an expression so the outcomes shall be true/false accordingly you can proceed further

contains(variables('Apply_to_each')['column'],'DEF1234')
Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

Was this reply helpful? Yes No
tsnowden 11 on at

Like (0)

Report

Re: How to return results from an array that contain a substring from a column in another array?

Thanks for the prompt reply!

I use the contains operator now, but I only get TRUE on exact matches, not when the value in my 2nd array matches as a substring value in the 1st array, which is what I need.

Was this reply helpful? Yes No