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.
@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.
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.
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.