Hello everyone,
I want to set an if condition in a for each loop with the previous currentitem than Power Automate Desktop did read in a Excel sheet.
In order to don't do an unnecessary action, because the data did not change.
For instance the if condition would be If currentitem[Colomn Name] <> previouscurrentitem[Colomn Name]
Thank in advance
Nicolas
Solved! Go to Solution.
During the loop,
set a variable called prevItem as currentitem[Column Name]
That way you can check If currentitem[Column Name] <> prevItem
Yes @ERKO_TECH_Nicol , you can put it at the end of loop. I just mentioned "during" the loop. So you can put it where it suits your requirement.
During the loop,
set a variable called prevItem as currentitem[Column Name]
That way you can check If currentitem[Column Name] <> prevItem
Thanks @VJR
But the variable will be update when its excetuded, so it has to be at the and of the loop, the if condition compare to the previous "Unupdated" Item ?
Yes @ERKO_TECH_Nicol , you can put it at the end of loop. I just mentioned "during" the loop. So you can put it where it suits your requirement.
Perfect, Thanks a lot !