I am encountering difficulties when using the SharePointOnlineConnector transformer.The flow is as follows: I have an Excel file listing a series of files to download from the BOX service. If the file is not yet downloaded locally, I download it to G:\workspace\tmp. I then modify the relative path by removing the filename: Example:/xxx/xxx/xxx.zip becomes /xxx/xxx I upload the locally downloaded file to the target SharePoint site, using the modified path as the destination. I successfully managed to upload around 700 files out of 3600 because facertains numbers of folders already exist into the sharpeoint site.However, I am now consistently getting errors such as:UPLOAD_ERROR Could not find the folder.It seems that I might need to create the subfolders first.What would be the best way to proceed from now?Thank you in advance for your help!

Hi @jomauragreat question! I would have to test this to confirm, but I believe we can only “create” folders when the Data Source > Upload = Folder. If the Data Source > Upload = File it will expect the folder path to already exist. There should be two workarounds to this:Have the folder structure already created before upload (like you suggested)if you know beforehand which folders do not exist you could:Create your folder structure from the BoxConnectorTest for this condition (with/without existing folders)Send to two different SharePointOnlineConnectorSet this new SharePointOnlineConnector to Upload > Folder (with the new folder structure)I’m not sure what you have set in the BoxConnector, if you are downloading to an attribute then this second workaround would probably be a lot to set up. Let me know if this works for you or if it sparks any ideas.

Question

Sharepoint Online Connector : Create subfolders

25 days ago
April 27, 2025
1 reply
20 views

jomaura
Participant

I am encountering difficulties when using the SharePointOnlineConnector transformer.

The flow is as follows:

I have an Excel file listing a series of files to download from the BOX service.
If the file is not yet downloaded locally, I download it to G:\workspace\tmp.
I then modify the relative path by removing the filename: Example:
/xxx/xxx/xxx.zip
becomes /xxx/xxx
I upload the locally downloaded file to the target SharePoint site, using the modified path as the destination.

I successfully managed to upload around 700 files out of 3600 because facertains numbers of folders already exist into the sharpeoint site.However, I am now consistently getting errors such as:
UPLOAD_ERROR Could not find the folder.

It seems that I might need to create the subfolders first.
What would be the best way to proceed from now?

Thank you in advance for your help!

evieatsafe
Safer
273 replies
23 days ago
April 29, 2025

Hi @jomaura great question! I would have to test this to confirm, but I believe we can only “create” folders when the Data Source > Upload = Folder. If the Data Source > Upload = File it will expect the folder path to already exist. There should be two workarounds to this:

Have the folder structure already created before upload (like you suggested)
if you know beforehand which folders do not exist you could:
1. Create your folder structure from the BoxConnector
2. Test for this condition (with/without existing folders)
3. Send to two different SharePointOnlineConnector
4. Set this new SharePointOnlineConnector to Upload > Folder (with the new folder structure)

I’m not sure what you have set in the BoxConnector, if you are downloading to an attribute then this second workaround would probably be a lot to set up. Let me know if this works for you or if it sparks any ideas.

Happy to help - Evie

Reply

Rich Text Editor, editor1

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

Cookie settings

We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.

Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos + marketing

Sharepoint Online Connector : Create subfolders