Power Query - Hyperlink to file

[DaveyD]

I have a power query setup that imports tables from all excel files in a folder.
Is it possible to have a column that contains a link to the original excel file?

[I have this working in a regular excel table using the hyperlink function (which uses the customer name to get to the correct file). Now I want to convert that table to a power query table which makes automation much easier!]

Is it possible to get this automated with power query in any way?

Thanks,
David

 

[DaveyD]

Yes, BS is the name of the worksheet.
File is the name of the column in the table to make the replacement.

 

[UniqueName3]

Yes, BS is the name of the worksheet.
File is the name of the column in the table to make the replacement.

Thank you again! I couldn't get it to work with two columns (I think I need to go back to basics a bit, stop running before I can walk) so I just did two with statements. I really appreciate you coming back to help me, have a lovely day!