Forum Discussion
Can we add multiple sharepoint lists dynamically through some parameter and merge their data ?
Suppose we have multiple different SharePoint sites with same data schema and I want to query all of them dynamically based on say an initial query with the list of sites and merge the data. Is it possible ?
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).
7 Replies
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).
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
Did you ever find a solution to schedule refresh ?
