Forum Discussion

martirl3's avatar
martirl3
Regular Visitor
6 years ago

Doing a PowerQuery with a Shareopint Library

I come over from  the PowerApps side.  It seems PowerQuery has its roots here.  Well, I was enjoying some new functionality with CDS Dataflow, and I was happily pushing some Sharepoint data into CDS using PowerQuery.  I came to the realization that none of my Sharepoint Lists were appearing as datasources.  I even tried to hack the name a bit in the statement to see if I could steal access, and no luck.  I would think that the fields in a Library would be equally retrieveable as those fields from a List.  I'm not finding this to be true.  So, is this possible?  

 

I did find another post asking this, but it was 2 years old, and no update.  They also mentioned adding an idea for this issue.  I looked there with no luck either.  

 

By the way, I dont just want metadata, I need all of the column data.  There is a way to get metadata, but that is not useful for my case.

 

 

 

 

 

I posted this over here too.

 

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Getting-Sharepoint-Library-data-into-a-Dataflow/m-p/538625#M4913

Need Help

6 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi martirl3 

     

    To get a list of your lists you can just use the below, it will return everything that you have access to.

    What are you trying to do? 

    let
  Source = SharePoint.Tables("https://company.com/sites/Engineering/")
in
  Source

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    • martirl3's avatar
      martirl3
      Regular Visitor
      6 years ago

      Mariusz ,

       

      THat method only shows lists, not libraries.  

       

      I need the data fields from a library.

      • martirl3's avatar
        martirl3
        Regular Visitor
        6 years ago

        Mariusz ,

         

        There is a Sharepoint Folder option.  That shows the libraries, but you only get file metadata.  No list/column data.  

         

        I'm not savvy with all of the interfaces into powershell, but I'm using the interface from PowerApps, the Dataflow section.  I'm not sure if its different in other places.