Hi all,
I have a SharePoint list with columns A, B. We want to set the value of A based on the value of B of the previous row. See illustration below. Thanks
A | B |
0 | 10 |
10 | 17 |
17 | 30 |
Hi!
In Lists there should be an "ID" column that may be hidden. Set a integer variable as the ID of the new item.
You can use the "Decrement variable" action to decrement by 1 to get the ID above your current item.
The flow should look something like this:
Then you can map Value A and Value B to your liking.