I am trying to archive data from a table in one SharePoint spreadsheet to a different table in another Excel file for archiving purposes. The trouble is that the two tables are not identical and the labels vary across them (think: "Task Description" vs "Task Details") so I can't just get rows and then add them to the archive.
I need to be able to tell Power Automate to populate values from table header "Task Description" to "Task Details" in the new table.
Is there a way to accomplish this? This would be a manually triggered flow.
I think the general flow structure would look like this:
Get rows table 1 > "Task Description Value" populates to "Task Details" in table 2 > Create Row
