Answered

How to get next value in a list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

hi,

I have a list that I am trying to calculate the difference between the values of current row and next row, but I am not sure how to get the next row value in a list.

I tried using:

For each CurrentItem in List

If %List + 1% - CurrentItem = 1 Then

Add item CurrentItem to AnotherList

End

PowerAutomate Desktop doesnt prompt me an error on that but it also doesnt do anything to populate the AnotherList.

I thought about creating a 2nd list (lets call that List2) then remove List[0], then loop the list like List[%LoopIndex + 1%] - List[%LoopIndex%], but it still wouldnt populate the AnotherList.....

and since PAD cannot create a new column in Excel, I cant just write those 2 list in 2 columns and do the math there either....

any thought on how can I do this?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous
Try this flow (steps 1-2 may be different depending on how you get your list, here I simulated capturing values from an excel worksheet):

‘Launch Excel’ with the file you want to capture list
‘Read from Excel worksheet’ to capture the range of values. This gives you %ExcelData% as variable produced (the list to be worked)
‘Create new list’: name it %ResultList%
'Loop': Starts from = 0, End to = %ExcelData.RowsCount -2%, Increment by = 1. This gives %LoopIndex% as produced variable
‘Set variable’: %ExcelData[LoopIndex]%. Define %CurrentItem% as variable produced
‘Convert text to number’: Text to convert = %CurrentItem%. Define %CurrentItem% as variable produced
‘Set variable’: %ExcelData[LoopIndex+1]%. Define %NextItem% as variable produced
‘Convert text to number’: Text to convert = %NextItem%. Define %NextItem% as variable produced
‘Set variable’: %NextItem-CurrentItem%. Define %Result% as variable produced
‘If’ %Result% = 1 then
‘Add item to list’, Add item = %CurrentItem%, Into list = %ResultList%
‘End’ (of If conditional)
‘End’ (of Loop)
This can be optimized, but worked fine in test.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

hi @Anonymous,

thanks that works!

I have another question about the syntax for the variables, do we only need to use %% when we define a new variable? I was confuse about when to use %% around a variable and I thought it is needed for every variable.... thats why in my OP I put something like %List[%LoopIndex%]%

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

According to PAD documentation Variable manipulation and the % notation - Power Automate | Microsoft Docs:

Was this reply helpful? Yes No