UiPath is a strong automation instrument/program that can be used to perform and thereby facilitate the repetition of tasks, as well as, implement useful functions to the library of tasks to facilitate the performance of tasks in robotic processes automation (RPA). In this article, we are going to look at two such activities namely the Get Row Item and Hover and see how we can use them in our UiPath automation projects.

1 How to Use Get Row Item Activity in UiPath

Get Row Item is used to get the data that is in a particular row from a data table in UiPath

This activity provides you an avenue for acquiring information from DataTable and this process, in most cases, is applied in situations where you need structured data such as Excel files and databases. If you are working on customer details or sales records, this activity will make sure that you extract the right data point without any hassle.

Steps to Use Get Row Item Activity:

• Prepare Your DataTable: Make sure that the DataTable you are working on is already filled with data. It might be Excel file, a database query or any other data source.
• Drag the 'Get Row Item' Activity: In the Activities panel, look for the Get Row Item and then drag this action to the sequence of your process.
• Configure the Properties:

• DataTable: Select the correct DataTable variable that has the data.
• Row Index: Indicate a particular row number that you want to draw the data from. Remember that the row index is already zero-based (0 = first row, 1 = second row, etc.).
• Column Name/Index: You can either define the column name or the column index for retrieving the data.
• Output: Create an output variable that will contain the value retrieved from the specific row and column.

• Use the Extracted Data: The information that you have obtained can now be employed in your automation process, be it carrying out a calculation, saving it to a file, or making choices based on gathered data.

Example:

Assume that you have an Excel document with sales data and you want to extract money from the second row out of the many rows in the Money column. This is how you would set up the activity:

• DataTable: salesData

Meanwhile, extractedAmount will contain the value from the second row of the Amount column and you can use it in subsequent steps of your automation process.

2. How to Use Hover Activity in UiPath

The Hover activity in UiPath is a part of the uStudio statements that is used to make the mouse over a placeholder appear. But still it is useful in banking queues for the clients one to one branches but it is best to use it on that page where you want hover actions like tooltips to be shown when a user puts his mouse on the on the element then it should be highlighted, drop downs and menus that the user's mouse will show appear handling an item will appear display on the UI.

Steps to Use Hover Activity:

• Identify the UI Element: The Hover activity requires that you have a UI element to hover over. This could be any clickable element on a webpage, desktop application, or a virtual desktop environment.
• Drag the 'Hover' Activity: The 'Hover' activity can be found by searching for Hover in the Activities panel and dragging it into your workflow.
• Indicate the Element: Use UiPath's Indicate on Screen feature to select the UI element that you want to hover over. UiPath will automatically capture the UI element and map it to the activity.
• Configure the Properties:

• Target: The element to hover over. This will be automatically set when using the Indicate on Screen option..
• Click Before Hover (Optional): If you need to click first and then hover, you can activate this option.
• Simulate Hover (Optional): This function can be used to simulate the hover behavior, which does not require actual moving the mouse. Thus, it becomes more efficient and dependable in virtual environments.

• Use in Automation: When you hover over an element, you may wish to carry out additional operations such as pressing a button, getting text from a tooltip, or making a check of the state of the drop-down menu. The Hover activity can be used as a trigger for these actions.

Example:

Imagine you're coding a web application and you need to hover over a menu item to pop out a submenu. Besides, clicking on a submenu item may also be required after a mouse-hover action.

• Element: Use the Indicate on Screen to select the main menu item.
• Next Step: As a consequence after the hover activity, you are now able to utilize an action called Click, to select the submenu item.

This is how you can use the Hover activity to interact with dynamic elements that require mouse movement to trigger specific actions.

Conclusion

Both the Get Row Item and Hover activities are two of the best UiPath tools in terms of data extraction and UI element manipulation. Learning these activities will increase the efficiency and flexibility of your RPA processes and thus mastering these activities should be your main priority.

• Get Row Item is the go-to tool for retrieving the definite data that you need from a DataTable. It allows you to work well with record types.
• Hover automation makes it possible to perform UI actions that rely on mouse movements, for example, displaying tooltips, highlighting elements, and presenting menus.

Through the proper application of these distinct activities you can create automation workflows that are more stable and efficient. In your own projects, you can easily include them and see how they can reduce a lot of manual work in the automation process.