I have Sharepoint Library that looks like a standard MS Explorer File structure (Folders and Files). The top folders is the name a customer. I would like to have a dropdown cell list that looks up those top folders to allow look up of customers already there.

I am able to create a link to sharepoint, using >Data>Get Data>From Online Services>From Sharepint Online List, and can "see" folders, but dont know how to create a dropdown list to select a desired customer folder.

Hope this is enough info...if not what more is needed.

Steve