none
Get data the sharepoint list, inside subsites RRS feed

  • Question

  • How to query data from a SharePoint list, inside subsites?
    I have a collection of sites with numerous subsites, I need to get data from a custom list (always same name and GUID) on several subsites.
    Any tips?

    Torres

    Thursday, August 17, 2017 9:33 PM

Answers

  • Hey,

    Here's a few things that you need to do:

    1. Get the root url of each subsite. Example: My main url is https://powerbipanama.sharepoint.com/ and my subsite rooturl is https://powerbipanama.sharepoint.com/sites/sales/

    2. Connect to just one subsite and to the list inside that site (using the SharePoin Lists connector). Apply all of the transformations that you need, add a parameter and convert that query into a function. Here's a full deep dive on how to create parameters and functions inside Power Query: https://www.youtube.com/watch?v=GgwXt4LVmsU

    3. Create a table with all of the urls in one table similar to what I did on this video: https://www.youtube.com/watch?v=qFxvTJy1w5o

    4. Apply the function created in the point #2 to every row in the point #3

    That should give you everything that you need.

     

    Thursday, August 24, 2017 2:51 AM

All replies

  • Hey,

    Here's a few things that you need to do:

    1. Get the root url of each subsite. Example: My main url is https://powerbipanama.sharepoint.com/ and my subsite rooturl is https://powerbipanama.sharepoint.com/sites/sales/

    2. Connect to just one subsite and to the list inside that site (using the SharePoin Lists connector). Apply all of the transformations that you need, add a parameter and convert that query into a function. Here's a full deep dive on how to create parameters and functions inside Power Query: https://www.youtube.com/watch?v=GgwXt4LVmsU

    3. Create a table with all of the urls in one table similar to what I did on this video: https://www.youtube.com/watch?v=qFxvTJy1w5o

    4. Apply the function created in the point #2 to every row in the point #3

    That should give you everything that you need.

     

    Thursday, August 24, 2017 2:51 AM
  • Hey, 

    That one is a really great option. However, when you try to transform Sharepoint list data into Binary it doesn't work. In the link https://www.youtube.com/watch?v=GgwXt4LVmsU you talked about, the guy shows how to create a binary function.

    What can we do to pass throught this?

    Tuesday, May 28, 2019 6:40 PM