cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Manc_Gurl
Level: Powered On

Document Set Flow

I have a library that contains document sets, there are over 40K items in this library.  The site owner has asked if we can copy out documents of a certain content type "Design Document" with a certain purpose which is a choice field, to another library.  I've created an excel spreadsheet which is querying the library and filtering out the particular files that I want to copy.  For some reason in my excel query I can only see a link to the document set where the file resides, I can't seem to get a direct path to the file.  Is there any way I can create a flow, that gets these files that are listed in my query and copies them to another library?  Doing this manually would take ages.  I'm quite new to flow but I've managed to do flows that change permissions etc via HTTP calls.  Any ideas welcome as I need to get this done by the middle of next week.  TIA

3 REPLIES 3
Super User
Super User

Re: Document Set Flow

Use the action Get Items use a Odata Query in the advanced settings something like ContentType eq 'Design Document" may work.

 

Once you have this action returning the correct items (i dont know if your going to hit flow limits with 40k items you may be better with a migration tool like ShareGate...).

 

Then use Copy File flow action - you can pass the identifier returned from Get Items.

 

Manc_Gurl
Level: Powered On

Re: Document Set Flow

It looks like this won't work because of the list view threshold. I've inherited this list from another SP Admin and unfortunately they've tried to index content type colums which isn't supported so all the list views are broken.  I was trying to help somebody out without having to spend the weekend fixing the list 😞

Highlighted
Super User
Super User

Re: Document Set Flow

You might be able to get a trial of Veeam backup for Office 365 - that might be able to backup the site and then you might be able to pull the files out and restore to a new list that way. I think its full featuured in trial mode

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,287)