I have a Sharepoint list that records petty cash transactions. I have a calculated colum (BalanceSum) which works fine as long as there is an amount in StartBalance.
Is there a way in Sharepoint or in the associated powerapp to poulate the 'StartBalance' column of the next line with the previous line's 'BalanceSum' amount?
Go to Solution.
Hi @KevinHardy ,
Do you want to update all the records at the same time (update 'StartBalance' with previous line's 'BalanceSum')?
I suggest you try ForAll and Update function.
Try this formula:
Here's a doc about how to update multiple records for your reference:
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.