I'm not sure if this is what you are after. Also I'm not sure how you could only use the Name to filter on. What if you had two objects with the same name, but different Titles?
Anyway, here is an example that takes two arrays of objects and combines them and removes duplicate objects. It just uses the union expression passing in both of the arrays.
The Compose Combined No Duplicates action uses the following expression:
union(variables('Array1'),variables('Array2'))

The end result is:
[
{
"Name": "AAA",
"Title": "AAA"
},
{
"Name": "BBB",
"Title": "BBB"
},
{
"Name": "CCC",
"Title": "CCC"
},
{
"Name": "AAA",
"Title": "BBB"
},
{
"Name": "EEE",
"Title": "EEE"
}
]
Again, not sure if this is what you were after, but might help with part of the process (hopefully).