Daily flow to increment to SharePoint number column

[Anonymous]

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.

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.

This is the error I receive;

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

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

[v-alzhan-msft]

Hi @Anonymous ,

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

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.

[KevHouston]

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

[v-alzhan-msft · Accepted solution]

Hi @KevHouston ,

Please refer to screenshot to create the flow:

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.