Power Automated Calculator

Question

Hi all,

This has been causing me a challenge for the last week now. The idea is as follows:

We need to track software costs associated with staff, so a form is used where we input manually the software and hardware someone requires (Apples in below example), then we calculate the cost and send the request to the purchasing team.... I'd like this to be one form that once filled out, completes calculations and sends emails to the relevant people. Like follows....

Microsoft form is filled out --> Data is imported to excel --> Text from the multiple choice is converted into a number (an apple is worth £1, so it now will display "1" instead of "Apple") --> Excel then will add these numbers from the multiple choice import ("1,3,7,10,1") and enter that value to a cell --> An email is then sent of the data from the form and the total cost --> "Name, Position, Total Cost"..... --> Completed flow.

The issue is power automate will not read the cell with total cost - it purely displays 'VALUE' or nothing at all.... the form works, updates a row, sums all the costs, but will not send the cell number in the email?

I've tried a power query table which displays 'raw numbers' and no formula, but the row will not update automatically (even with a script) because this is not available on Power Automate.

How can I get this flow/ Excel to work?

Many thanks

Charlie

Answer 1

Power automate is not currently supported here on Q&A. The product group for Power automate actively monitors questions in dedicated forums here. https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

--please don't forget to upvote and Accept as answer if the reply is helpful--