Forum Discussion
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 environment varialble to get the username? Replace the start of the source path, so it works for every user
Best regards
- Geir
1 Reply
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/
