Skip to main content
Question

Sharepoint Online Connector : Create subfolders

  • April 27, 2025
  • 1 reply
  • 14 views

jomaura
Observer
Forum|alt.badge.img

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!

1 reply

evieatsafe
Safer
  • Safer
  • 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:

  1. Have the folder structure already created before upload (like you suggested)
  2. 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. 


Reply


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