Dynamic File Path

[arosenberg]

Hello All,

I am attempting to create a Power Query that uses a specific location but with different folder names and then picks up whatever file(s) are in that dynamic location. As an example

\\network\files\Client1\*.*

\\network\files\Client2\*.*

\\network\files\Client3\*.*

So the goal would just be to use an excel file with the names of Client1, Client2 and Client3 in order to change that location to the specified client and then pick up all files in that folder.

Can someone help me out with this? Let me know if you have any questions.

Thanks in advance

[Anonymous · Accepted solution]

Hi @arosenberg ,

You can replace the Client part of your connection path with a parameter, and connect to files under different paths by selecting a different Client in the parameter:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dufoq3 · Accepted solution]

Hi @arosenberg, 

1.) create dropdown list in Excel:

2.) Create Named Range I choose "SelClient" and send it to PowerQuery:

3.) In Power Query right click inside the cell and choose Drill Down

4.) Create new query from FOLDER and edit address like this:

[Anonymous · Accepted solution]

Hi @arosenberg ,

You can replace the Client part of your connection path with a parameter, and connect to files under different paths by selecting a different Client in the parameter:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.