Power Platform Community Forum Thread Details

I currently have an Excel spreadsheet that is the destination for the responses to a Microsoft Form I have created. The Excel and Form are already linked because I created the form initially through Teams. This form is used daily by several people at once, so responses are populated into the Excel constantly. We also have to continually make corrections and changes to the responses due to incorrect responses being entered (they accidentally put the wrong date, selected the wrong name, etc. - human error). I want to automatically copy all of these form responses to a second Excel spreadsheet using Power Automate, however I only want to copy specific columns, as not all of the columns are needed for the second spreadsheet. In this flow, I want to avoid duplicates in the second spreadsheet, as I do not want the same row copied/showing twice - however if there were any changes made to that row, I do want those reflected in the second spreadsheet. I do have a column with the form "ID" number which could be used as a 'unique identifier' if I need to use one when building this flow to avoid having the same row copied twice into the second spreadsheet. I plan to build the flow to run on an scheduled recurring interval of every 1 minute, unless I need to use a different trigger to accomplish what I need. This trigger seemed to make the most sense.

So, basically, anytime a row is added, modified or deleted in my first spreadsheet, I want to reflect those changes in my second spreadsheet and add any new rows that do not already exist in my second spreadsheet. I want my second spreadsheet to basically be an exact replica of my original spreadsheet, but obviously only the specific columns I choose will be on my second spreadsheet.

For the life of me, no matter how many hours I have googled, searched these forums, and harassed ChatGPT for answers, I cannot figure out how to build the flow to accomplish this. I have tried different ways that I've seen suggested, but cannot seem to find a flow that makes sense that will accomplish what I need. I thought about sending the form responses to the second excel directly from the form, but then that wouldn't account for any changes that were made directly in the Excel that contains those responses. Most of what I have found either is outdated info, doesn't include a portion of what I need, or is just plain wrong and doesn't make sense. LOL, someone please help me. I feel like this should be so simple, but yet here I am ready to pull my hair out! I hope all of this makes sense enough to find me a solution.. I have deleted the flow entirely that I started, because I ended up trying to build it so many different ways that I wasn't sure what was correct anymore, so I'm looking to start fresh with creating a new flow for this, so would need guidance on what actions/steps to use to accomplish this. I'm fairly new to Power Automate but have built a few flows so far and have been able to use it with ease so far. I'm a super fast learner, just need some guidance here lol

Categories:

Building flows