Power Platform Community Forum Thread Details

My requirement:

'Workbook1': 'SDG', sheet 1, table: 'WHODDSDG'

'Workbook2': Dynamically created, get stored in SharePoint library. I can run the script using Power automate flow, when the file is created. 'Workbook2': name- dynamic, sheet 1 which has table Power App, and sheet 3 which has table 'WHODD'.

When this new file ('Workbook2' is created, data is entered into table 'Power App').

Note: Table 'Power App' in sheet 1 of 'Workbook2' only has 'one column' with the header 'All Hierarchy'.

Now I want to run the script(s), whereby column 'A' in table Power App in sheet 1 of 'Workbook2' matches the data in column 'N' ('Final Hierarchy') of table "WHODDSDG" in sheet 1 of 'Workbook1' (that is SDG). Once the data is matched, I want the matched data from all the columns of table 'WHODDSDG' in sheet 1 of 'Workbook1' (SDG) to be pasted onto table 'WHODD' of sheet 3 of 'Workbook2'.

Note: table 'WHODD' has headers exactly same as headers in table 'WHODDSDG'. Identical.

@DamoBird365 Can you please help. I have many videos and trying to replicate but not getting it right.