Saving "Email with Options" response in Excel

[adehaan11]

I'm trying to build a flow that sends emails asking whether somebody is working from home or not. 

The setup is as follows (screenshots of workflow below): 

1. Scheduled email sent out at 9am.

2. Pulls emails addresses from an excel list

3. New column is created in excel sheet with header name of today's date (24/03/202).

3. For each email address, an "Email with options" is sent. 

4. The responses for each recipient should be stored in the newly created column (from step 3)

The part where I am stuck is that I cannot select the data to be stored in the newly created column. Flows does not see that this column exists yet - Therefore I cannot add the response. 

My current workflow

Any help or alternatives are much appreciated! 

[efialttes · Accepted solution]

@adehaan11 

The problem is, you are dynamicly adding a column to your excel during flow execution. Since your own flow was designed before adding the column, that's the reason new column is not reflected in your 'Update a row'

It would happen also if yo apply the same approach on a Sharepoint list. Need to change the strategy...

My suggstion is to have an excel with two tables:

one table with email address + name

The second table with 3 columns: email address, date, status

So everyday you add a row per employee on this second table, storing email address on first column, date the question was made, answer (at home...)

So if you have 4 employees, after 5 days asking you will have 20 rows in this second table

Hope this helps

[adehaan11]

Thanks @efialttes  for the quick reply and thorough explanation!

Instead of keeping the update row, I changed it to "Add a row". 

Seems to work now. 😃