Update Sharepoint list every month

%3CLINGO-SUB%20id%3D%22lingo-sub-2278055%22%20slang%3D%22en-US%22%3EUpdate%20Sharepoint%20list%20every%20month%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278055%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20Sharepoint%20list.%20It%20has%20a%20number%20column%20named%20%22total%20number%20of%20points%22.%20It%20only%20consist%20of%20one%20row%20with%20the%20number%2010.%26nbsp%3BI%20use%20this%20list%20for%20my%20power%20app.%20My%20employees%20can%20see%20their%20current%20number%20of%20points%20and%20redeem%20points%20in%20this%20power%20app.%20But%20every%20month%20they%20receive%20%2B1%20point.%20I%20want%20to%20update%20my%20Sharepoint%20list%20column%20named%20%22total%20number%20of%20points%22%20every%20month%20with%20%2B1%20so%20that%20it%20also%20automatically%20updates%20in%20my%20power%20app.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%20in%20April%20everyone%20has%2010%20points.%20I%20want%20to%20automatically%20add%20%2B1%20point%20on%20May%201%20so%20that%20the%20total%20number%20of%20points%20changes%20tot%2011.%20On%20June%201%2C%20the%20number%20of%20points%20will%20then%20change%20to%2012%20and%20so%20on.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20flow%20with%20a%20reccurance%20trigger%20set%20on%20every%20month.%20Then%20there%20is%20an%20action%20with%20Sharepoint%20with%20update%20item.%20I%20just%20don't%20know%20which%20formula%20to%20use%20so%20that%20it%20adds%20%2B1%20to%20%22total%20number%20of%20points%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20someone%20can%20help%20me.%20If%20you%20need%20more%20information%20please%20let%20me%20know.%26nbsp%3B%3C%2FP%3E%3CP%3E(English%20is%20not%20my%20native%20language.%20Sorry%20for%20the%20spelling%20mistakes!)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2278055%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2278102%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20Sharepoint%20list%20every%20month%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278102%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1030502%22%20target%3D%22_blank%22%3E%40KaySmo%3C%2FA%3E%26nbsp%3Bso%20if%20your%20SharePoint%20list%20initially%20looks%20like%20this%3A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%220-SP-list.png%22%20style%3D%22width%3A%20678px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273776i6C2CB54D2519B710%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%220-SP-list.png%22%20alt%3D%220-SP-list.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20flow%20will%20be%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-Flow.png%22%20style%3D%22width%3A%20579px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273779i3A18196628DA26C9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-Flow.png%22%20alt%3D%221-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-Flow.png%22%20style%3D%22width%3A%20583px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273778i08EFD50E960A5280%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-Flow.png%22%20alt%3D%222-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223-Flow.png%22%20style%3D%22width%3A%20566px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273777i1BCC108A66D05916%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223-Flow.png%22%20alt%3D%223-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20the%20result%20will%20be%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%224-SP-list.png%22%20style%3D%22width%3A%20680px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273780iF8E44D15AD946FE1%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%224-SP-list.png%22%20alt%3D%224-SP-list.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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