Dynamic Filepath for Excel Power Query Source

[lucausa75]

Dear All,

I have an Excel Power Query I need to make the Source as dynamic based on the value on MyPN!K2 cell as in the below screenshot


to have this line Source = Excel.Workbook(File.Contents("C:\TEST\MyFile\January2024.xlsm"), null, true), becaming Source = Excel.Workbook(File.Contents(MyPN!K2), null, true),

Any way to do it?
Thanks

 

[lucausa75]

Now I have the below issue:

Thanks

 

[RoryA]

You need Name="FilePath" not Name=FilePath in the first one.

 

[lucausa75]

Name="FilePath"

Great: now it works!
I have changed the first line from FilePath = Excel.CurrentWorkbook(){[Name="FilePath"]}[Content]{0}[DATA SOURCE] to FilePath = Excel.CurrentWorkbook(){[Name="FilePath"]}[Content]{0}[Column1]