Power Automate: Excel table KEEPS updating but It should only update once

Michael Cornwell 6 Reputation points
2022-07-13T14:03:16.173+00:00

Hi

I am trying to get data from a Form, this feeds into a spreadsheet (S1), from there I want a key piece of info to feed into another spreadsheet (S2). I have built the flow and S1 updates with no issues at all. However, S2 adds about 20 rows of the same information when I only want one row. I eventually want 6 spreadsheets feeding into S2 but cannot manage 1 at the moment!

I will paste the flow below:
220454-image.png

220389-image.png

Someone on another forum says I need to do this (have tried but do not know where to fit it):
220483-image.png

Any help gladly received.

Microsoft 365 and Office | Excel | For business | Windows
Community Center | Not monitored
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.