Plus Minus Buttons for inventory

(0) Share

Report

Posted on by Community Power Pla...

Hi there

I am looking to build an inventory app. What I have so far is the following:

Patch(Sheet3, TemplateGallery3.Selected, {Part1: Part1 -1})

All I'm getting are errors, and everywhere I read says to do it this way. Please help!

Also, if I want to build a list for one unit, it is my understanding here that the Patch() is like the following: Patch(Source, Row, {Column}). Example, if I have rows 1-3 set up in a sheet, can I set it up so that row 1, col 3 is "blue lugs" and row 2, col 3 is "red lugs" and row 3, col 3 is "black lugs" and so on?

Thanks in advance for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WiZey 3,023 Moderator on at

Like (0)

Report

Hello @Anonymous ,

Can you share the errors you are getting?

If I'm not wrong, you're trying to directly update the database. If you intend to click multiple times on your "Add" button, there is a risk where the updates may collide server-side.

I recommend you first update a local collection, then update the database with said collection.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@WiZey

The error I'm getting for this formula is "Name isn't valid. Identifier not recognized."
Patch(Sheet3, TemplateGalleryList3.Selected, {Part1: Part1 +1}) <-- Error location

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report
I tried on my side and understood why the error occurred.

You actually need to reference "Part1" from a source (from the item of the gallery).

Can you try this formula and see if it works?
Patch(Sheet3, ThisItem, {Part1: ThisItem.Part1 +1})

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Awesome! Thank you! There are no more errors now, but it still doesn't change any values in my table. I'm not sure what I'm doing wrong.

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report

It may by a lag from the server. Depending on your database, performance can vary greatly. Excel is the least recommended while DataVerse is the most recommended while others stand in-between.

If you still see no changes in your table for a while, I suggest you add a delay between each patch to avoid "updates collision" if you intend to directly update your datasource. Otherwise, I recommend you to actually apply all your updates in a local collection then patch with a button press to avoid such complications.

Was this reply helpful? Yes No