•1 min read•from 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")
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#no-code spreadsheet solutions
#Power Query
#SharePoint
#M code
#file contents
#Excel.Workbook
#Web.Contents
#xlsx file
#folder
#local PC
#request
#OneDrive
#file
#URL
#file path
#data extraction
#cloud storage