Forum Discussion
Hogstad_Raadgivning
Feb 11, 2020Iron Contributor
get data, dynamic path to folder
Hi, I have an Excel document stored at Sharepoint. It use Get data, and it should be used by more than 1 person at the same time. Since all is not experienced users, is it possible to use a ...
JKPieterse
Feb 11, 2020Silver Contributor
Hogstad_Raadgivning I would suggest to put the entire link you're pulling the data from into a separate, named, cell and use instructions like these to have the query read the cell. That way you can use formulas to "build" the correct path and filename.
https://www.howtoexcel.org/power-query/how-to-reference-a-named-range-in-power-query/
https://stackoverflow.com/questions/26989279/how-can-i-reference-a-cells-value-in-powerquery
https://accessanalytic.com.au/powerquery_namedcells_parameters/