How to get the Previous %CurrentItem%

[ERKO_TECH_Nicol]

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

[VJR · Accepted solution]

During the loop,

set a variable called prevItem as currentitem[Column Name]

That way you can check If currentitem[Column Name] <> prevItem

[ERKO_TECH_Nicol]

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 ?

[VJR · Accepted solution]

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.

[ERKO_TECH_Nicol]

Perfect, Thanks a lot !