Power Platform Community Forum Thread Details

Hi Community,

I have dataverse table with text columns storing integers and float values. I would like to find sum of these columns in flow.

I have used the below expression. There are possibility of some of the columns being blank, some with integer values and some with float.

Any help on having this implemented would be appreciated.

Expression

add(float(items('Apply_to_each')?['tech_jan']),float(items('Apply_to_each')?['tech_feb']),float(items('Apply_to_each')?['tech_mar']),float(items('Apply_to_each')?['tech_apr']),float(items('Apply_to_each')?['tech_may']),float(items('Apply_to_each')?['tech_june']),float(items('Apply_to_each')?['tech_july']),float(items('Apply_to_each')?['tech_aug']),float(items('Apply_to_each')?['tech_sep']),float(items('Apply_to_each')?['tech_oct']),float(items('Apply_to_each')?['tech_nov']),float(items('Apply_to_each')?['tech_dec']))

Error

Unable to process template language expressions in action 'Update_a_row' inputs at line '0' and column '0': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Thanks,

Categories:

Using flows