Power Platform Community Forum Thread Details

I have a gallery with some buttons. Everytime a button is clicked, it will count + 1 in my Sharepoint list in de column Clicks. At this point every user has edit permission on this list, but soms users will only get View permissions.

I was thinking, maybe I can make it work with read only permission by using a Power Automate flow, but I cannot figure out how to do this. I don`t have a license, so at this point I can not use premium connecters/functions.

Can someone point me in the right direction with de Power Automate flow, or perhaps there is a better way to do this?

Categories:

Building Power Apps

Hi @JustOscar ,

The below solution is without using any premium connectors.

Flow with Form Submission:

This approach utilizes a flow with form submission and doesn't require premium connectors:

a. Power Apps Gallery Button:

Instead of directly updating the SharePoint list on button click, submit a form to the flow.
b. Power Apps Form:

Create a hidden form within your Power Apps gallery. This form can simply have a text field for storing a value (e.g., "Increment").
c. Flow Trigger:

Set the flow trigger to "When a new item is submitted." This triggers the flow whenever the hidden form is submitted.
d. Flow Actions:

Within the flow, utilize the "Get items" action to retrieve the current counter value from the SharePoint list (assuming you have a "Clicks" column).
Parse the retrieved value to an integer and add 1.
Use the "Update item" action to update the SharePoint list item with the new counter value (Clicks + 1).

Benefits:

This approach works for users with read permissions on the SharePoint list.
It avoids premium connectors and functions.

Drawback:

Users need to submit the hidden form to increment the counter, adding an extra step compared to directly clicking a button.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Sunil Pashikanti - Tech Blog: PowerApps