Preparing OneDrive
In this step we will setup an One Drive folder to run our lab.
The steps required are:
- Go to Office.com.
- Click on the 9 dots Icon on the Top Left
- Select One Drive (it can also be found under All Apps)
- Under My Files. Select New and pick the Folder option.
- Name: Excel2SAP
- Download the sample spreadsheet. This is the product list we will automatically create into SAP. Open it and change the yellow cells following the template provided:
- Category: Pick from the dropdown
- Name: *XXX-9999
- Price: 0000-9999
- The other fields are automated with formulas, so no need to change them.
- Save and upload the Excel file to the Excel2SAP folder
Now you should have it all setup to build the Power Automate flow to insert this data into SAP via ODATA and SAP Gateway. On the next section we will create a Flow to use this data.