Hello everyone,
I have a list of elements. I want to see if these elements are in an external array. If the external array does not contain these elements, then erase them.
I have tried with this flow:
Initialize 2 arrays (please ignore the 4th action) that will be informed with the data. First one will be informed with an Excel table and then, from this array, using 'Select', will only be using the first column (which is the same as the Title column in the Sharepoint list). Second array will be informed with the list from sharepoint and also, we will also 'Select' the first column. Then I would like to apply to each element in the second array to be checkend in the first array, using a condition such as this:
At the moment, I can not make the condition to work with any element in the arrays. Also, once the conditional action has worked, I would not know how to get the ID from the Sharepoint list element to erase said element. Let me show you the output of both 'Select' actions:
Array 1
[
{
"MAPR[Grupo-Unidad]": "C04D-G3KEH595"
},
{
"MAPR[Grupo-Unidad]": "C04Z-73KSCZ65"
},
{
"MAPR[Grupo-Unidad]": "C04Z-73KSDB33"
},
{
"MAPR[Grupo-Unidad]": "C04Z-73KSDD35"
},
{
"MAPR[Grupo-Unidad]": "C04Z-73NAFH28"
},
{
"MAPR[Grupo-Unidad]": "C04Z-73NAHX28"
},
{
"MAPR[Grupo-Unidad]": "C50K-73KLAY77"
},
{
"MAPR[Grupo-Unidad]": "CJ15-45N1BY98"
},
{
"MAPR[Grupo-Unidad]": "CJ15-73KSDB33"
},
{
"MAPR[Grupo-Unidad]": "CJ15-78N1D770"
},
{
"MAPR[Grupo-Unidad]": "CJ24-73KSCZ03"
},
{
"MAPR[Grupo-Unidad]": "CJ24-75K1AL80"
},
{
"MAPR[Grupo-Unidad]": "CJ24-CRNAHV15"
},
{
"MAPR[Grupo-Unidad]": "CJ31-73KSDB33"
},
{
"MAPR[Grupo-Unidad]": "CJ31-73NAGQ04"
},
{
"MAPR[Grupo-Unidad]": "CJ38-73KSCV24"
},
{
"MAPR[Grupo-Unidad]": "CJ38-73NAHX28"
},
{
"MAPR[Grupo-Unidad]": "CJ38-C5NEL350"
},
{
"MAPR[Grupo-Unidad]": "CJ46-46N32430"
},
{
"MAPR[Grupo-Unidad]": "CJ46-73KSCZ02"
},
{
"MAPR[Grupo-Unidad]": "CJ46-73KSCZ79"
},
{
"MAPR[Grupo-Unidad]": "CJ46-75K1BB94"
},
{
"MAPR[Grupo-Unidad]": "CJ46-75K1BB95"
},
{
"MAPR[Grupo-Unidad]": "CJ46-D8KEU518"
},
{
"MAPR[Grupo-Unidad]": "CJ46-D8KEU778"
},
{
"MAPR[Grupo-Unidad]": "CJ-5-73KSCV24"
},
{
"MAPR[Grupo-Unidad]": "CJ-5-73KSCV49"
},
{
"MAPR[Grupo-Unidad]": "CJ-5-73KSCZ02"
},
{
"MAPR[Grupo-Unidad]": "CJ-5-73KSCZ03"
},
{
"MAPR[Grupo-Unidad]": "CJ-5-73KSDB33"
},
{
"MAPR[Grupo-Unidad]": "CJ-5-73NAHX28"
},
{
"MAPR[Grupo-Unidad]": "CJ-5-75K1BB94"
},
{
"MAPR[Grupo-Unidad]": "CJ59-73KSDD12"
},
{
"MAPR[Grupo-Unidad]": "CJ59-73NAHX06"
},
{
"MAPR[Grupo-Unidad]": "CJ59-73NAHX35"
},
{
"MAPR[Grupo-Unidad]": "CJ-5-PRKSCO35"
},
{
"MAPR[Grupo-Unidad]": "CJ65-D8KEU779"
},
{
"MAPR[Grupo-Unidad]": "CJ69-34KB8894"
},
{
"MAPR[Grupo-Unidad]": "CJ69-73NAHR94"
},
{
"MAPR[Grupo-Unidad]": "CJ69-QAN00241"
},
{
"MAPR[Grupo-Unidad]": "CJ69-QAN00242"
},
{
"MAPR[Grupo-Unidad]": "CJ69-QAN00243"
},
{
"MAPR[Grupo-Unidad]": "CJ69-QAN00244"
},
{
"MAPR[Grupo-Unidad]": "CWT1-45N1BXT2"
},
{
"MAPR[Grupo-Unidad]": "CWT1-73KSCY95"
},
{
"MAPR[Grupo-Unidad]": "M21A-73NAHZ47"
},
{
"MAPR[Grupo-Unidad]": "TE02-75K1BB95"
}
]
Array 2:
[
{
"MAPR[Grupo-Unidad]": "CJ31-73KSDB33"
},
{
"MAPR[Grupo-Unidad]": "CJ31-73NAGQ04"
},
{
"MAPR[Grupo-Unidad]": "CJ24-CRNAHV15"
},
{
"MAPR[Grupo-Unidad]": "CJ24-75K1AL80"
},
{
"MAPR[Grupo-Unidad]": "CJ24-45K1BPR7"
},
{
"MAPR[Grupo-Unidad]": "CJ24-45N1BNN9"
},
{
"MAPR[Grupo-Unidad]": "CJ24-73KSCZ03"
}
]
Can anyone please help me?
Thank you very much!
Eduardo.


Report
All responses (
Answers (