I want to retrieve values in Excel, store them in a variable, and execute

[pop]

I am conducting learning based on the content from the Academy.

On the site below, I want to obtain movie titles from Excel, search for them, click on the titles, and display the movie ratings in a message box. After finishing, I want to get the next movie title from Excel and search again. Once all is executed, I would like to write the start time, end time, and success or failure into Excel.
IMDb: Ratings, Reviews, and Where to Watch the Best Movies & TV Shows

I can get to the point of obtaining the titles and searching, but I am having trouble clicking on the titles; it stops working. I am storing the titles in a variable.

If you need any other information, please let me know. I would appreciate your help. Thank you very much.

[Yoichi]

Hello

@pop

I can retrieve the title and proceed to the search, but I’m having trouble clicking the title; it stops. I’m storing the title in a variable.

If there is an error, please share the error details.

[pop]

Hello

Thank you.

The details of the error are as follows:

I am trying to get the title from Excel, but I am getting stuck during the search process.

[Yoichi]

First, to isolate the cause, let’s set the selector using a fixed string without using a variable to check if it works.
If it doesn’t work, check the status in the selector editor, and if it shows an error, re-specify it using the “Repair” function to see how the selector changes.

[pop]

With a fixed name, the validation in UI Explorer was successful.

The first title worked fine, but it got stuck again at the second title.

[Yoichi]

This error may occur when you have multiple windows or tabs open, leading you to look at a different tab or window than expected, resulting in no results. Are you in such a situation?

[pop]

It’s difficult to prove in a chat, but I do not have multiple windows or tabs open.
It’s not different from what I expect.

I am using Edge.

[Yoichi]

What are the settings for the following items in the project configuration?
If there is a discrepancy in the selector, having this as True would help in diagnosing the error, so if it is False, please set it to True and share the error details upon re-execution.

[pop]

I apologize.
It was set to True.

[Yoichi]

Does the following selector mismatch information not appear?

Also, from the image you uploaded above, I see that there are double quotes included in the string, which I believe could be a factor in the mismatch during the selector matching. It might be better to remove them from the original data.

[pop]

The content you sent was not displayed here.

I removed the double quotes, but it remained the same.

[Yoichi]

I think the location of the error has changed from before, but is the previous error location now okay?

For now, I created a simple sample in my local environment, and there doesn’t seem to be any particular issues.

Sample20260716-1.zip (752.6 KB)

[pop]

The stopped point is the same, so I don’t think the error has been resolved, but the error message has changed. Thank you for the sample. I’ll take a look.

[Yoichi]

@pop

The stopped locations are the same.

I think the first image is where it is stopping due to the click activity.

As for the recent image, could it be stopping while retrieving the rating?

[pop]

It’s stopped on the same screen after searching.

There are other things I want to do, but this is my xaml. I’ve removed it because the folder path was my personal path.

20260716_Study.zip (5.1 MB)

[Yoichi]

I prepared an appropriate xlsx file in my environment and ran it without any errors.

As an immediate observation, the version of the UiAutomation.Activities package is outdated, so I suggest trying a newer version, such as 24.10.x. This might resolve any errors related to selectors. By the way, what version of Studio are you using?

[pop]

Here it is

[pop]

I was able to search for and open the three titles by incorporating the steps I obtained from Excel into the sample you provided. Thank you very much.
I will add a bit more to what I want to achieve and verify it.

Recording start time, end time, and success/failure.

I am still in the conceptual stage, but when an error occurs, I want to capture the error details and document them in Excel.