Forum Discussion

MartinDUK's avatar
MartinDUK
New Member
3 years ago

How do I Use Text from Cell Drill Down as Data Source and File location.

  I have files in a Network Folder and have written a query to get the list of files from a Folder. Filtered the File name for the relevent file. Filtered the Latest file. Drilled down in the Cel...
Need Help
Show and Tell
Tutorial Requests
AlienSx's avatar
AlienSx
Super User
3 years ago

create blank query, open it with Advanced Editor and literally write the following 

 

let 
  // Source = Csv.Document(FilePath) - wrong!
   Source = Csv.Document(File.Contents(FilePath))
in Source

 

what do you get?  

MartinDUK's avatar
MartinDUK
New Member
3 years ago

I get the file and File Path, which I've already got.

How do i use this to import the Excel file displayed?

 

 

 

  • AlienSx's avatar
    AlienSx
    Super User
    3 years ago

    I am sorry, my fault. Try this please

    let 
  Source = Csv.Document(File.Contents(FilePath))
in Source