Unanswered

Calculating Sum

(0) Share

Report

Posted on by Mario69

Having a little trouble getting a final feature to work on my automate flow. I have a Microsoft Form that populates a SharePoint list. My form asks users if they will require a software in the coming year. If they do, a running total is calculated based on the price of the software.

For example:

"Will you require Photoshop?"

Yes/$1500

"Will you require Creative Cloud?"

Yes/$500

"Will you require Office 365?"

Yes/$2000

"Will you require Chrome?"

Yes/$1000

If a user chooses yes, I'd like to simply add all values and update the SharePoint column with the total cost.

I'm having an issue in my compose function, however. I'm trying to use this as my calculation:

add(var1, add(var2, add(var3, add(var4, var5))))

My variables were initialized as integers, but I'm getting the below error:

The runtime value '"add(var1, add(var2, add(var3, add(var4, var5))))"' to be converted doesn't have the expected format 'Number/double'.

Here's my flow

Any suggestions would be appreciated!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Can you try the following:

add(variables('var1'), add(variables('var2'), add(variables('var3'), add(variables('var4'), variables('var5')))))

Was this reply helpful? Yes No
Mario69 42 on at

Like (0)

Report

Thanks for the response @grantjenkins . I've tried your suggestion, but I'm still getting an error on my format.
The runtime value '"add(variables('var1'), add(variables('var2'), add(variables('var3'), add(variables('var4'),variables('var5')))))"' to be converted doesn't have the expected format 'Number/double'.

add(variables('var1'), add(variables('var2'), add(variables('var3'), add(variables('var4'),variables('var5'))))).

Also, should I be calling my 'Total' compose at any point?

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

Are you able to show a screenshot of your actual expression? Also, what you are putting in the other actions to get a better idea of where the issue is?

Was this reply helpful? Yes No
Mario69 42 on at

Like (0)

Report

@grantjenkins Let me know if you'd like me to expand any other sections.

Was this reply helpful? Yes No
Mario69 42 on at

Like (0)

Report

Here's an example of one of my variables. I've tried using string and integer as my type but no success

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
It might be just how you are accessing your variables. To access the variable show in your screenshot you would use:

//Instead of variables('var2') //You should use variables('Revit')

Was this reply helpful? Yes No
Mario69 42 on at

Like (0)

Report

Yes sir. That was my issue. Thanks @grantjenkins

Was this reply helpful? Yes No