This post is part of the SAP Build Community Challenge (April 2023)
We're mixing it up for this week’s challenge, moving to SAP Build Process Automation and automation bots – which are a bit tricky but really cool!
It feels great to set up your bot, step by step, add all the activities and commands and configurations, and then click a button to have your bot do all your work. I love watching my automation open Excel, read data, open Outlook, create and send emails, open a web app, interact with it ... and a million other tasks.
We will be using the RPA Challenge web site for the community challenge.
Essentially, you will have to do 3 things:
The trick is that the fields on the web page move each time you click Submit, so you have to know how to find the right fields on the page (hint: based on CSS class).
If you’re new to SAP Build Process Automation, you should do the following tutorials:
Together, they will give you the knowledge to do the challenge.
You must have an SAP BTP account with SAP Build Process Automation. Luckily, it is available for free on the trial version of SAP BTP, or you can use your own account with the free-tier service plan. Setup is described in the SAP Process Automation now available in your Trial Account blog post.
You will also have to install the desktop agent, which automatically installs the Chrome extension. This is described in Install SAP Intelligent RPA On-Premise Components tutorial.
Once you are set up, do the following:
Ideally, you should get a score of 100%, with a time of under 30 seconds. But even if you don't, show us what you were able to do.
It is a little challenging, especially for newbies to SAP Build Process Automation, but it is doable in a couple of hours, and worth it.
Good luck (and join this SAP Builders group! 😺
This was my first iRPA project. I went through few online videos last month and set up the environment. But could not manage any hands on. The tutorials you shared with this post have been very helpful.
The steps I followed: First built the excel upload part and tested it following the tutorial 1 you shared. Then created the web page automation set up going through the third tutorial. Initially I started with static data without any loop. Then converted it to a loop when the static part was successful for at least one set.
Challenges faced: It took me a while to understand the DOM elements and map those with variables. Your hint on the CSS helped here. Another problem I faced with mobile number. It is a numeric field in the excel. But the web page accepts string. I could not convert it to string using the toString() function in the 'edit expression' section. I changed the excel column to string and reuploaded the template. I'll explore this part further.
I totally enjoyed it. 🙂
Hi @dan_wroblewski ,
How could proceed to create the SAP BTP environment if I get a message like this:
The options selected has been "For Me (I'm developer on my own or testing SAP BTP for my company)" but I am not able to create an SAP BTP environment to test.
Is there a way to solve it and continue with this challenge?
I have done the setup using this free trial you shared and it worked. But now when helping a colleague doing the same steps, when we create the subscription it starts Processing and after some time the subscription fails. We retried several times and it keeps failing.
How can we solve this issue?
What does the error message say -- click on the red rectangle or click View Details.
Did you follow everything in this blog? https://blogs.sap.com/2022/09/09/sap-process-automation-now-available-in-your-trail-account/
Mine took 1309 millisecs, I am running it on Virtual Server Windows Hyper-V 2019
And the Automation itself
The Desktop Agent does not run on my local laptop, have raised an incident for it. Some security policies does not allow browser extension to run executables(CxChromeBroker.exe) to run.
Currently implementing few use cases in Automation for a client, this challenge was fun.
My submission for week 3.
I have created two automations: one for extracting data from Excel, and the other for posing the data to the RPA challenge site.
The difficult part for me was to capture the web page. At the beginning, web pages were not detected at all. Then thanks to the comment in the blog post, I restarted my PC and pages got detected.
Next, I proceeded with type "Recorder" in capturing the web page. However, exporting the recorded application to an automation took too long (it was not responding), so I switched to "Manual Capture" option. After all, this was the right decision because I needed to specify selectors for each element on the screen.
I liked the testing capability of applications. This helped me recognize errors at an early stage.
I've built a few automations before.
I decided to add an extra step where I capture the result message and log it before closing the web page.
One tip for the excel cloud link activity: You can set the range to only include the column letters and the last row will be detected automatically. For example, in this exercise I set my Range Definition to A:G
Kudos Sandip for the 1309ms execution!
Hi @dan_wroblewski ,
Challenge done with some issues but manageables.
I was wondering how to send an email at the end of the process. It is not as simple as UIPath (please, take it as a constructive opinion).
You can see it in this URL: https://youtu.be/_YS3XclEkfc
Thanks again and I'm looking forward to next challenge!
Hi @JJAIMES, sending an email will be similar to the steps you used to connect with excel. You can send an email with the results by following these steps:
1. Add the Outlook SDK in the Project Properties (gear icon in the top right corner)
2. Add the Open Outlook Instance, Send Email (Outlook), and Close Outlook Instance activities to the process and set the parameters for the send email activity
You can send an email using Outlook automation, as @Max_McP says above, or directly with SAP Build Process Automation, as explained in this blog: https://blogs.sap.com/2022/05/09/send-emails-from-automation-inside-sap-process-automation/
You'll have to set up a mail server, but you can use Gmail or whatever
Thanks for participating in the challenge 😺