I have got a SharePoint library with a lot of files, which need to migrated to another site. The library includes some additional columns for each file (e.g. customer the file is related to, technology used, language, etc.).
I have created a new library in the target site and created all the columns for the additional information (customer, technology, language, etc.). I then copied a file using:
Copy-PnPFile -SourceUrl "/Path/to/file" -TargetUrl "/New/Path/"
The file was copied fine and for some columns the information is correct. But in most columns the information is messed up or empty. For example, the technology column, which is of type "Choice", should read "PowerApps", but now reads "12;#PowerApps" and if I look into the details it just says "12". Many other columns are of type "Managed Data". After the copy all of these are empty.
Can somebody point me in the right direction, why not all of the data is displayed correctly? Do I need to change the columns data type or is something wrong with the way I transfer the files?