Hello,
I am using Power Automate Desktop to read an excel file with Invoice's and input them into a vendors web platform. It works and runs great; but I am trying to do a validation before hitting the submit button. After entering all the data into form and right before I submit it, it shows the invoice total that I am submitting. I want to grab that invoice total and compare it to the invoice total on the excel file.
What I am doing is not working; and I can't find a solution that works.
1. I am using Get details of element on webpage (this captures the total invoice amount on the webpage)
2. That variable I made as "OLinvoiceAmount and I verified the value it captured no problem
3. Here is the excel data that I am pulling from
4. I wrote an if statement to error out essential if the values do NOT equal. However this statement does NOT work. I can't figure out why not.
Any help is greatly appreciated.
