Hi all,
I've been wrestling this for the past few days, and wondered if anyone can help. I am trying to send an email to Form respondents with a summary of
I have a survey set up in MS Forms to collect real time data for inspections. The excel table (Table 1) linked to the form has a few additional columns appended to it where I've applied rules and logic related to the data (ie: if col A="yes" AND col B="no", then col X="PASS"; col z is a sumifs fx to calculate the total inspections completed in a month). This all works really well in Excel Table 1.
Where I am struggling is populating a summary email with dynamic values. I thought I could add Dynamic Values using "Send an Email v2" using the html editor to reference the appropriate summary columns (ie: col x: PASS/FAIL output, col z: total inspections complete this month). Theoretically it works, but the email Dynamic values are not being returned for any of the appended columns. I've tried adding multiple delays in the flow, but these don't seem to help.
As my most recent attempt, I created a separate Table 2 to capture the summary data and pull dynamic values from Table 2 only. Even from this, the only data I get is data collected directly from the Form on Table 1.
Here's a high level view of that most recent flow - I realize there are probably more "delays" here than I need, especially because they don't help anyway, it seems. Previous attempts basically resembled the below, but did not include the 3 separate "Table 2 steps".
Any help is greatly appreciated - apologies if this has been tackled elsewhere in the forum.
