Saving "Email with Options" response in Excel

(0) Share

Report

Posted on by 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!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

efialttes 14,756 on at

Like (1)

Report

@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

Was this reply helpful? Yes No
adehaan11 18 on at

Like (0)

Report

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. 😃

Was this reply helpful? Yes No