Before we had the SharePoint Connector set up in Alteryx Designer, we relied on OneDrive syncing to process files stored on SharePoint sites. However, this approach wasn’t very stable. Even when workflows ran without errors, output files often failed to sync back to SharePoint if the OneDrive sign-in dropped unexpectedly. Also, sharing workflows with others also introduced challenges. We had to ensure everyone had the same sync setup and folder paths. Since synced file paths include individual usernames, we needed to make that part dynamic—adding more complexity to the setup.
Now that we’re using the SharePoint Connector, it seems to handle reading and writing files reliably. We’d like to fully leverage it, but we’re wondering:
Is it possible to copy or move files within a SharePoint location using the SharePoint Connector?
Previously, we used the File Copy-Move tool, which required both source and destination file paths. But with SharePoint, we don’t always have a valid file path in the traditional sense.
Has anyone found an alternative method to perform copy/move operations when working with the SharePoint Connector?
Not sure if SharePoint Connector can achieve your requirements, but you can create a regular task in SharePoint to move or copy your data if it's just for archival purposes. If this helps, feel free to like the comment