Hi Experts
I have two arrays in a Power Automate Flow:
Array 1:
[
{
"ID": "A-111",
"Name": "Process 1"
},
{
"ID": "A-222",
"Name": "Process 2"
},
{
"ID": "A-333",
"Name": "Process 3"
},
{
"ID": "A-444",
"Name": "Process 4"
},
{
"ID": "A-555",
"Name": "Process 5"
},
{
"ID": "B-111",
"Name": "Process 1.1"
},
{
"ID": "B-222",
"Name": "Process 2.1"
},
{
"ID": "B-333",
"Name": "Process 3.1"
},
{
"ID": "B-444",
"Name": "Process 4.1"
},
{
"ID": "B-555",
"Name": "Process 5.1"
}
]
Array 2:
[
{
"ID": "A-111",
"Name": "Process 1",
"Environment": "Prod",
"Application": "Application A"
},
{
"ID": "A-333",
"Name": "Process 3",
"Environment": "Prod",
"Application": "Application A"
},
{
"ID": "B-222",
"Name": "Process 2.1",
"Environment": "Prod",
"Application": "Application B"
},
{
"ID": "B-555",
"Name": "Process 5.1",
"Environment": "Prod",
"Application": "Application B"
}
]
I need to filter Array 1 so it only shows items where the ID exists in both arrays. I know that it can be done by using Apply To Each but for better overview I would like to use the Filter Array. But I cannot get it to work. I have tried with converting Array 2 into a Dictionary-kind-of looking like this:
{
"A-111": {
"ID": "A-111",
"Name": "Process 1",
"Environment": "Prod",
"Application": "Application A"
},
"A-333": {
"ID": "A-333",
"Name": "Process 3",
"Environment": "Prod",
"Application": "Application A"
},
"B-222": {
"ID": "B-222",
"Name": "Process 2.1",
"Environment": "Prod",
"Application": "Application B"
},
"B-555": {
"ID": "B-555",
"Name": "Process 5.1",
"Environment": "Prod",
"Application": "Application B"
}
}
But then the Filter Array just returns an empty output.
