Replacing column names with dynamic values from another table

Hi,

As per our understanding, you want dynamic Columns where Column name should change based on another Tables Columns Values.

In order reproduce your requirement we have created two test Tables , Table1 and Table 2 as shown in the below screenshot,

Then Navigate to Power Query Editor where add first column as Fieldname,

For the Table2 open Advanced Editor and Insert below this line with Source Variable,

 #"Renamed Columns" = Table.RenameColumns(#"Source",Table.ToRows(Table1))    

in

    #"Renamed Columns"

Now when we change the Column FCODE to FCode changed this will automatically reflect changes in another table header as well.

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Services

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at [email protected]

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/