Forum Discussion
Xiaohu_Liu
Apr 17, 2023Copper Contributor
Can we use R to read list data in SharePoint?
Can I read the list data from SharePoint into R and convert it into a dataframe for use? Thank you very much for your answer!
NikolinoDE
Apr 17, 2023Platinum Contributor
Yes, you can use R to read list data from SharePoint Online.
You can use the Microsoft365R package to access data stored in SharePoint Online sites.
You can retrieve the items in a list as a data frame using the list_items() function.
This function has arguments filter and select to do row and column subsetting respectively.
I hope that I could help with that!