User interface automation with Studio Web - Practice - RPA Challenge

This course is designed so you can also learn from your fellow learners, particularly through the forum topics.

If you need help, post a question as a reply in the Forum discussion below. To increase your chances of being helped, be as descriptive as possible. Include in your comment:

  • A description of your issue: when is it happening, what activity you have trouble with.
  • A screenshot of your error.
  • You can also attach your automation project.

If you can help a fellow learner, don’t be afraid to reply and make a suggestion. Participating in the conversation helps solidify the knowledge you’ve acquired in this course.

1 Like

Hi everyone,

If you’re encountering an issue, make sure you clearly include:

  • A detailed description: What exactly is happening? At what step or activity does the issue occur?
  • A screenshot of the error or issue you’re facing.
  • Your automation project file (if possible).

I’m also here and happy to help! Feel free to ask, and I’ll do my best to suggest solutions.

Let’s learn together!

Cheers,
Roopa Patel

@Roopa_Patel
For this exercise, keep in mind that when traversing the rows of the datatable, the name of the “Last Name” column in Excel has a trailing space. Therefore, to retrieve its value, it is necessary to include it within the name of the column itself in the CurrentRow object.

Attached is a screenshot:

2 Likes

Good catch. We can use Trim() too.

When doing the Practice RPA Challenge as part of the ‘User interface automation with Studio Web’ module I am having the following issue.

When I select the ‘Download Excel’ button it is NOT creating it as an Output of a ‘File Resource’ but simply as an ‘Output Element’.

Initially when selecting the button it told me that theree were duplicates so I added an Anchor which seemed to fix the issue as part of ‘Validation’.

Any suggestions ?

Thanks

Darren

You’re trying to capture the output of a click activity, not of wait for download.
So the output element object you receive is a reference to the button you just clicked, and has nothing to do with the function behind the button.

Hi everyone,

I’m currently working through the course exercises and noticed an important detail regarding how values are read from a DataTable inside a For Each Row in Data Table.

In the exercises, the solution reads cell values using the column name, like:

CurrentRow("Email").ToString

However, this was not very explicit during the activity, and it’s easy to assume that ItemArray(index) should be used instead. While ItemArray works, it makes the workflow harder to read and more error-prone, especially when the DataTable already contains headers.

After reviewing the example more carefully, it became clear that the intended and simpler approach is:

  • Use CurrentRow (the row variable from the loop)
  • Access the value by column name
  • Convert it to string when needed

This makes the workflow much clearer and easier to maintain, particularly for beginners.

I believe it would be helpful if the course emphasized this pattern more explicitly, especially highlighting that CurrentRow("ColumnName") should be preferred whenever the DataTable has headers, and that ItemArray is more of an exception case.

Hopefully this helps others who might be stuck on the same point.