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!
Solved! Go to Solution.
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
Proud to be a Flownaut!
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
Proud to be a Flownaut!
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. 😃
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
24 | |
18 | |
16 | |
13 |
User | Count |
---|---|
137 | |
44 | |
32 | |
32 | |
29 |