I have two Excel workbooks in SharePoint where I'm trying to copy an entire worksheet (Worksheet 2) from an Excel file named "MasterTest" to another worksheet of the same name, with the same columns named "MasterCopy".
I've built a Flow to Get worksheets and an Apply to each loop to Get a row, but this continues to fail, stating there's no table found with the name Worksheet 2. These have not been converted to tables. My question is, can a SharePoint Excel worksheet from one Excel file be copied to another worksheet from another Excel file in the same folder?