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:
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
Solved! Go to Solution.
Hi @Anonymous ,
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
Hi @Anonymous ,
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
Hi @Anonymous ,
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
User | Count |
---|---|
89 | |
41 | |
22 | |
20 | |
16 |
User | Count |
---|---|
138 | |
56 | |
47 | |
36 | |
26 |