Forum Discussion
Append several SharePoint list sources. How to do it in M?
Hello everyone! I want to merge several SharePoint lists (around 100), with the same column names, but with different names and in different sites. I already tried to bring all tables and the...
Yes you can, I wrote a blog article on this once. Basically all you have to do is something like:
let
Source = ...
Source1 = ...
Source2 = ...
Final = Table.Combine({Source, Source1, Source2})
in
Final
Greg_Deckler
Community Champion
Community ChampionYes you can, I wrote a blog article on this once. Basically all you have to do is something like:
let
Source = ...
Source1 = ...
Source2 = ...
Final = Table.Combine({Source, Source1, Source2})
in
Final
ElizabethTachji
Helper III
Helper IIIHi Greg,
Thank you for code. amazing. How do I get a source sublist name for each row?