SAP Build Process Automation reading Excel data from Sharepoint using Microsoft 365 Cloud SDK

[ola_an_c]

I am building an automation in SAP Build Process Automation that should automatically read data from an Excel file stored in SharePoint. I used this tutorial: https://developers.sap.com/tutorials/spa-office-integration-agent..html

Previously, I used the “Get Remote File Information” activity, where I could directly provide the file URL to specify the exact Excel file in SharePoint.

Now, I want to modify my process so that it automatically retrieves the most recently added Excel file from the same SharePoint location (instead of using a fixed link), so I tried to replace “Get Remote File Information” with “Get Recent Files”.

However, the “Get Recent Files” activity does not have a field for entering a SharePoint URL or folder path, so I am not sure how to define the correct source location from which the automation should fetch the file. I also don't know how to adjust properly the new parameters, didn't see any tutorials on the Internet regarding this..