Unanswered

Seeking Solution for Calculating Total Cost for Multiple Items in Excel Using Power Automate

(1) Share

Report

Posted on by AB21

Objective: I have a form that functions as an order sheet, with data transferred to an Excel sheet. In the Excel sheet, I maintain a list of items and their respective prices in a 'Menu Costs' sheet. My aim is to create a formula or modify a Power Automate workflow to calculate the total cost for a list of items extracted from Power Automate. These items are enclosed within square brackets and separated by commas when multiple items are selected.

Menu Cost:

Screenshot 2023-09-19 at 13.08.04.png

Current Formula for a Single Item: =VLOOKUP(E2,'Menu Costs'!A:B,2,FALSE)*C2

Sheet 1:

Screenshot 2023-09-19 at 13.06.53.png

Form question for food options:

Screenshot 2023-09-19 at 14.32.26.png

Question: Can Power Automate be utilized to calculate the cost for multiple items within the 'Food Options' column and accumulate them into the 'Total Cost' column?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

trice602 15,989 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @AB21 ,

Here's a working solution from another question I answered last week; works good!

Initialize two variables as shown below.

Here's the expression for temp1 above:

add(variables('sumtotal'),int(item()))

This works well and will loop through your array and add up the numbers. I like this option very much and is my current go-to model.

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report
Copy link

Link copied!

Hi @trice602 Thanks! So where does the output go? I need go into the excel if thats possible? I also need this display the items in a column "Food option" and and displays the cost in the column cost.

Was this reply helpful? Yes No