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.

[Anonymous]

You would use Collect(), not Patch() to add a new entry. Patch() is to update a current item.

[LauradeBoer]

Does it count as a new item, though, if I'm trying to increase a number in an existing cell by one?

[LauradeBoer]

e.g. am not trying to add a new item, but am looking to have 6 shovels available instead of 5, or later, to have one shovel in my inventory and one less in the storage locker.

[Anonymous]

No, that would require Patch(). Sorry, I misread your question. Is DataCardValue2 the name of your column in Excel? In your screenshot you're trying to update the excel file's DataCardValue2  column to DataCardValue2  + 1 when it should probably be something like this:

{YourColumnName:DataCardValue2.Value+1}

[Anonymous]

So seeing your second screenshot, you would use

{'Storage Locker':DataCardValue2.Value+1}

[LauradeBoer]

Thank you! I'm getting a "name isn't valid" message still though - can you tell what I've missed? I tried subbing in the "_x0020_" for the space in "Storage Locker," but no change.

[Anonymous]

You may need to use

Value(DataCardValue2.Text)

instead of DataCardValue2.Value.

Looks like the Item argument is throwing an Error also. What is the DataSource for DetailForm1? That's more than likely what you need to replace that with.

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

[LauradeBoer]

Thanks! I think I've got the corrected DataSource now, if I'm understanding correctly what it wants. The name error is gone, but I'm not certain what the "unexpected characters" are in this case.

[Anonymous]

You're missing a comma after the second argument. It wants the item to update, so it could be something like Gallery1.Selected or ThisItem, etc..