cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hasanmu442dn
Regular Visitor

Adding +1 value when flow is running on specific column

that is possible to create logic flow, when flow running always added +1 in spesific column. for details is below. I have list "Revoke User O365", that have 5 column. i wanna automatically update the column "Number", with value +1 every day.  flow.png

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @hasanmu442dn ,

 

Does the "Revoke User O365" list have only one item?

Does the Number column is a Number type column?

If the Title column value would always be unique?

 

I have made a test to create a list as below:

3.png

 

If the Title column value would always be unique and the Number column is a Number type column, you could refer to screenshot below to create the flow:

1.png

 

The expression for the Number column as below:

add(if(equals(items('Apply_to_each')?['Number'],null),0,items('Apply_to_each')?['Number']),1)

 

The flow would run successfully as below:

2.png

 

Please let me know if your problem could be solved.

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

3 REPLIES 3

Hi @hasanmu442dn 

 

There are a couple of ways which you could approach this, however I like to use the add expression. You can use the expression either in the Update Item action for SharePoint, or you can do this within a variable and then use the variable in Update Item.

 

add(<the SharePoint dynamic content goes here>,1)
v-alzhan-msft
Community Support
Community Support

Hi @hasanmu442dn ,

 

Does the "Revoke User O365" list have only one item?

Does the Number column is a Number type column?

If the Title column value would always be unique?

 

I have made a test to create a list as below:

3.png

 

If the Title column value would always be unique and the Number column is a Number type column, you could refer to screenshot below to create the flow:

1.png

 

The expression for the Number column as below:

add(if(equals(items('Apply_to_each')?['Number'],null),0,items('Apply_to_each')?['Number']),1)

 

The flow would run successfully as below:

2.png

 

Please let me know if your problem could be solved.

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Greetings sir

 

would this solution work if the column contains date and I want to increase number of days?

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,898)