Comparing two lists, different entities, same content
Hello, I'm working on a project involving two different lists. These lists contain different entities but share the same content. I'm currently trying to compare both lists based on their IDs and want to store the matches and mismatches in respective tables (individual entities for each). In the microflow, I can compare two lists using list operators, but it seems they only work with identical entities. I would greatly appreciate a prompt response. Best regards.
So if I understand correctly you have two different entities but both entities contain the same attributes and you want to find the same object in the other entity with the exact same content.
I would then create an export mapping of the objects so you then have all the contents in one string so you can then match those strings in the other entity. Or creates hashes of that string so you could see if there is a same hash in the other entity.