Forum Discussion

vincetaylor's avatar
vincetaylor
Icon for Helper I rankHelper I
4 years ago
Solved

Add a new table to dataset

I am using a series of SharePoint lists that exist on a SharePoint site. as my data source. I previously used "Get Data" to add the lists as table to my dataset. A new SharePoint list has been added ...
Need Help
  • aj1973's avatar
    aj1973
    4 years ago

    vincetaylor 

    In Power Query the List 4 should be embeded in the navigation step. Click on the source step you will see 

    Try to find there and add it to the queries
    Before adding the List 4 copy/paste one of the Lists in the queries and then click on the Table to get it added to the Queries, Rename the new added Table

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

vincetaylor yes, I'm thinking specifically the "Navigation" step is what would need altered to include your new list.  

By clicking the "gear" icon next to that step you can edit it.

 

vincetaylor's avatar
vincetaylor
Icon for Helper I rankHelper I
4 years ago

Thanks again Anonymous 

How do I edit?
There is no edit button or such. I tried double clicking and right clicking on the table I want to add

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    vincetaylor what does the M code for the step look like?  You can find it in the formula bar or by clicking "Advanced Editor".

     

    • vincetaylor's avatar
      vincetaylor
      Icon for Helper I rankHelper I
      4 years ago

      HI Anonymous 

      This is the code with some data obscured or changed

       

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        vincetaylor ok after looking at your code and re-reading your original description I am now very unclear about what you are trying to accomplish.

        What is the output of this query?  A single table?  Or multiple tables?  The SharePoint.Tables function being used seems that it would only return a single table of all the items from a single list.  Are you looking for the items in a list, or a list of lists?

        Please be as descriptive as possible about what you're trying to achieve.