Ok, I have been scratching my head enough and have scoured the internet for answer to this one without success. So any help is enormously appreciated
I am building an equipment booking/loan system in Powerapps and with a SharePoint list as its data source. it all works ok except for one thing. how do I restrict the quantity the client can book to the number that is available on the shelf when client decides to change the quantity they have already booked.
So there is a box on the form which shows clients the available quantity. If the client exceeds that when they initially book, I can flag that up as error. That's easy because I can compare what's available with what the client types into the input box as they are in separate boxes. My question is this:
- Client books 10 cameras while there are 15 on the shelf and submits the form
- Client changes their mind and decides they need 6 more. So they edit the form and put 16 in the same input field that already contains 10
How can I check the updated quantity does not exceed the total on the shelf?
I tried storing the current number in a variable and compare that with the updated number client inputs. But I didn't manage to get it to work. Essentially, is there a way to compare the updated content of an input field with the previous value it contained?
Thank you
eg
