Getting calculated value from Excell into email

[wiaderekkm]

Hi, 

I feel that this should be easy but for some reason I fail to implement that. I have a form that people fill out. I figure out how to sent email and update my Excell spreadsheet on OneDrive. Before I sent an email (or in the separate email) want Excell to do some calculation (that is based on impute from the form) and insert the calculated value in the email. My emails come back without that value. Test shows everything is fine. 

Thank you for suggestions. 

Kamila

[sandeepstw]

Hi There,

To include calculated values from Excel in your email using Power Automate, you can follow these steps:

1. Create a flow in Power Automate and set the trigger to the appropriate event, such as when a new form response is submitted.

2. Add an action to retrieve the data from the Excel spreadsheet. Use the "List rows present in a table" action and configure it to connect to your Excel spreadsheet on OneDrive. Select the table that contains the data you need for the calculations.

3. Add a step to perform the desired calculations based on the form input. You can use various actions depending on the specific calculations you need. For example, you can use the "Compose" action to perform calculations using expressions or the "Excel - Run calculations on table" action to run Excel functions on the retrieved data.

4. Store the calculated value in a variable. Use the "Initialize variable" action to create a variable and set its value to the calculated result.

5. Add the action to send an email. Use the "Send an email" action and configure it with the desired recipients, subject, and body.

6. In the email body, include the calculated value by referencing the variable you created in step 4. For example, you can use the following syntax: The calculated value is: @{variables('CalculatedValue')} .

7. Save and test your flow. Submit a new form response and verify that the email includes the calculated value.

Make sure to adjust the actions and their configurations based on your specific environment, form, and calculations. If you encounter any issues or need further assistance, please provide more details about your form, the calculations you're performing, and the specific actions you're using, so I can help you troubleshoot more accurately.

[Humdinger2006]

Hi Kamila,

Did you ever get this to work for you?  I am trying to do the same thing.

Person submits a form > the flow puts the response data in Excel > a calculation is done in Excel based on the response data > the flow sends an email with the calculated value.

I am having the experience that the calculation appears in my Excel file, and the email is sent as expected, but the calculated value is blank in the email.

Maybe the answer is that the calculation needs to happen in the Flow, but I hope not. 

Thank you!

E

[wiaderekkm]

My working flow has following steps 

1. When a new response is submitted - trigger

2. Get the response details (forms)

3. Add a row into a table (excel) 

4. List rows present in a table (excel) 

5 compose (data operation) In the input the expression should be last(outputs('List_rows_present_in_a_table')?['body/value'])

6. Parse Json

Content : outputs from step 5

Schema: "type: "object",

"properties": {

"@@odata.etag": {

"type": "string"

}, 

"Name of the column with calculated value": {

"type": "string"

}

}

}

You can list as many columns as you want (this is full item expression :

}, 

"Name of the column with calculated value": {

"type": "string")

it will generate new items on your dynamic content. Than you just paste them in emails etc. 

I hope this helps. 

Kamila