Unanswered

Patch to SharePoint list only works once

(0) Share

Report

Posted on by Manc_Gurl

254

My app contains a gallery, each item in the gallery has a view button, in the OnSelect property of the button I am using this function: Patch(Datasource, ThisItem, (ViewCount: ThisItem.'View Count' + 1});

If I run the app and press the button, the View Count column for the current item in PowerApps is incremented by 1 which is correct, however, this only works the first time I press the button, if I press it multiple times afterwards nothing happens in my SharePoint list. I just want to increment the view count by 1 each time the button is pressed but this doesn't seem to be working after the first press, what am I doing wrong? TIA.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Try:
Patch(Datasource, ThisItem, {'View Count': ThisItem.'View Count' + 1})
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Manc_Gurl 254 on at

Like (0)

Report
There was a type in my original post I noticed, it should have read:
Patch('Data Source', ThisItem, {'View Count': ThisItem.'View Count' +1})
I tried amending as per your instruction but I get the same results, works on the first press then nothing happens if I press the button again. I'm using a collection as the datasource on my gallery, the patch is going to my SharePoint list, the same list that is used to create the collection for my gallery. I can't understand why it increments the view count once but not again unless I restart the app.

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (1)

Report

The formula is ok. Thisitem refers to that particular item being clicked. So if the item is 3 clicking will make it 4. The issue is the Gallery is not refreshing to capture the new figure that's 4+1 to 5.

Since you are using a collection, you will have to refresh the collection. Is It on OnVisible of the screen, then after Patching, to to other screen for it to refresh.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Manc_Gurl 254 on at

Like (0)

Report

The Gallery does update, I am already refreshing it, the issue is the that the SharePoint list only gets updated once, on the first click of the button, any clicks thereafter do not update the SP list unless I close and restart the app. This is why I'm scratching my head, I don't understand why it only adds +1 once 🙂

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Once when you restart it work then it definitely go to do with refreshing or caching
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Manc_Gurl 254 on at

Like (0)

Report

I think I might have to start over with the button, it's giving me all sorts of crazy errors now even after deleting the function and typing a new one in. Something is not right. My gallery was refreshing and now it's not. 🤔

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

That is fine
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Manc_Gurl 254 on at

Like (0)

Report
OK it works now, I think your solution was correct, it was a refreshing/caching issue in the gallery so I will mark your answer as the solution 🙂

I eventually got it to work using this function in my button which sits inside my gallery items.

Patch('MyDatasource',ThisItem, {'View Count': ThisItem.'View Count' + 1}); Refresh('MyDatasource'); ClearCollect(MyCollectionName, 'MyDatasource')
The gallery is refreshing immediately after the button click and if I click the button again my SP list is updated again. Thank you for your help. Much appreciated.

Was this reply helpful? Yes No