Hello,
Struggling with this for some reason. I thought this would be straight forward but no.
I have ten columns and each holds its own numeric value.
At the end I have a total column that is currently a calculated column and as you are aware calculated columns dont work well in Power Automate. I tried creating integer variables to hold the value of each field and then summing them this way.
add(variables('intImage'),add(variables('intCalculated'),add(variables('intHyperLinkPicture'),add(variables('intPersonGroup'),add(variables('intYesNo'),add(variables('intLookup'),add(variables('intDateTime'),add(variables('intChoice'),add(variables('intMultiLineText'),variables('intSingleLineText'))))))))))
The Expression saves ok but when I run it, it complains.
All of the fields and variables are integer
Any suggestions?
Thank you!
