Hey @Try
This you can do pretty easily in Power Automate Desktop. Follow the steps:
First use launch excel action and browse the excel sheet you want to use.
After this use action called first free row/column and pass the excel instance variable that you created in the 1st action. We are using this action so that we get the first free row, and we will run a loop till first free row-1. So that it runs till the last row.
Here is how the rest of the flow looks like:
After this use loop action and add the following in it. So it starts from 2nd row as first row would be headers and it will run till the last row and increment by 1.
After this use action, read from excel. And add the following: Here we are reading every value in column A which is of name.
After this use if statement and do the following: We are checking if the name column has a value Gt.
Then again use read from excel but this time we will be reading the 2nd column.
After this use set variable and add the value of excel2 which will have the value column of Gt:
After this use exit loop. So this will happen if you are able to find the value in your excel. So we will not check extra rows, we will just get out of the loop instantly.
I hope this helps.
