I have 2 sharepoint lists.
One list to store name and total account value (list1)
One list to store name and amount of money to add to the persons account. (list2)
I have a relationship between list 1 and list 2.
So that i can in powerapps see all rows in list 2 that are related to one row in list 1.
This works geat.
But now to my problem... i cant figure out how to make the calculations.
How to update the list1 value of account total from the input of a new row in list2.
input in list2 value 10 then add 10 to list1 account total on the row that is related to current list2 row.
In the future ill need to build also a extract thing, input how much to withdraw from the account total.
Could you please share more details of your two lists?
What are the column type of these two lists's columns? Lookup or single line?
You want to save caculations into the list, you can use patch and sum function to achieve that.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!