Returning sum of value-based answers from Microsoft Forms

(0) Share

Report

Posted on by bbpdk

Hi!

I'm working out a Flow to send a mail to a specific mailbox with the values of questions answered in a Form.

5 questions asks the user to enter values.

I need those 5 values to be summed up and returned as a total in the mail sent.

It's an estimate for workshop costs.

For example I need it to sum the costs of "engine" and "transmission", both of those answers are number-values in the Form created.

I can't figure out how to do this, I'm sure it's extremely simplet, but I'm lost.

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Jcook 7,781 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello @bbpdk ,

Here are the basics of what you want to accomplish.

Steps

1. Trigger: Microsoft Forms - When a new response is submitted
Form ID: {Your form name}

2. Add action: Microsoft forms - Get response details
This will create a apply to each loop with list of responses inside.

3. Add actions: Data Operations - Compose
Inputs: use expression-- float() --add your dynamic content of the answer inside the parentheses
** Do this for each of your answers in your form **

4. Add action: Data Operations - Compose
Inputs: use expression-- add() --add the outputs of each compose from above separated by a coma inside the parentheses

** Note that the flow will fail on whole numbers. The float expression is looking for a decimal floating point number **

Here are some screenshots:

Hope his helps!

-Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
bbpdk 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot @Jcook , it was exactly that I was looking for!
All numbers whole numbers, so I used the expression -- int() -- instead of -- float() --

Was this reply helpful? Yes No
Colin2 2 on at

Like (0)

Report
Copy link

Link copied!

Hi JCook,

My problem is almost the same as the above, however I have gone one step further. I have already added a formula in the table where the Microsoft Forms responses are stored. This formula sums up the survey results and also give a standard interpretation in another column in the same table.

I now have to email this interpretation back to the respondent.

Tried many ways like get row, or list row but it will either not work or it keep sending many emails from the previous responses again too.

Thanks in advance.

Colin

Was this reply helpful? Yes No