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
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!