Answered

Increment SharePoint list column by 1 each time an icon/button is clicked.

(0) Share

Report

Posted on by KVCBC

Hi everyone,

I have a SharePoint list called innovation station. This list contains a number column called "gong votes". My power app has a gallery that contains a button that when people click should add +1 to the gong votes column of that particular record.

I have tried Patch('Submitted Innovation Ideas',ThisItem,{'Gong Votes':ThisItem.'Gong Votes'+1}). This seems to not update the list at all, it doesn't give me an error but just doesn't update the list at all.

Note I have tried both with the icon and button.

Any Ideas I am really stuck now!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @KVCBC ,

Try this to evaluate the incremented value before patching it:

With( {_IncValue: ThisItem.'Gong Votes' +1}, Patch( 'Submitted Innovation Ideas', ThisItem, {'Gong Votes':_IncValue} ) )

Was this reply helpful? Yes No
Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Unless you are inside a gallery the concept of thisItem doesn't really mean anything. So I think you'll have to use Lookup in some fashion to get the Item and Patch it to Increment the value.

Patch(Gong,LookUp(Gong,Title="Test"),{Gong:LookUp(Gong,Title="Test").Gong+1})

Was this reply helpful? Yes No
KVCBC 36 on at

Like
a
(0)

Report
Copy link

Link copied!
I am inside a gallery. The first gallery displays the items from the record the second displays the images.

This still doesn't increment the list
With( {_IncValue: ThisItem.'Gong Votes' +1}, Patch( 'Submitted Innovation Ideas', ThisItem, {'Gong Votes':_IncValue} ) )

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KVCBC ,

Unfortunately I wasn't able to replicate this issue. With both your original formula and my suggested one, the number type column in SharePoint increased by 1 after triggering.

Try using Monitor to see what's happening in the background when running the formula on your end. More information on how to use Monitor can be found here: https://learn.microsoft.com/en-us/power-apps/maker/monitor-canvasapps

Was this reply helpful? Yes No
KVCBC 36 on at

Like
a
(0)

Report
Copy link

Link copied!

It is so strange. I have opened the monitor and clicked the button but it doesn't register the clicking. The only event logged is when I clicked the back button.

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Perhaps there's some other control in front of the gallery which blocks the button? Try moving the gallery to the front to rule this out.

Was this reply helpful? Yes No
KVCBC 36 on at

Like
a
(0)

Report
Copy link

Link copied!

I have moved the gallery to the front and still nothing 😞

Was this reply helpful? Yes No
KVCBC 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok I just changed the button's on select to Back(ScreenTransition.Fade) and still nothing so it might be a problem with the layout. The button does hover a different colour and is clickable.

Was this reply helpful? Yes No
Verified answer

KVCBC 36 on at

Like
a
(1)

Report
Copy link

Link copied!

Solved it the gallery itself was in view mode instead of edit! Thanks for your help!

Was this reply helpful? Yes No