Forum Discussion
hawke
Advocate I
Advocate IColumns missing when connecting to nested MS Teams folder
I am connecting to an MS Teams Channel where the documents folder has numerous layers of nested subfolders. The files I need are buried several levels down. Additionally, some columns have been added...
I was able to use the steps outlined in this video and was able to modify it to work for my needs https://www.youtube.com/watch?v=RuQwIr9XXMM&t=379s
Akash_Varuna
Super User
Super UserHi hawke You can use the SharePoint API with Power Query’s Web connector to retrieve all custom columns and nested folder metadata. Or could you try to combine the SharePoint Online List connector for metadata and the SharePoint Folder connector for nested folder structure, merging them in Power Query. Writing a custom M query can also help traverse the folder structure while pulling all columns. Power Automate is another option to extract metadata and save it for Power BI access.