Upload a file to a Sharepoint List

[ssripat3]

Hello community,

I am currently working on a workflow that would take an XML and generate a CSV file. After generating that file, I would like to upload it to a column/field called "Attachment" in Sharepoint list. 

Sharepoint List

ID	Name	Attachment
123	ABC	ABC123.csv
456	DEF	456DEF.csv

Can you please let me know if this is possible using the Sharepoint tools in Alteryx or if there is any other way of achieving this.

Thank you

[Luke_C · Accepted solution]

Hi @ssripat3 

I'm not certain the sharepoint tools support this, I could be wrong though. One alternative may be to output the CSVs to a folder location monitored by Power Automate and use Power Automate to attach:

https://manueltgomes.com/microsoft/sharepoint-add-attachment-action/

[ssripat3]

@Luke_C Thank you for the suggestion and the link. I will try creating a flow with Power Automate and test it.

[ssripat3]

Hi @Luke_C 

I was successfully able to upload the files I generated from Alteryx into a Sharepoint Library folder using a Sharepoint API and then using a Power Automate flow, I was able to upload the attachment files to the specific items in the List based on the filename.

I have encountered another API which can be used to post a new/overwrite an existing item to the list in Sharepoint, but I am not sure if we have such an API just for attachment files. (I am just putting this question out there, just to see if anyone already encountered this)

[Gauravbansal]

HI, 

Would appreciate if you could share a sample workflow as I am struggling to upload the file onto a share point.

Thanks & Regards,

Gaurav