cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Wizby01
Frequent Visitor

Condition not return any values

Hi

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

I set out my variables

Wizby01_0-1669782396961.png

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

Wizby01_1-1669782440647.png

Wizby01_2-1669782486138.png

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

Wizby01_3-1669782537524.pngWizby01_4-1669782563404.png

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.

Wizby01_7-1669782811492.png

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-dezhili-msft
Microsoft
Microsoft

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.

 

vdezhilimsft_0-1669785936023.png

 

Best Regards,

Dezhi

View solution in original post

3 REPLIES 3
v-dezhili-msft
Microsoft
Microsoft

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.

 

vdezhilimsft_0-1669785936023.png

 

Best Regards,

Dezhi

Ajinder31
Continued Contributor
Continued Contributor

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.

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

 

Thank you so much for picking this problem up. 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,726)