Update a row from MS forms in Power Automate to Excel

[shaf_2021]

I want to create an MS forms that will need to update rows whenever there are changes made in the MS forms. For example if a user in Jan has to complete 5 things then he will add it in the MS forms and it will be directed to the Excel using Power Automate but in the month of Feb he has different things in his mind and he changes it again I want it to be updated like the row values instead of it adding a new row. In addition to this there will be a switch case where the responses will be transferred to different excel sheets according to what department they are in that will be asked in the MS forms. If they are in IT department then the responses will be transferred to the IT Excel sheet, likewise if they are in the Sales department then the MS forms responses will be transferred to the Sales Excel sheet. So I want these conditions to be satisfied. Please help me in this?

[royg]

Hi @shaf_2021,

According to the described requirements, you probably have a MS Forms form set for organization users (otherwise you can't collect the submitter info). You can either have a single response per user (+ allow editing responses) or allow multiple responses per user (with disabled edits).

You probably have multiple Excel files located in SharePoint/OneDrive with a Table inside that can contain the user answers (it should have a row per user email with the response answers and probably the submission date).

Next, you'll need to create a flow triggered by form submissions. You can start with a template or blank flow and select the correct trigger. 

After the trigger add Office365 Users action to find the user by the submitter email in order to identify the department.

Add a switch action and add the available departments. For each department update the corresponding Excel file:

Get the table rows, filter by submitter email if found update that row, otherwise create a new one.

That's the process as I would implement it, you probably need to get your hands dirty now...

Roy