I have a Sharepoint list. It has a number column named "total number of points". It only consist of one row with the number 10. I use this list for my power app. My employees can see their current number of points and redeem points in this power app. But every month they receive +1 point. I want to update my Sharepoint list column named "total number of points" every month with +1 so that it also automatically updates in my power app.
For example: in April everyone has 10 points. I want to automatically add +1 point on May 1 so that the total number of points changes tot 11. On June 1, the number of points will then change to 12 and so on.
I have a flow with a reccurance trigger set on every month. Then there is an action with Sharepoint with update item. I just don't know which formula to use so that it adds +1 to "total number of points".
I hope someone can help me. If you need more information please let me know.
(English is not my native language. Sorry for the spelling mistakes!)