Hello Community!
I am trying to create a Power Automate flow to populate data from a submitted Survey 123 form into an excel sheet on Sharepoint. I have most of the flow working, but I am having some trouble when I get to the repeats from the survey. I have added a "For Each" Action, followed by an "Apply to Each" action, then followed by an "Add a row into a Table" action, which seems to be the recommended workflow.
In the test survey, I added 2 repeats, just to make sure that the repeats were coming across correctly. For example, the group I have repeated is called Power Poles, so I can submit information for several poles in the field.
However, when the flow runs, I am not just seeing the 2 records for the power poles in the Excel sheet, I am seeing 4 records outputted, with 2 of each submission populated. Please see the photos for more information. How do I get each record to only show up once in the table? I have tried re-doing the flow several times and can't crack it. Thanks so much for any help!
