cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PhilipGoodfello
Level: Powered On

For each item, add 1 to sharepoint number column

I can believe I am finding this so difficult.

 

All I want do is:

Inside a For Each loop:

   Get the value of a column ('Reminders') - type number

   Add 1

   Update Item with new value.

 

I have the update working but have not cracked the "retrieve the value and add 1"

 

Tried:

1. Compose > Expression > Add('Reminders',1)    :  it says it is returning a string value

2. Using Initialize variable    : it says I can't use initialize inside For Each.

 

Surely this is really simple and I am missing the obvious - but google searches are not throwing it back to me!

 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
PhilipGoodfello
Level: Powered On

Re: For each item, add 1 to sharepoint number column

To answer my own questions:
 
Compose > Expression >  

Add(items('Apply_to_each')?['Reminders'],1)
 

Edit: to find the first argument for the Add function:
In Compose select ‘Reminders’ (or your column name) from dynamic content. Then, hover over it with the mouse pointer. The code for the expression shows up.

View solution in original post

1 REPLY 1
PhilipGoodfello
Level: Powered On

Re: For each item, add 1 to sharepoint number column

To answer my own questions:
 
Compose > Expression >  

Add(items('Apply_to_each')?['Reminders'],1)
 

Edit: to find the first argument for the Add function:
In Compose select ‘Reminders’ (or your column name) from dynamic content. Then, hover over it with the mouse pointer. The code for the expression shows up.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 349 members 5,110 guests
Please welcome our newest community members: