Share
Report
68Because Microsoft have been switching some features in Classic SharePoint off, I want to migrate some large document libraries from Classic to new Modern sites. I would have thought this might be a fairly straightforward process ... and yes, I understand that the source library's Created Date/By and Modified Date/By values won't be ported across, but we can live with that.
From - /sites/eo-wordings-libray/WordingsLibrary(Archive)
To - /sites/eo-wordings-library/WordingsLibrary(Archive)
[Note the subtle change in site name from the original, which was spelt incorrectly, and not by me!]
So, despite finding other more complex methods via Google, the simplest one has proved the most effective, though not completely effective. This is what I've got:
There's a filter on the Get Items function which limits the run to five items from one View of the library. This is to keep the run short for testing purposes.
The destination library is a clone of the source library (created by basing the new library in Modern on the old library in Classic). There are 56 columns in each library, excluding the mandatory Modified and Created columns.
There are three Lookup columns in each Library - Class (32 rows in Lookup list), LOB (126 rows in LookupList) and PublicationBrokers (17 rows in Lookup List).
When I run the Flow, the documents (PDFs and Word) are copied to the destination Library, along with almost all the metadata - except for the value for Class. I do not know why this is.
It can't be a limit on the number of items in the Lookup column, because LOB has more items, and those values copy across just fine.
The three Lookup columns are formatted identically, each looking up their values from the three separate Lookup Lists.
I tried adding an Update file properties function, and setting the value for Class Id (it didn't offer a field for Class value) to Class Id from Get Items but that didn't work. The value for Class still didn't transfer across.
But I did notice one curious thing. While digging around in the Run history, I had a look at what the Update file properties function was doing and noticed this:
The Class column output has no line for Value (though the ID number is correct), yet the LOB column output does.
I also wondered if there was some way of using the Send an HTTP request to SharePoint function as some postings in forums had referred to it as a possible solution.
I gave it a try but that didn't work either - though it's perfectly possible I made some dumb mistake in the syntax:
[Note the subtle change in site name from the original, which was spelt incorrectly, and not by me!]
So, despite finding other more complex methods via Google, the simplest one has proved the most effective, though not completely effective. This is what I've got:
There's a filter on the Get Items function which limits the run to five items from one View of the library. This is to keep the run short for testing purposes.
The destination library is a clone of the source library (created by basing the new library in Modern on the old library in Classic). There are 56 columns in each library, excluding the mandatory Modified and Created columns.
There are three Lookup columns in each Library - Class (32 rows in Lookup list), LOB (126 rows in LookupList) and PublicationBrokers (17 rows in Lookup List).
When I run the Flow, the documents (PDFs and Word) are copied to the destination Library, along with almost all the metadata - except for the value for Class. I do not know why this is.
It can't be a limit on the number of items in the Lookup column, because LOB has more items, and those values copy across just fine.
The three Lookup columns are formatted identically, each looking up their values from the three separate Lookup Lists.
I tried adding an Update file properties function, and setting the value for Class Id (it didn't offer a field for Class value) to Class Id from Get Items but that didn't work. The value for Class still didn't transfer across.
But I did notice one curious thing. While digging around in the Run history, I had a look at what the Update file properties function was doing and noticed this:
The Class column output has no line for Value (though the ID number is correct), yet the LOB column output does.
I also wondered if there was some way of using the Send an HTTP request to SharePoint function as some postings in forums had referred to it as a possible solution.
I gave it a try but that didn't work either - though it's perfectly possible I made some dumb mistake in the syntax:
Sadly none of this has worked. The Class column in the destination library stubbornly refuses to update, and now I'm at a loss.
Updating the values manually for Class post-migration is out of the question as there are over 6000 documents in this one library and four other libraries totalling about the same number of documents between them - so I wouldn't relish adding Class values to 12,000 documents one at a time.
Updating the values manually for Class post-migration is out of the question as there are over 6000 documents in this one library and four other libraries totalling about the same number of documents between them - so I wouldn't relish adding Class values to 12,000 documents one at a time.
It's hard to believe there isn't some way of fixing this, I'm probably overlooking something really simple ... any help anyone here can give would be gratefully received.
I've tried to include all the useful information I can, but if additional info is needed, post a comment and I'll respond as fast as I can.
Alan McK
https://thesharepointhive.blogspot.com/
Categories:
All responses (
Answers (
