Hello,
I have a MS form that users can use to input their cost/labor data in order calculate a quote. Once submitted, the form responses are automatically added to the bottom of a table in an online Excel spreadsheet where I added new columns to calculate total costs (stored in column X under header 'Total Cost'). Every time a row is added due to a new form response, the row extends to these new columns. My objective to have a flow that sends the users back an email with their calculated total cost from column X so they know the quote number.
Here’s my flow:
- Trigger: MS forms when a new response is submitted
- Action: Get response details (Response ID is unique identifier)
- Action: List rows present in table
- Action: Delay 10 sec
- Action: Send an email (V2) with the following expression to extract latest value:
last(outputs('List_rows_present_in_a_table')?['body/value'])['Total Cost']
The problem: the value of X returns as '0' in the email when sent to Responder's Email.
I ran some tests and the expression will correctly retrieve static cell values generated by the original form response from the latest row added, but will always return cell values as '0' for cells with formulas in them.
Am I missing something?
Thanks!