Unanswered

Need flow to populate data from one table in Excel to another table using table headers to determine where to populate the data

(0) Share

Report

Posted on by jlsaville Microsoft Employee

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

ScottShearer 25,268 Most Valuable Professional on at

Like (0)

Report

@jlsaville

Actually, what you want to do is very easy.

You'll use a button trigger to start the Flow and then a SharePoint get items action. Loop through all of the rows and add rows to the Excel table inside of the loop (add a row to a table action). You simply select the SharePoint column that should be placed in each column of the table.

Let me know if you need a better example.

Was this reply helpful? Yes No
jlsaville Microsoft Employee on at

Like (1)

Report

I'm not sure this will work because both documents are Excel spreadsheets that are stored on SharePoint. They're not SharePoint lists. Am I missing something?

Was this reply helpful? Yes No