I need to setup a power automate flow between two excel spreadsheets with a table in each spreadsheet, to copy the text from two columns (in this case it’ll be Notes) into a column on a table. For example:
Project - User - Notes (These are the Columns)
ExcelOutput (spreadsheet 1)
Super Activities - John - Prepare to get started
ExcelOutput2 (spreadsheet 2)
Super Activities - John - Activities have started.
ExcelOutput2 Now has
Super Activities - John - Prepare to get started. Activities have started.
All of the tables have the same column names. Use the Project column and see if they’re equivalent across each spreadsheet to determine where to paste.
(The powerflow should use the Project name column to identify equivilance.)