Converting multiple choice form answer into sum total

(1) Share

Report

Posted on by CU17021558-0

Hi,

I'm creating a form for holiday activities. I have a multiple choice question where people can select which activities they're interested in.

I want to use their selections to calculate how much they will owe.

Eg. If the options are:

- Archery (£10)

- Bowling (£5)

- Zoo (£15)

And the person selects Archery and Zoo, power automate will add up those values (£10 + £15), and send an email telling the person the total amount will be £25.

I have tried using switch to convert them into a numerical value, but am unsure how to create a sum from that.

Thank you so much!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Ravi-Prajapati 416 Moderator on at

Like (0)

Report
Copy link

Link copied!
ou can achieve this in Power Automate by following these steps:

1️⃣ Trigger: "When a form response is submitted"

Use "Microsoft Forms - Get response details" to retrieve the submitted answers.

2️⃣ Parse Multiple Choice Answers

The multiple-choice response will come as an array (e.g., ["Archery", "Zoo"]).

You need to assign values to each activity and sum them up.

3️⃣ Use a Loop to Calculate the Total Cost

Initialize a variable:

Type: Integer

Name: TotalCost

Value: 0

Use "Apply to each" to loop through the selected activities.

Inside the loop, use a condition or Switch case:

If "Archery" → Add 10 to TotalCost

If "Bowling" → Add 5 to TotalCost

If "Zoo" → Add 15 to TotalCost

Expression to update variable:

add(variables('TotalCost'), 10) // Replace 10 with correct value

4️⃣ Send Email with the Total Cost

After the loop, use "Send an email" action.

In the body of the email, include:

Thank you for signing up! Your total cost for the selected activities is £@{variables('TotalCost')}.

Alternative: Using an Array and Lookup

Instead of a Switch case, you can create a key-value array and lookup values dynamically:

Create an array in Power Automate:

[ {"Activity": "Archery", "Price": 10}, {"Activity": "Bowling", "Price": 5}, {"Activity": "Zoo", "Price": 15} ]

Use a loop to match selected activities:

For each selected activity, find the matching price and sum them.

Was this reply helpful? Yes No
CU17021558-0 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you Ravi!

I'm really struggling with step 3. I've attached a screenshot of my flow.

Could you please break down how to set up the switches?

Many thanks

Anna

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @CU17021558-0

Do this.

I created a form with a multi choice that looks like this. I want dad to be 5 points, mom 10 and partner 15

1. Trigger

2. Get response detail

3. create an INT variable and set it to 0

4. Create an Options Array variable and add this express

However, please change the body/rd3xxxx to YOUR dynamic property on your form
You have to change the STRING that gets passed in for your multi-choice (just like mine) to an actual array. Its not an array right now

Initially it looks like this when it comes in

["Dad","Mom"]

We need to do 4 things

1. replace the [ with an empty string

2. replace ] with an empty string

3. replace "" with empty string

4. then SPLIT the final part which looks like

Dad,Mom by the , and make it an array in the Initialiaze array action below

split( replace( replace( replace(outputs('Get_response_details')?['body/rd377696685054b2e953b800c210ba38c'], '[','') ,']','') , '"', '') ,',')

Now its time for our switch which is INside our Loop, which is looping on the Options array variable from the top

Then I just have an increment variable inside each case.

And then I have an ending compose JUST to show the value

Now when I run it and Select Mom and Dad from my Form I should get 15 points total

And I do

Was this reply helpful? Yes No