Forum Discussion
Can we add multiple sharepoint lists dynamically through some parameter and merge their data ?
- 8 years ago
Yes, turn your query into a function with the URL as parameter.
Then create a table with one column, containing the adresses in the rows. Then add a colum where you call your function and pass the reference to this column with the URL as a parameter.
You can then expand this new column and will have all your data in one table, with one additional column: The source where it came from (your URL).
Yes, turn your query into a function with the URL as parameter.
Then create a table with one column, containing the adresses in the rows. Then add a colum where you call your function and pass the reference to this column with the URL as a parameter.
You can then expand this new column and will have all your data in one table, with one additional column: The source where it came from (your URL).
- joris7 years agoFrequent Visitor
I can't seem to get this to work. I created a new column based off the URL (as a parameter: https://company.sharepoint.com/) and the customerID, but it doesn't give me the option to expand it
- ImkeF7 years agoCommunity ChampionDoes this help?: https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi-and-power-query-in-excel/
- joris7 years agoFrequent Visitor
I missed the step where you turn the query into a function. I've tried this but no luck so far.
So I start with connecting to my source URL via sharepoint list connector (eg https://company.sharepoint.com/sites/internal/)
and then I turn that table into a function?