Create Inventory Add/Remove Functions

[LauradeBoer]

Am brand new to PowerApps and trying to create a simple app for inventory tracking of field gear (shovels, hoes, etc.), showing whether it's in a company storage locker or out with one of our employees. I'd like "Add" and "Remove" buttons that will increment inventory by one each time it's pressed, but haven't been able to create a working "Add" button just for adding new inventory to the storage locker, let alone buttons that will add to an individual's column while removing it from the locker. Am generating this from an Excel spreadsheet and have tried using the Patch function, not sure if another would be better in this situation.

[LauradeBoer]

Okay, cool! The only error I'm getting now is a Control?

[Anonymous]

Yes, you're passing the control instead of the item within that control. It should look something like this:

Patch(Testing, ThisItem, {'Storage Locker':Value(DataCardValue2.Text)+1})

If this doesn't work, try replacing ThisItem with ThisItem.Parent, if that doesn't work we'll go from there.

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

[LauradeBoer]

Thank you! No change in the error with either option, unfortunately.

[Anonymous]

What is the DataSource property of DetailForm1?

[LauradeBoer]

It's showing as [@Testing]

[Anonymous]

Paste this into your formula bar

Patch(Testing, [@Testing], {'Storage Locker':Value(DataCardValue2.Text)+1})

I noticed you were missing an apostrophe and a closing parenthesis in your last argument.   

[LauradeBoer]

It's now looking for a Record rather than a Table, I think? I'm sorry, I'm not sure about the distinction.

[Anonymous · Accepted solution]

Sorry this is taking so much back and forth. I set up a test on my end and this is working, so try this. When you first set up your app you had a gallery called BrowseGallery1. That's the gallery you use to select an inventory item. We can use that reference.

Patch(Testing, BrowseGallery1.Selected, {'Storage Locker':Value(DataCardValue2.Text)+1})

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up. 

[LauradeBoer]

Yes, that works! Thank you so much! I will play with this to see if I can branch out to the other buttons. I might need to make another forum post tomorrow if I'm not able to go from here, but for now, we've got one button working!

[Anonymous]

Good deal! Feel free to tag me if you make a new post and we can pick up where we left off.