Forum Discussion
Solved
Unable to pull file names in folder
Hi ALL, I am using Power query to get file names in a folder . Get data --> from file --> from folder Unfortunately I am having too many file subfiles which is cross 200,000 rows and un...
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcraKiQlJzS1Qio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Folder" = _t]),
FolderContents = Table.AddColumn(Source, "Contents", each Folder.Contents([Folder])),
Expand = Table.ExpandTableColumn(FolderContents, "Contents", {"Name", "Extension", "Attributes", "Folder Path"}, {"Name", "Extension", "Attributes", "Folder Path"}),
Kind = Table.ExpandRecordColumn(Expand, "Attributes", {"Kind"}, {"Kind"}),
MySpecificFolder = Table.AddColumn(Kind, "Specific_Folder", each if [Name]="xxxx" and [Kind]="Folder"
then Folder.Contents([Folder Path]&[Name]) else null)
in
MySpecificFolderStéphane
Hi,
Use Folder.Contents, not Folder.Files
https://learn.microsoft.com/en-us/powerquery-m/folder-contents
Stéphane
Hi Stephane,
Thank you for the quick response. Thats the perfect solution and could you please help me little further.
From the above I am getting list of folder names and from that will select one and need file names from the specific folder