Upload Files

Scopes

• Microsoft OneDrive & SharePoint connection - The connection for the Microsoft 365 account to use in the activity.
• File(s) - The files to upload. This field accepts IResource input. Use the See more button menu to switch the input mode to Collection Builder.
  Note: Starting with v2.0.1, the (&) and (#) characters in file names are replaced with an underscore (_). This behavior is caused by the Graph API.
• Destination folder - The destination folder for the uploaded files. The method to specify the file or folder to be retrieved: Folder picker, Enter Id, Enter Url.
  • Folder picker option - Browse the OneDrive or SharePoint folders and select the files. This field accepts IResource input. If no folder is selected, the default option is the OneDrive root folder.

  • Enter Id option:

    • File or folder Id - The ID of the file or folder. To retrieve the ID, open the file in OneDrive Web and retrieve its URL. The ID is encoded in the URL. For example: if the URL is https://yourcompany.sharepoint.com/Doc.aspx?sourcedoc=%7BA1CA7E78-BA59-4DD4-A6B9-5F5BBC37FA85%7D&file=Merge_sheets.xlsx`, the decoded file ID is A1CA7E78-BA59-4DD4-A6B9-5F5BBC37FA85. %7B and %7D are the delimiters around the file ID. This property supports String variables and string formatted values.
    • SharePoint site address - The URL of the SharePoint site that contains the file or folder. Open your SharePoint site in a browser and retrieve the URL, e.g., https://yourCompany.sharepoint.com/sites/Marketing. This property supports String variables and string formatted values.
    • SharePoint document library - The document library within the indicated SharePoint site that contains the file or folder. Open your SharePoint site in a browser, go to the Documents tab, then retrieve the URL, e.g., https://yourCompany.sharepoint.com/sites/Marketing/Shared%20Documents/Forms/AllItems.aspx. This property supports String variables and string formatted values.

  • Enter Url option:

    • File or folder Url - The URL of the file or folder. This property supports String variables and string formatted values. Retrieve the URL by opening the file in a browser.

  • Use the See more button menu to use a variable or select the Reload Folder Data option if you've modified your folders and need to retrieve the latest data.

Additional options

• If files already exist - The expected behavior when a file with the same name already exists in the destination folder. Choose one of the available options from the dropdown menu:
  • Replace - Replaces the existing item. Default option.
  • Don't replace - Fails if an existing item is found.
  • Auto rename - Auto renames the new item by appending a number.
• Metadata for the uploaded files - The metadata to associate with the uploaded files. The metadata only works for files stored in a SharePoint document library. The library should contain two columns: the display name of the field (String) and the value of the field (Object). This field supports DataTable variables.

• First file - The uploaded single file returned by the activity. Automatically generated output variable. You can use it as it is or save it with a different name. You can use this in other activities.
• File list - All uploaded files returned by the activity. Automatically generated output variable. You can use it as it is or save it with a different name. You can use this in other activities.

See also:

• Files activities

• For Each File/Folder
• Get File List
• Share File/Folder