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

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
Highlighted
Community Support
Community Support

Re: Daily flow to increment to SharePoint number column

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
Highlighted
Community Support
Community Support

Re: Daily flow to increment to SharePoint number column

Hi @Kev_Houston ,

 

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.

Highlighted
Frequent Visitor

Re: Daily flow to increment to SharePoint number column

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


Highlighted
Community Support
Community Support

Re: Daily flow to increment to SharePoint number column

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,830)