Flow adding additional rows when transmitting data from MS Form to Excel

[jbrunner]

My flow is set uop correct I believe, but every time I submit an response to my MS Form, there are two rows adding to my Excel spreadsheet. The first row added seems to be counter for the reponse and the second row added is the actual contect that I need.

So if the most recent responses were the first 5 responses then in my table it would display like this:

Row 1:     Column Title           Column Title             Column Title             Column Title

Row 2:              1                       

Row 3:     Response                  Response                Response                  Response

Row 4:             2

Row 5:     Response                  Response                Response                  Response

Row 6:             3

Row 7:     Response                  Response                Response                  Response

Row 8:             4

Row 9:     Response                  Response                Response                  Response

Row 10:             5

Row 11:    Response                  Response                Response                  Response

My flow is set up:

• List of responses
• Get response details 
  • Form ID
  • Response ID
• Add a row into a table
  • Location
  • Doc. Library
  • File
  • Table 1
  • Data from each MS Form response tied to a column header in my Excel spreadsheet

Before I moved my work to SharePoint this wasn't an issue. Everything worked fine, but since moving it all to SharePoint, this has become an issue

[v-yamao-msft]

Hi @jbrunner ,

Could you share a screenshot of your flow?

According to your description, I have created the flow likes below. However, the issue you’ve mentioned doesn’t occur on my side. The submitted response will only be added one time with no counter for the response.

Best regards,

Mabel

[jbrunner]

@v-yamao-msft  To be honest, I don't know how to add a photo to my message.

[jbrunner]

@v-yamao-msft  figured out how to get the image here.

[jbrunner]

@v-yamao-msft  here is a screenshot of the excel document as well.

[v-yamao-msft · Accepted solution]

Hi @jbrunner ,

Do you have any special formats in the Excel table?

Do you have any other flows that also works on this Excel file?

Could you please test with a different Excel file to see if the same issue still exists?

I have made more research and test, no similar issue could be reproduced or found. I am thinking if there is another flow that is working to add a row to the Excel file.

Best regards,

Mabel