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

Michael Cornwell 1 Reputation point
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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
41,987 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,757 questions
{count} votes

Your answer

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