Skip to main content
  • EN

Hello,

is it possible to write an Excel file to a SharePoint site? I don't believe I wish to create a SharePoint list or a lookup but simply overwrite an existing file in a folder sat in SharePoint.

I can read a file from SharePoint in just fine using a Reader and just need the equivalent to 'write' I have tried the SharePointOnlineConnector but it's not outputting a file like I would expect.

Thanks.

You can upload a file using the SharePointOnlineConnector. You can choose to overwrite if the file already exists. One way to do this is:

  • Creator to initiate
  • SharePointOnlineConnector to download file.
  • FeatureReader to read downloaded file.
  • Do the modifications you want.
  • FeatureWriter to write to new file.
  • SharePointOnlineConnector to upload new file.

 

You can upload a file using the SharePointOnlineConnector. You can choose to overwrite if the file already exists. One way to do this is:

  • Creator to initiate
  • SharePointOnlineConnector to download file.
  • FeatureReader to read downloaded file.
  • Do the modifications you want.
  • FeatureWriter to write to new file.
  • SharePointOnlineConnector to upload new file.

 

Thanks @nielsgerrits​  I struggled with the output, it just seemed to count the records and not output an actual file.

imageand I have 'Upload' selected in the Action to perform.

Looks from your description you have to perform quite a few actions simply to overwrite existing file in SharePoint.

Thanks

Thanks @nielsgerrits​  I struggled with the output, it just seemed to count the records and not output an actual file.

imageand I have 'Upload' selected in the Action to perform.

Looks from your description you have to perform quite a few actions simply to overwrite existing file in SharePoint.

Thanks

The SharePointOnlineConnector can return the contents of a path (List), download a specific file or folder (Download), upload a file or folder (Upload) and delete a file or folder (Delete).

 

It should not be very hard, outputting a file using a FeatureWriter, uploading this file using the SharePointOnlineConnector. It is just an other mindset than writing directly to a file.

Thanks @nielsgerrits​  I struggled with the output, it just seemed to count the records and not output an actual file.

imageand I have 'Upload' selected in the Action to perform.

Looks from your description you have to perform quite a few actions simply to overwrite existing file in SharePoint.

Thanks

Thankyou @nielsgerrits​ Yes that seems to work perfectly :-)

imageThe file is written to SharePoint

Thanks @nielsgerrits​  I struggled with the output, it just seemed to count the records and not output an actual file.

imageand I have 'Upload' selected in the Action to perform.

Looks from your description you have to perform quite a few actions simply to overwrite existing file in SharePoint.

Thanks

:)

Reply


Community Stats

30,122
Posts
114,332
Replies
37,750
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.