Hello
I want to compare, by a Power Automate Flow, 2 JSONs that have the same keys but can differ in key values. The goal here is to get the amount of keys that have the same value, as it follows:
JSON1 - that has the correct answers
{
"Answer 1" : "a",
"Answer 2" : "b",
"Answer 3" : "d",
"Answer 4" : "a",
"Answer 5" : "c",
"Answer 6" : "b",
"Answer 7" : "d",
"Answer 8" : "b",
"Answer 9" : "a",
"Answer 10" : "c"
}
JSON 2 - that has the given answers
{
"Answer 1" : "a",
"Answer 2" : "b",
"Answer 3" : "d",
"Answer 4" : "a",
"Answer 5" : "b",
"Answer 6" : "b",
"Answer 7" : "d",
"Answer 8" : "b",
"Answer 9" : "d",
"Answer 10" : "c"
}
In that case, I want to obtain the value 8, since all the 10 keys of the 2 JSONs, except by the keys "Answer 5" and "Answer 9", have the same values