Build Your Automation Using Microsoft 365 Cloud SDK of SAP Build Process Automation

Once you have successfully configured the Azure Application as mentioned in Pre-requisites, you are now ready to create an external authentication in SAP Build Process Automation Tenant.

1. Log in to SAP Build Process Automation Tenant.

2. Navigate to Control Tower > External Authentication.

   

3. On the External Authentication page, click Create New Authentication.

   

4. On the Create Authentication popup window, select Microsoft 365.

5. Enter a name in the Name field such as Office 365.

6. Optional: Enter a short description in the Description field.

7. Enter the Client ID received at step Configure Azure Application > Find Relevant IDs that Define the Application > Application (client) ID.

8. Enter the Client Secret received at step Configure Azure Application > Create a Client Credential.

9. Enter the Tenant ID received at step Configure Azure Application > Find Relevant IDs that Define the Application > Application (tenant) ID.

10. Select the desired scope in the Scope field.

11. Choose Create.

    

Once the external authentication is created, you can see it on Agent 3.

1. Open the Desktop Agent. Once you are connected to the tenant, choose Settings > External Authentication.

   

   The agent receives and shows a list of registration items defined in SAP Build Process Automation External Authentication settings.

2. Select Office 365 Authentication.

   

3. Enter the email address of the identity in the Email field to authenticate the identity.

   The authentication of the activities is done with that identity.

4. Choose save.

   

   Each registration item can be registered or unregistered given a user email address.

5. Select Register button.

   

6. In the newly opened window, consent for agent to use your ID with the activities.

7. The confirmation of registration will appear.

   

1. Go the SAP Build lobby. Choose Create button.

   

2. Select Build an Automated Process.

   

3. Choose Task Automation.

   

4. Provide a Name for the project such as Microsoft 365 and choose Create.

   

5. Choose Create > Automation.

   

6. Select the agent version that is registered on your system.

   

7. Provide a name for the automation such as Automation send email, and choose Create.

   

You will be navigated to the automation editor where you can build your automation. In order to use Microsoft 365 activities, you need to add the Microsoft 365 Cloud SDK to your project.

1. Choose Settings.

   

2. In the Project Properties window, select Dependencies > Add dependency > Add a Business Process project dependency.

   

3. Under Add Dependency search for Microsoft 365 Cloud SDK and Add it.

   

4. Close the window.

1. Under Automation Details panel, under Tools, look for Select 365online Authentication activity.

2. Drag and drop the activity into the workflow below Start.

   

3. Under Automation Details panel, under Tools, look for Get Remote File Information activity. Drag and drop the activity into the workflow.

   Get Remote File Information activity gets information about a remote file using its source URL.

   It will generate a log message within the tester and the trace file.

   

4. Select the Get Remote File Information activity. In Input Parameters, under sourceURL, you need to copy and paste the URL provided by Microsoft to open the file. You will retrieve the file URL in the step below.

   CAUTION: It is not the downloaded URL.

5. To retrieve the needed URL, please follow these steps:

   • Go to your One Drive.
   • Choose My Files.
   • Find the Orders excel file that you downloaded and saved in your One Drive as mentioned in the pre-requisites, and check it.
   • Choose Copy link.

   What’s going on?: This is the URL you will copy and paste under sourceURL input parameter.

   

6. Now that you have copied the URL, you may paste it under sourceURL input parameter.

   

7. Under Automation Details panel, under Tools, look for Log Message activity. Add it to the workflow under Get Remote File Information.

8. Select the Log Message activity. In the Input Parameters, under message choose fileInformation.

   

9. Save the automation. Test the automation.

   

10. Once the Test is done, go to Info in the Test Console where you will find the driveId and fileId values.

> The `driveId` is the ID of the remote SharePoint Drive where the file is located and the `fileId` is the ID of the workbook.

![Office](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-office-integration-agent/024.png)

An input or output parameter is a variable that is passed, received, or sent from one automation, SDK activity or control to another. This variable allows you to manipulate data that you can use in your workflow. Input or output parameters have a name (optionally a description) and data that complies to a type.

For the purpose of this tutorial, you will create an input parameter for the path to the excel file which will be downloaded locally in your system.

1. In your automation, on the right-hand side panel, go the Input/Output section and click Add new input parameter.

   

2. Perform the following:

   • Enter a name: path
   • Enter a description: Path to the excel file
   • Select String as type

3. Choose Save.

   

