Apr 22 2021 07:14 AM
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 ?
Apr 22 2021 07:23 AM
Not sure I understood the question. There is Add custom column in the menu.
Apr 22 2021 10:24 AM
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 ?
Apr 22 2021 12:38 PM
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?