
Announcements
I have a worksheet where I fill in some data and when I press the button, it moves this data to another worksheet using VBA but I need to make it online and VBA does not work on OneDrive/SharePoint. It literally cut cells from one spreadsheet to another spreadsheet.
My idea is to use Power Automate for this, but I don't understand how I can do this, I couldn't find any connector that is what I'm looking for and when I go to create from scratch nothing makes sense.
I would like to ask for a direction of where to start, please.
Power Automate predominately interacts with Tables rather than Cells.
so you can do a trigger of “when a new row is added” for Excel and just use the action “add a new row” to your other table to copy the values over.