Alteryx SharePoint Tools to Migrate SharePoint Libraries (Move Files with Metadata)

[calebhester]

Hello,

My team would like to ask if the current Alteryx SharePoint tools support outputting SharePoint metadata fields to specific files within SharePoint online libraries?

What we are ultimately attempting to do is find an automated method for migrating several of our SharePoint on-premise libraries to new SharePoint online libraries, copying over all existing files along with their historical associated metadata fields. We believe this would entail 2 core steps:

1. Physically moving the existing files - we believe that we would be able to accomplish this via linking/opening SharePoint via Windows Explorer and copying all files from the old library to the new (alternatively, depending on the size of the libraries, we could also explore if the Alteryx blob tools would be able to perform this step faster)
2. Exporting all existing SharePoint metadata fields associated with the current inventory of files, and mapping/writing that metadata to the same files within the new SharePoint library

#2 is where we wanted to focus our question above - does anyone know if the SharePoint Output tool supports writing metadata fields to existing files within SharePoint online libraries? If so, could we see a screenshot of the configuration of the SharePoint Output tool that would support outputting metadata?

Alternatively, in general, has anyone in the community used Alteryx to migrate entire SharePoint libraries (with all files/metadata being moved) using a different method than the one I described above that we may not be thinking of?

Thanks so much!!