1. Under Automation Details panel, under Tools, look for Open Workbook activity. Drag & drop it into the workflow.

   This activity opens Excel Workbook.

   

2. Select the Open Workbook activity.

3. Under Input Parameters, for driveId, perform the following steps:

   • Open the expression editor
   • Select Variables
   • Select the variable fileInformation from Step 2 and choose driveId
   • Choose Save Expression

   

4. In the same way, for pathOrFileId, perform the following steps:

   • Open the expression editor
   • Select Variables
   • Select the variable fileInformation from Step 2 and choose fileIdId
   • Choose Save Expression

   

5. Under Automation Details panel, under Tools, look for Get Values activity. Drag & drop it into the workflow.

   This activity retrieves the values, formulas or numberFormats from the current worksheet.

   

6. Select the Get Values activity. Under Input Parameters for:

   • range Definition, enter: A1:F11 and select the expression in quotes.

   What’s going on?: The range definition of the excel file has values up to this range therefore you need to specify those values.

   

   • format choose: objectsHeadersOnFirstRow.

   This corresponds to the format of the result that will appear in the Test Console.

   

7. Under Automation Details panel, under Tools, look for For Each control. Drag & drop it into the workflow.

   

8. Select the For Each control. Under Parameters in Set looping list, choose result.

   

9. Under Automation Details panel, under Tools, look for Log Message activity. Drag & drop it into the workflow inside the For Each loop.

   

10. Select the Log Message activity. Under Input Parameters in message choose currentMember.

    

11. Under Automation Details panel, under Tools, look for Download File activity. Drag & drop it into the workflow outside the For Each loop.

    

12. Select the Download File activity.

13. Under Input Parameters, for driveId, perform the following steps:

    • Open the expression editor
    • Select Variables
    • Select the variable fileInformation from Step 2 and choose driveId
    • Choose Save Expression

    

14. In the same way, for pathOrFileId, perform the following steps:

    • Open the expression editor
    • Select Variables
    • Select the variable fileInformation from Step 2 and choose fileIdId
    • Choose Save Expression

    

15. For localFilePath: select parameter path.

    localFilePath corresponds to the path to the file which will store the data on your machine.

    

16. Under Automation Details panel, under Tools, look for Send E-mail activity under Outlook Online. Drag & drop it into the workflow just below Download File activity.

    This activity will send an email using Outlook Online.

    

17. Select the Send E-mail activity. In Input Parameters under mailDescription choose Create Custom Data.

    

18. Customize the Email:

    • Under subject enter: Your list of orders and select expression in quotes.
    • Under body enter: Hello, Your list of orders is ready for you. and select expression in quotes.
    • Under toRecipients, select + and add your email address. Select the expression in quotes.

    

    • Under attachments, select + next to Description of a mail.attachments
    • Under attachments, select Create Custom Data to add the name and path parameter:
      • In the name field, enter ListOfOrders.xlsx and select the expression in quotes.
      • In the path field, select parameter path.

    path corresponds to the path of the file which will be added to the email message.

    

19. Under Automation Details panel, under Tools, look for Remove File/Folder activity. Drag & drop it into the workflow.

    

20. Select the Remove File/Folder activity.

21. Under Input Parameters, for path, select the parameter path.

    path is the path of the file that will be removed once email is sent.

22. Save your work.

    

1. Once the automation is saved and ready you can test it. Choose Test button.

   

   You will be prompted to enter the value of Input parameters.

2. For path: enter the path to the excel file. Your path would be like C:\temp\ListOfOrders.xlsx

   The file will be saved with the name ListOfOrders in the above-mentioned folder and would be deleted after the mail is received.

3. Choose Test.

   

   The BOT opens the Orders excel file in your share point, reads the value from the excel, downloads the file to you system and sends an email with ListOfOrders excel file as an attachment via Outlook Online.

   

4. Check your Outlook Inbox to see the email that was send with the attachment.

   

This sample project can be downloaded from the SAP Build Store.

To retrieve this sample, please follow these steps:

1. From the SAP Build Lobby, navigate to Store.

2. Search for the sample project: Automate Microsoft Office 365 applications.

3. Choose Create from Template to retrieve the sample and save it as a new project in your lobby.

   

4. Choose Create.

   

   Your project gets created in editable version. You may release and deploy it and run the project.

5. Navigate back to the lobby by clicking on the SAP logo.

   

   You can see your project is available in the lobby.