Unanswered

How to you compare two sets of lists using the ID

(0) Share

Report

Posted on by Community Power Pla...

Hello,
I have two lists, compliance and Tarefas and i'm tryng to check if one of the lines in Complinace has been erased.

For that i have an array with the ID's of the elements of that list, and i'm tryng to compare with ListID that refers Tarefas with Compliance.

If the ListID on Tarefas are not present in Compliance it should delete that element.

I have used an for each and it works however it would delete all the elements on tarefas.

Can someone help me?

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (2)

Report
Hi @Anonymous,

You could use the filter array action with the does not contain operator.

@DamoBird365 has written a nice blog about this approach. Look for the except section:

https://www.damobird365.com/efficien-union-except-and-intersect-great-method/

Below is an example using that approach.

In that example I am looking at the IDs of the both the lists and checking if Tarefas does not contain item IDs which Compliance has. In the from the output of the Select - Compliance action is used. For the comparison the following expression is used with the does not contain operator.

@not(contains(body('Select_-_Tarefas'), item()))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Unfortunately it doesn't work .
It returns the three elements that i have but it only should return 1. The one with the ID 46

The output from the filter array.

The list tarefas.

The list compliance. The one with the ID 46 is A3.

What i'm trying to filter is to identify the ID 45 that was been deleted from the list compliance

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

Apologies that I made it a bit confusing. In the example I showed I was checking the following:

Check if Tarefas does not contain item IDs which Compliance has

Looking at your original post the check probably needs to be reversed:

Check if Compliance does not contain item IDs which Tarefas has

So, in that case you need the swap the output values in the filter array action. In the from the output of the Select - Tarefas action. In the expression use the Select - Compliance output instead.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have exchanged the values, however it should only give me the ID of 46. And it gives me the following ID's.
Thanks so much for the help so far

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

Can you share the outputs of the two select actions? Just want to double check something.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Expiscornovus .
The outputs are the following:

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

The compliance array are integer values and your tarefas array are string values. That is probably the reason why it isn't working. You are comparing integers with string values.

Did you use a single line of text column type for the tarefas id field?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I did have as a single text column.
However i did change to number and the error persist.

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

Thanks for changing that.

Just double checking a couple of things.

1. The select Tarefas action contains two list items, with ids 45 & 46. And the mapping is using the ListID field and not the ID field like in my example?

2. The select Compliance action contains three items, with ids 43, 45 & 46?

3. You are expecting the filter array to give back 1 item, ID 43?

4. You are using the does not contain operator in your filter array?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

1. The mapping is using ListID field because is matching the other list compliance.
2. Yes, A1, A2 and A3.
3. I'm expecting ID 46
4. I'm using does not contain.

Was this reply helpful? Yes No