Click / Select the right SAP datatable row based on Excel data

Help Studio
, , , ,
1

Hello dear community,
I am an absolute beginner when it comes to UiPath and SAP Automation.

I am facing the following obstacle: I want the robot to select the correct row in my SAP datatable based on the position number AU_POSNR specified in Excel (marked yellow in the example).

Post
Post504×507 46.1 KB

As I am a beginner, can you please help me with as much detail as possible (activities, selectors, variables)? Screenshots are also welcome.

Many thanks in advance!

2

Hi!

Maybe this article will help

4

Hi,

I assigned the position number from the excel sheet to variable “text” (works).

I use an Exist Activity element coupled with an If loop. Unfortunately I am not able to add the variable text to the selector of the Element Exists activity so that it works. It always shows me that the variable is not defined in the current scope (see screenshot).

Post2
Post22227×852 147 KB

Have I set it incorrectly?

5

@B_Sebastian

Generally it shows like that…the value is populated only during runtime

please run and check

Also you can consider using sap activities

cheers

6

Hi,

it´s still not working.

Post 3
Post 32248×921 148 KB

Could you please help, it´s a very important project!

Thank you!

7

Variable is not defined in the current scope.

8

@B_Sebastian

In tuntime are you getting an error?

If yes what is it?

Also check if the cell changes the id might change…check the static prts of id by indicating 2 or 3 cells and see which is common and replce non common parts with *

Cheers

9

Thanks for the help!

I’ve made some progress, the only problem now is that when I insert the variable for the number in the selector and click on the Exceed field, this number is transferred to the value of my variable.

Post4
Post41757×1134 148 KB

In the click field the overwrite works and the field already works.

Any tips?

Thank you very much!

10

If I omit the “overwrite with variable”, it shows me the original error again that my scope is not defined.

11

@B_Sebastian

Overwrite will original or that showing of variable is not is scope is not an issue at all…as they work only during runtime

Can you please tell what is the current issue you are facing…other than the no issue of habing over ride or having variable not in scope…as they are not errors at all

The whole point of using variable is to send the variable value to selector

cheers

12

Element exist is not working, because of validate error.

Post
Post2254×965 171 KB

Thank you.

13

@B_Sebastian

If you validate it will not get validated…you need to run and see in runtime if it is working and right values are being passed

Cheers