SAP Build Challenge – Week 3 – Automation Bots

[dan_wroblewski]

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.

Background

We will be using the RPA Challenge web site for the community challenge.

Essentially, you will have to do 3 things:

• Automatically retrieve data from an Excel.
• Add an "application" for the RPA Challenge web page – meaning, get your bot to recognize the web page and all its user interface elements.  
• Automatically enter data and click the submit button 10 times, once for each row of data.

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:

• Build Your First Automation Using Excel SDK of SAP Build Process Automation, which will show you how to get data from an Excel (<30 minutes).
• Capture Orders Management Web Application, which shows you how to set up the web page as an "application" and define its screen elements (<30 minutes)
• Build an Automation for Orders Management, which shows you how to Define Screen Activities for an "application", so you can enter data in input fields and click buttons (~30 minutes).

Together, they will give you the knowledge to do the challenge.

Setup

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.

Challenge

Once you are set up, do the following:

1. Download the Excel from the RPA Challenge page.
   • You could add this task to the automation but you do not have to.              
2. In SAP Build Process Automation, do the following:
   1. Create a new automation.
   2. Read the data from the Excel.
   3. Click the Start button.
   4. Enter each row of data into the web page into the right fields, and click the Submit button. This must be done 10 times – once for each row. Remember, the locations of the fields change so you must identify the field correctly and enter the correct data into the correct field.
3. Run the automation (you can run it from test mode; you do not have to deploy it).
4. When complete, upload an image of the completed challenge that shows the system tray with the time, like this: 
   
   • Also, upload your complete automation definition,something like this (without blurring): 

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! 😺

[cwitschel]

Hi Dan,

This weeks challenge was really cool!

It took me all week until finally yesterday getting the booster installed in our global account. That was the main challenge to be honest. Here are my results:

looking at the score the others have, I think I need a new laptop 😄

Cheers Christian

[dan_wroblewski]

Thanks for keeping at it and participating 😺

[Pamela]

Hello Dan,

Here is my output:

And my automation design, with three parts (Main automation, Read data from Excel, Execute in RPA Challenge):

thanks,

Pamela

[dan_wroblewski]

Nice use of sub-automations 😺Can you explain the use of the condition and Application Exists, what was the condition, and under what conditions would you close the application.

[Pamela]

For the application exists, I immediately checked whether the captured application was open to see if the application existed. Like following snapshot: 

The outcome of step 2 was used as a condition, and if it is true, the automato will execute the command "Close Application".

I think it will guarantee that every time we execute the automation, a new web page rather than a manipulated page will be opened. Because I occasionally manually test a web page and forget to close it, the automation result will be affected.

[vinay050]

Hi @dan_wroblewski ,

Enjoyed building this automation . Please find below test results

Regards

Vinay

[dan_wroblewski]

Nice work!!

[smarches]

Hey guys, I've been trying to work with RPA but I'm still facing some difficulties.

I tried using the company's RPA, but had to configure it manually. Here's what I did:

And manually: 

I also tried using the free account, but it didn't work out for me.

I know I should keep trying, but I gave up this Saturday.

Although RPA is really interesting news about the SAP Build Process Automation, it's not easy to install and configure, especially with the Browser Plugin + Desktop plugin and different authorizations if you have an IAS.

I'll try again some other time.

[Ranjith_Kumar]

i think you missed to add required roles for sap build process automation in your role collection try to add the roles and check it again

[dan_wroblewski]

Could use the free trial here: https://account.hanatrial.ondemand.com/trial/#/home/trial

And have you followed the tutorials listed above, especially this one: https://developers.sap.com/tutorials/spa-create-excel-automation.html

[rohit_kadam]

Hi @dan_wroblewski 

I have completed the challenge in 1618 milliseconds. It was easy challenge 😄

[dan_wroblewski]

We wanted to get every involved, and make it fun and not too hard ... glad you completed it 😺

[Ranjith_Kumar]

my Automation flow

it took for me 2666 milliseconds

looking forward for the next challenge

[ManojSutar]

Hi Dan,

Here is my Output

[rajkumar]

Main Automation which reads excel and loops throw row items:

Sub-automation which fills the form and submits:

The final results:

[govardhansahil]

Hi @dan_wroblewski 

Thank you for the challenge, it was interesting.

Automation Flow:

It took me 6404 milliseconds.

[dan_wroblewski]

Great job 😺 glad you joined!

[evra83]

Hi Dan,

Thanks for this challenge.. 

[dan_wroblewski]

Nice work! Do you use process automation for your work?

[WannL_Tan]

Great challenge!

[dan_wroblewski]

Great job! I see you used Get UsedRange Row activity -- what was that for?

Also, it seems it took a little extra time to complete ... I wonder why

[HelenaFortun]

Hello Dan,

it was great fun! Beside the learning I experimented quite much and learned a lot...

Thanks for that!!

Helena

[dan_wroblewski]

Thanks for the comments ... I like how you divided up the automation into parts ... and how you automated the screenshot (!!) 😺

[AchimBolte]

Hello Dan,

for a newbie to SAP Build Process Automation it was challenging and I spent a couple of hours especially for declaring the screen elements of the RPA Web Page application. Finally all impediments could be managed.

Thanks for this challenge.

[Chetan_Jadhav]

Hi @dan_wroblewski
Completed the Third Challenge.
It was Amazing.
Completed the Third Challenge.

[PrashantJayaram]

Hi Daniel,

Please see below:

These challenges are really educating me, so thanks!  They're quite a lot of fun too.

Regards,

Prashant Jayaraman

[rsraj]

Hi Dan,

Here's my week 3 submission. It's interesting and bit challenging, however it's cool to see the automation.

Thank you very much!

[guilhermeoliv]

Hi Dan,

It was a very nice experience, thank you!

Regards,

Guilherme

[guilhermeoliv]

The first screenshot didn´t have the time, sorry 😅

[dan_wroblewski]

Glad you liked it

[Akash-B-R]

Hey Dan,

My submission for Week 3 Challenge.

I changed my screen orientation to take this one ;). 

Cheers,

Akash.

[dan_wroblewski]

Yes, a vertical screen can be really helpful 😺Thanks for participating

[AnaBraga]

Hi Dan,

It was my first build process automation experience but I really liked it.

I had an issue with the variable type (initially they had the type "any" and I had to change to "string" type).

Another issue I had was with the navigator field on the step 4 of the process automation (see secreenshots). The field was with a different browser other than the one I was using and the application wasn't working because of that.

Thank you

[dan_wroblewski]

Yes, you have to be careful of the browser -- I generally always use Chrome, but in any event there is a setting for indicating the browser type. As for variable, there was something tricky in that the phone number was a number (in the Excel) but was needed as a string to put in the field so you needed to convert it.  Glad you kept at it.

[PranayaBhanja]

Hi Dan!!

Thanks for the challenge..

Here is the screenshots.

AutomationResult

[dan_wroblewski]

Nice work ... and quite FAST!!!

[VinayKumawat]

It is my first time working with  SAP Build Process Automation and automation bots.

Quite interesting start with this challenge, seems my system is slow because of several browser tabs 😅

 and here are steps:

 Thanks,

Vinay

[KarthickD]

Hi Dan,
At last...here is mine.

Well it was interesting though!!

[dan_wroblewski]

Glad you kept at it 😺

[TimothySanty]

Hi Dan,

I've done the set-up and role assignment on the BTP Trial account but when I launch the application I get this error message:

😞