Hi Community, I hope you're all doing well. I am seeking guidance on how to use Alteryx SharePoint Tool to bulk upload local Excel files to SharePoint.
Specifically, I have 50 folders on my local C drive, each named with a unique four-letter combination (e.g., XXXX). Within each of these folders, there is a subfolder named "XYZ" that contains all kinds of documents. Among these documents, there are 20 Excel files named in the format XXXX-XYZ-YYYYMMDD.xlsb, where YYYYMMDD represents the file creation date.
In my SharePoint, I have the same 50 folders, each with the same corresponding subfolder named "XYZ".
My objective is to:
Identify all the "XYZ" subfolders in SharePoint and create a new subfolder named "new" within each of them.
Identify the Excel files to upload from my local C drive based on the file creation dates or the dates in the file names.
Use Alteryx to bulk upload these Excel files to their corresponding "new" subfolders in SharePoint.
My plan is to start with one "XYZ" folder, here are what I have tried:
- Use the Dictionary tool to find the corresponding "XYZ" folder on my local desktop.
- Use the Filter tool to select the Excel files for upload (all are in .xlsb format and contain multiple tabs).
- Use the SharePoint Output tool to upload the selected files to a test folder in SharePoint.
And here are problems I encountered:
- The SharePoint Output tool only supports processing files as CSV, XLSX, or YXDB, but not .xlsb.
- When running the workflow, only the record of the files gets uploaded (like the data shown below), not the actual Excel file contents.
- To upload the original Excel files, I learnt that I should use the Input Data tool to read the file contents. However, this tool can only read one tab at a time, and my files have multiple tabs. Additionally, I do not need Alteryx to read the file contents, as I just want it to help me bulk upload the original files.
I'd like to understand if my configuration is incorrect or if the Alteryx SharePoint tool cannot help me to perform this bulk upload task. Any advice or suggestions from the community would be greatly appreciated. Thank you!
