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 ...
Need Help
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.

      • Mariusz's avatar
        Mariusz
        Community Champion
        6 years ago

        Hi martirl3 

         

        Sorry, I'm probably not much help as I have no idea about Power Apps, but I think that Connectors should be the same across  the platform ( Power Apps/Bi ) 

        You can check what SharePoint.Contents do if you haven't yet?

        https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contents 

         

         

        Best Regards,
        Mariusz

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

        Please feel free to connect with me.
        LinkedIn