0

I am working from SharePoint.

I would like to COPY AN ENTIRE Excel Sheet-A from Spreadsheet A and Paste it into another Sheet, Sheet-B on Spreadsheet B using Microsoft Power Automate.

Some important things to note:

  1. Sheet-A does not have column names (I know).
  2. There are no Key values or Key Columns. Just random information.

Is there a way to go about this?

Koketso M
  • 15
  • 1
  • 8

1 Answers1

0

Unfortunately PowerAutomate really wants you to have your information in a table if you want to move or manipulate the data and wouldn't it be so useful to have a "Duplicate Sheet" function and copy n paste of individual cells.

If your sheet with the random data happened to be in a single large table, then this may work by apply to each item when navigating the underlying table.

Ewen
  • 389
  • 4
  • 15