1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to request from Power Query file contents SharePoint web site

I was wondering how to request file contents from SharePoint

I know how to request a xlsx file from web contents the M code is like this:

= Excel.Workbook(Web.Contents("https://abc.sharepoint.com/sites/.../.../.../.../.../.../.../file.xlsx"), null, true)

but how to request the files in a folder from the web not from a local PC

this is the M code example to request from the a local PC:

= Folder.Files("C:\Users\name\OneDrive - abc\...\...\...\...\...\...\Month updates")

submitted by /u/k012sxaQ
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article