Forum Discussion

MyQueries's avatar
MyQueries
Copper Contributor
Apr 22, 2021

How to Get and add Power Query Table name in column

Hi All,

 

I have imported data from multiple files data from multiple locations from SharePoint site.

Ex table names are : Year 2015, Year 2016, Year 2017 ........

 

Now I want to add a new column in respective tables names. 

 

Can anybody suggest me , if there is any workaround or custom M code ?

 

 

excel

3 Replies

    • MyQueries's avatar
      MyQueries
      Copper Contributor
      Apr 22, 2021

      SergeiBaklan 

       

      For Example : Here I have 3 query tables , and now I want to add a new column with these query names in all 3 Query tables. 

       

      Right now I am adding manually adding these Query table names, but looking for a dynamic solution if we can add ? 

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 22, 2021

        MyQueries 

        Afraid you can't get current query name. However, querying SharePoint lists I guess you use parameters to define list name, why don't use the same parameter to add new column?

Resources