Forum Discussion
Brendan_McLaren
7 years agoFrequent Visitor
Multiple SharePoint Workflow task list combination into one querie
i am looking to combine about 180 Sharepoint task lists for over 50 sharepoint sites and then combin them into one querir does anyone have any suggestions on how to make this easier then doing t...
- 7 years ago
i ended up going with a refrence table that pulls the source data from that a table and then a function that builds and filters the data
thank you for your help
Brendan_McLaren
7 years agoFrequent Visitor
i thought i would be able to do something like that,
the lists are identical, they are all workflow task lists with the exact same columns
do you know how i would do this?
MFelix
Super User
7 years agoHi Brendan_McLaren ,
Check the video below where you have an explanation about how to create and use a function on Query editor.
You need to make a similar process the only thing where your parameters of the function should be inserted in on the web adress of the sharepoint lists. and to use your function you should create a list of URL with all the list address.
Regards,
MFelix