
I have 3 Extracted invoice lists that is stored in 3 different share point list, I have to compare/match the 3 invoices list and need match result:
Eg Invoice 1{Item Name:"Bag","Book" ; Item Price: 220,100 ; Total: 300 },
Invoice 2 {Item Name:"Bag","Book" ; Item Price: 220,100 ; Total: 350 }
In the Given example we could see total is not matched, Then we have to mail Admin what is not Matched.
How can i create a match using Power Automate, and If list Format is wrong, Kindly suggest how it should be done for better result.
Clarifying My Question
1. (3 invoices from different User ),
2. Invoice 1{Item Name:"Bag","Book" ; Item Price: 220,100 ; Total: 300 },
Invoice 2 {Item Name:"Bag","Book" ; Item Price: 220,100 ; Total: 350 }
Invoice 3 {Item Name:"Bag","Book" ; Item Price: 220,100 ; Total: 300 }
invoice 1 and invoice 3 is same but not invoice 2. Here, we need to say where it is not matched and what is not matched