Hi All,
I'm pretty new to PowerApps and I'm trying to work out how to build a scoring system in SharePoint Lists/PowerApps.
I have the list all setup and several forms working fine. The last piece of the puzzle is to get the scoring sorted. It's very simple. If a billy carts with ID number "4" comes first they get 3 points added to the tally. 2nd gets 2 points, third gets 1 etc. I have the ID number column and a Score column setup and I'm trying to setup a simple form with 3 number inputs for 1st, 2nd and 3rd where we would put in the cart ID. Then a submit button. Clicking the button would simply add the points to the score of the corresponding cart.
Here is the button formula I have been trying to work out. I have just been trying to get it to work with first place and once I figure that out i'll add 2nd and 3rd.:
Patch('Race Results', LookUp('Race Results', ID = fpid), {Score: Sum(Value(ThisItem.Score),3)})
fpid is the text input box "First Place"
spid is the text input box "Second Place"
tpid is the text input box "Third Place"
Here is the form - not pretty or finished. I'm just trying to get it functioning first
Results List:
Any help would be greatly appreciated.
Cheers
Ryan
