I am creating a flow that runs daily to create items in a SharePoint list. It first checks to see if the item already exists, if not...then it creates it in the list, and updates a number column to 1. This part works just fine.
If the item already exists, I want to increase the value in the number column. So if the value in the number column is 1, I want to increase to 2. When it runs the next time, if that value is 2, I want to increase it to 3...I have not been able to get this to work.
How do I go about getting this done?
Solved! Go to Solution.
Hi @Spawn10
Your flow looks like fine! So I would check if the "NumberOfReviews" is null or empty, although I think it should never be because when you create the item, you initialize it to 1. Could you use this expression?:
add(int(coalesce(item()?['NumberOfReviews'],1)),1)
Apart from that, is that column an integer one?
Regards,
Ferran
Hello @Spawn10
Using the add() function you can sum some numbers. Could you share a screenshot of your flow, so we can provide more detailed help?
Regards,
Ferran
Hi @fchopo
Thanks for the response. Here is what my flow is currently looking like...
my add() looks like this
add(item()?['NumberOfReviews'],1)
Hi @Spawn10
Your flow looks like fine! So I would check if the "NumberOfReviews" is null or empty, although I think it should never be because when you create the item, you initialize it to 1. Could you use this expression?:
add(int(coalesce(item()?['NumberOfReviews'],1)),1)
Apart from that, is that column an integer one?
Regards,
Ferran
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
53 | |
41 | |
39 | |
38 | |
35 |
User | Count |
---|---|
76 | |
72 | |
71 | |
54 | |
49 |