Forum Discussion
Helper IVDuplicate files in Sharepoint
Most Valuable ProfessionalYes, you would need to use the "invoke a custom function" feature, which essentially lets you run a query using all the rows in another query (where your other query gets all sites). I have a tutorial here on how to get all sites here, you could adapt this to run your query on that.
Helper IVhi thank you for the video it is really good video, but it seems like this is more on statistics for a site. What I need is for the statistics in document library to find a duplicate files. Is it possible to achieve this using this method?
I would like to achive something like this (See screenshot below) but for all document library in our tenant.
- christinepayton
No, so what I was getting at with linking the video is that in the video, it does a query to get all sites and then invokes a function on that list of sites. So what you would do is combine the technique from your original video and adjust it to run the same query in a function over the list of sites in the second video. I don't know of a source that has both techniques combined in one tutorial - you have to take bits and pieces and mush them together. 🙂