Forum Discussion
Automation for downloading an Excel file from SharePoint using the Microsoft 365 Cloud SDK
Hello, I’m working on an automation in SAP Build Process Automation using the Microsoft 365 Cloud SDK. The automation is designed to automatically download an Excel file uploaded to SharePoint and send it by email to a list of recipients every day. I am using to this the following tutorial: https://developers.sap.com/tutorials/spa-office-integration-agent..html
The automation from the tutorial works, but I’d like to customize it a bit - for example, to make sure it always downloads the most recent Excel file if there are multiple files on the SharePoint site. However, I’m not sure how to adjust some of the parameters. I haven't found any other tutorials for that.
I haven’t been able to find any other tutorials covering this scenario. I started with the activity Get Remote File Information, but I am not sure if it is a right direction. I don't know also how I should fill the field Output Paramters, if the activity is correct.
Could anyone please help or point me in the right direction?