Condition not return any values

[Wizby01]

Hi

I am trying to build a flow from the dataverse. I need to get information from two lists. 

I set out my variables

I next list the rows from both tables, both tables have filters that appear to be working well

I then mapped the variables so i can compare the names from both tables

intersection(body('Select'),body('Select_2'))

the problem i have now is that I have a list of names i need to send emails to. I need to connect these names back up from the output from table one so i can send it to the relevant email address and other fields i need for the email. 

When i put the following condition in place it does not return any values even though common names has 11 names under it.

The Value is from Table one as well as the "Full name" field.

When i look at the data run from table one fullname comes back as "first last" name, in the same format to the common name output.

Not sure what i am doing wrong here.

Thanks

[v-dezhili-msft · Accepted solution]

Hi @Wizby01 ,

The intersection function returns an array, we cannot use strings to compare with arrays, you can try to use String() to convert arrays to strings.

Best Regards,

Dezhi

[Ajinder31]

Hi @Wizby01 , Try changing Condition to use contains like below.
Like @v-dezhili-msftx, intersection returns an array so we check for if intersection array contains the Fullname or not.

--------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

[Wizby01]

Thank you so much for picking this problem up.