Creating a dynamic folder name

[Monsignor]

I have folders G1, G2, G3

The goal is to, for example, select G2 with a dropdown list and have Power Query import the contents of folder G2

My filepath=> C:\Users\MyStuff\Desktop\G1

I've made parameter tables to make variables for entire filepaths for different computers, but am struggling to just change the folder name.

 

[gazpage]

In the M code the ampersand concatenates strings, and the filepath within the code is just a string.

So if you have created a text Parameter called parFolder then you would change part of the code that looked like this:

... ="C:\Users\MyStuff\Desktop\G1"

to

... ="C:\Users\MyStuff\Desktop" & parFolder