I would like to retrieve the answers to my questionnaire. But I get the same answer several times

Questions & Answers
1

Hello everyone,

Here is my automation. It allows me to retrieve the answers to my questionnaire and integrate them into various Excel tables.

The problem I’m having at the moment is that each answer can create several lines in my excel files. 1 response is entered 2 times, another response is entered 14 times, another response is entered 8 times. I don’t know what the problem is. I would like each answer to be entered only once in my excel.

Have you ever encountered the same problem?

2

Capture make 1
Capture make 11550×763 110 KB

My Automation

3

Hi @Chantepie

I could see that you have used “list work sheet rows” and for each row in the worksheet, it’s generating a table in all roots.
Therefore, my suggestion is to apply a text aggregator after the list module as the text data doesn’t contain the new response then only create table.

If the issue persists, please share a loom with explaining the issue.

MSquare Support
Visit us here
Youtube Channel

2 Likes