Forum Discussion
Unable to access SP file names using SharePoint.Contents over SharePoint.Files
The query below is to access the right SharePoint folder
The problem I am having is in another referenced query named "Emp_Snapshot_Dim" I am not able to access file names
It is only showing sub-folders as name- not actual file names within the sub-folders
How can I get file names because I need to extract the date from file name
Thanks, I can come on a screen share with anyone willing to help- thanks
With SharePoint.Contents you need to do the navigation yourself. It will not automatically include all the names from all the files in all the subfolders the way Sharepoint.Files does it.
2 Replies
- lbendlinSuper User
With SharePoint.Contents you need to do the navigation yourself. It will not automatically include all the names from all the files in all the subfolders the way Sharepoint.Files does it.
- GulianiGHelper II
Thanks lbendlin
As advised, I just had to click the expland icon on Content and I got all the file names
Can you help with a related question?
https://community.fabric.microsoft.com/t5/Power-Query/SharePoint-Contents-vs-SharePoint-Files/m-p/3424694#M111573