Forum Discussion

Xiaohu_Liu's avatar
Xiaohu_Liu
Copper Contributor
Apr 17, 2023

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!

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Xiaohu_Liu 

    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!

Resources