Microsoft Forms to Excel Business (online) and then to email all in one Flow - is it possible?

[rnloka]

I am presently having two separate/individual Flows as follows and am wondering if it is possible to combine into single Flow that will be trigerred by "When a response is sumbitted".

Flow 1: - Triggerred by "when a response is submitted", the Microsoft Form collects responses and sends an email as acknowledgement with Form data as the email body.

Flow 2: - Triggerred by "recurrence" - this transfers the row data from Excel Sheet in the tab to another tab, copies to a third tab and finally sends an email after which the Flow then deletes the Excel sheet row from the Form Data Tab. This Flow 2 requires that i have a key column - and i presently doing it manually by entering a value in this column.

My query - I was wondering if the above two flows can be combined into one flow and get rid of the manual creation of the key column and its data - so that the moment a form response is received, the data is processed by Flow and then: -

(1) send an acknowledgement email;

(2) get row(s),

(3) insert rows(s) in an excel sheet - another tab as record of the form submission data;

(4) insert row(s) in another tab of the same excel sheet where other columns get populted with calculations

(5) send email with data from the form submission plus data from the calculated columns

(6) delete the row(s)

End

[v-yamao-msft]

Hi @rnloka,

About Flow2, it requires a key column and you are doing it manually by entering a value in this column. Could you share more details on the key column?

About step4, it seems that you are going to insert rows from tab1 to tab1 within the same Excel sheet. What do you mean by “Columns get populated with calculations”?

From the screenshots, it seems that you are also using the Google sheet? Do you want to insert row into the Google sheet either?

Best regards,
Mabel Mao

[rnloka]

Mabel, Thanks for the kind reply.

I have introduced a column to satsfy the Key Column requirement. I have titled this column "Sent for Scheduling - Yes or No?" and then on each row - after i glance through the wntry - i enter the "yes" manually under this key column. This is then the trigger for further processing of the row data by the Flow.

Besides the Columns that are populated by the Flow by extracting information entered in Microsoft Forms by respondents, I have further columns in the excel sheet that have their respective cell values based on formulas related to data entered by respondent.

Google sheet inserting of rows is to generate a QR Code for each respondent - which i found is the easiest way to do - as i could find any equivalent in Exx

I can share further information as you may need.

[rnloka]

Mabel,

Thanks for the kind reply.

Rewriting the reply as noted many typo errors in my earlier reply.

I have introduced a column to satsfy the Key Column requirement. I have titled this column "Sent for Scheduling - Yes or No?" and then on each row - after i glance through the entry - I enter the "yes" manually under this key column. This is then the trigger for further processing of the row data by the Flow.

Besides the Columns that are populated by the Flow by extracting information entered in Microsoft Forms by respondents, I have additional columns in the excel sheet where their respective cell values are based on formulas related to data entered by respondent.

Google sheet inserting of rows is to generate a QR Code for each respondent - which I found is the easiest way to do - as I could not find any equivalent in Excel.

I can share further information as you may need.

[rnloka · Accepted solution]

Hello All,

I have managed to figure out a way of combining the two separate flows into one as in the snapshot herewith.

I would like to thank all who were patiently trying to assist me in this.Combined Flow 1 and Flow 2 into one single Flow

[GabrielStJohn]

Hey, @rnloka!

Thank you for posting to the Flow Community Forum! It appears you have found a solution to your issue! If you feel as though your issue has been solved and you are satisfied with one of the previous replies, please click "Accept as Solution" on the reply that contains the solution so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Microsoft Flow Community Manager

[rnloka]

Thanks Gabriel,

I have marked as suggested.

This should help all users in future.