cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Daily flow to increment to SharePoint number column

Hi, 

I am attempting to use Power Automate to update items within a SharePoint list, based on a daily schedule.

If the Status column of the list is a specific value, I want to update a number column, Days Open, incrementing by 1.

 

here is the number column configuration.

DaysOpen.png

Here is details of the variable, where I use an expression for the addition of 1 based on the later condition. I have set the variable to both Integer and Float with the same outcome. I have also added the expression directly into the Update Item, within the Days Open field. the error is the same with both approaches.

DaysOpenVar.png

This is the error I receive;

error.png

Any assistance in resolving the error and allowing my scheduled workflow to add 1 to the (applicable) Days Open column is very welcomed.

I have captured the whole flow below for reference.

Many thanks
Kev

 

FullWorkflow.png

There are no empty values within the Days Open column within the list.

List.png

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @KevHouston ,

 

Please refer to screenshot to create the flow:

1.png

The expression in the flow:

add(if(empty(string(outputs('Compose'))),int(0),int(outputs('Compose'))),1)

 

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
v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

You don't need the variable, please refer to screenshot below to create the flow:

1.png

add(items('Apply_to_each')?['DaysOpen'],1)

 

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.

Hi @v-alzhan-msft


Thanks very much for taking the time to replicate & respond.

I have implemented the suggested changes. For those list items where the condition is true, an error occurs, captured below.

Any suggestions?


Sorry - could not embed the image - had to host online
https://ibb.co/VCpMtP6


Hi @KevHouston ,

 

Please refer to screenshot to create the flow:

1.png

The expression in the flow:

add(if(empty(string(outputs('Compose'))),int(0),int(outputs('Compose'))),1)

 

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.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,770)