Trouble extracting non duplicate records from 2 (almost) matching arrays

[MarkSmall79]

Hi everyone, I'm hoping someone here will easily be able to see where I'm going wrong in my logic here.

I have 2 large arrays of data that I'd like to compare and extract the items that are present in only the first array.
Unfortunately, my Filter Array game appears to be lacking, as I seem to just have everything returned, rather than just the items that are unique to the first array.

I have the first array (with the most data) in the "From" attribute and the second array (that should be missing some entries) being filtered to see if the entries from the first are present.

I'd simply like to list all items that ARE present in the "Select - SQL Data" and ARE NOT present in the "Select - SP DATA", but am clearly missing something; the Filter is returning all entries.

Any pointers as to where I'm going wrong would be greatly appreciated.

Thanks

[v-wenjuan-msft]

Hi @MarkSmall79 ,

Arrays should be used to compare are value of the body:

Try this:

outputs('Select_-_SQL_Data')?['body/value']
outputs('Select_-_SP_Data')?['body/value']

Community Support Team _ Wenjuan Zou

If this post helps, then please consider Accept it as the solution to help the other members find it.

[MarkSmall79]

Hi there,

Thanks for the reply, much appreciated.

Unfortunately, I must've done something wrong when interpreting this, as it hasn't worked; the flow failed.

I'll openly admit that I don't understand all of this as much as I'd like.

[v-wenjuan-msft]

Hi @MarkSmall79 ,

Please replace like this:

Community Support Team _ Wenjuan Zou

If this post helps, then please consider Accept it as the solution to help the other members find it.

[MarkSmall79]

Thanks for your time on this, I appreciate it, but unfortunately it hasn't worked

[v-wenjuan-msft · Accepted solution]

Try to replace input of your Filter array to:

body('Select_-_SQL_Data')?['value']

Community Support Team _ Wenjuan Zou

If this post helps, then please consider Accept it as the solution to help the other members find it.

[MarkSmall79]

Hi there,
Thanks for taking the time once again, apologies for the very late response.
This didn't work either, I received the following error:

Unable to process template language expressions in action 'Filter_array' inputs at line '0' and column '0': 'The template language expression 'body('Select_-_SQL_Data')?['value']' cannot be evaluated because property 'value' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

My understanding is not the highest, but very frustrating at how difficult comparing two arrays seems to be!