Power Platform Community Forum Thread Details

Insert a response from a MS Form to an existing Excel sheet

I need some help with the flow; please see the screenshot.

We created an MS form register attendees for an event. The options for responses are Attend alone, attend with partner, will not attend.

We prepared an Excel sheet with two tabs that is linked to our database (where all those who receive the invites are listed). The first tab is the connection to the database and the second tab is linked by formula to the first tab. In other words, all information in second tab is retrieved from the first tab. Except that we have one additional column on second tab called Attending where the responses are to be recorded from Forms. The second table is an table called table2. So far we have been doing this manually, but we are sure it must be possible to create a flow to do this that links the specific Form with the Excel sheet. All information entered to create the flow is correct up to a certain point. But something is going wrong because we keep getting the message "The result must be a valid array" .The flow should look up the Excel sheet for the matching email address and then fill the result in an empty column.

For example, the form result in this flow has a field "alleine". The flow should enter the digit one into Excel's "attending" field.