Update Sharepoint list every month

Copper Contributor

Hi, 

 

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!) 

 

 

 

1 Reply

@KaySmo so if your SharePoint list initially looks like this:0-SP-list.png

 

Your flow will be this:

 

1-Flow.png

 

2-Flow.png

 

3-Flow.png

 

and the result will be this:

 

4-SP-list.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User