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.
Solved! Go to 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.
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.
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:
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.
User | Count |
---|---|
88 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
128 | |
48 | |
46 | |
27 | |
26 |