Answered

Plus and Minus Buttons in a Gallery

(0) Share

Report

Posted on by Community Power Pla...

Hello, I am relatively new to Power Appa but am learning quickly. I am currently working on an app for managing our first aid inventory. I have a share point list (Inventory) where the columns include: Item, Expiration, QTY and PAR.

I have built a Gallery with the data from share point and have added 2 buttons, a plus and minus. I can get the buttons to add or subtract from the QTY by using Patch() but this is oftentimes slow to change the number in the app.

I am looking for a way to have the buttons add or subtract from the QTY number and then update the Share Point List once another button Confirm Changes) is clicked. I have toyed around with collect() but cannot get it to work.

Any help is greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous

We can use the collection to store the changes and update SharePoint when Confirm button is clicked. For example, an item will be added to the collection when you update row 2 in the gallery. So your collection has only the items updated. And you are updating row 5 like wise

In this case, We are updating Sharepoint only the items updated.

Thanks,
Stalin - Learn To Illuminate

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

Like (0)

Report

Thanks for the quick reply. I appreciate your time (and patience) with helping me. I am so close to completing this but have two obstacles:

The below image is my current layout. I am having trouble Patching the data to a collection when you add or subtract using the +/- buttons. I essentially want to Patch(Collection,InventoryGallery.Selected, {QTY: ThisItem.QTY +1}, {QTYChange: ThisItem.QTYChange})

The Quantity change (QTYChange) is defaulted to 0 and I have the white TextInput between the +/- buttons set to QTYChange so the user can see how many items they are adding or removing.

Once the user adds and subtracts all of their items, I then want them to click the Preview Changes button which will Navigate() them to another gallery that is filtered to only show their changes. On this screen, it will give them the option to confirm their changes which will then initiate the Collection() patch() into sharepoint.

The problem I am having is during the patch something goes wrong after the first successful patch and it will not work again.

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @Anonymous

I hope your patch statement might look similar to this
ClearCollect( Collection2, RenameColumns( Collection1, "ID", "newID" ) ); ForAll( Collection2 As Source, Patch( SPList, LookUp( SPList, ID = newID ), { ColumnName: Source.ColumnName // All other Columns } ) )

Note. You may need to rename the column to avoid name conflict.

Please share your code to assist more.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No