Looking for assistance/quidance for the following error message to solve it
Unable to process template language expressions in action 'Set_variable' inputs at line '1' and column '2223': 'The template language function 'add' expects its first parameter to be an integer or a decimal number. The provided value is of type 'String'. Please see https://aka.ms/logicexpressions#add for usage details.'.
Thanks and best regards
Solved! Go to Solution.
Thanks for the reply
The begin situation is as follows
1 Manual trigger a flow
2. Get items (sharepoint)
3 Initialize variable (set on float)
4. Apply to each (set variable)
add(items('Apply_to_each') ['GrossRiskS'], variables ('TotalAverageGrossScore'))
where do i have to put the compose action
Since you gave me your expression, we can try and simplify it by using the expression directly.
Try one of these:
If your GrossRiskS value is an Integer or a whole number use:
add(int(items('Apply_to_each') ['GrossRiskS']), variables ('TotalAverageGrossScore'))
If the value is a decimal use:
add(float(items('Apply_to_each') ['GrossRiskS']), variables ('TotalAverageGrossScore'))
Let me know if there are any errors.
This issue solved on the way as you suggested
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Fill out a quick form to claim your user group badge now!