Power Platform Community Forum Thread Details

Hi all,

I am trying to click on each link in a browser table to extract data from the subsequent page. For each row, I have selected to click on the link and am met with this error when running the flow. It is saying the expected type and actual type are the same, so am unsure.

Hoping someone has an idea of what gone wrong.

Thanks for your help.

Categories:

Building flows

Hello,

Two issues that come to mind:
Firstly the selector is missing quotation marks around the CurrentItem -variable.

Change to:

Second issue is that Extract data from webpage is extracting a datatable variable. So your CurrentItem is one row of that data table. You are using that on a selecetor that is expecting a text value. So it tries to find <a> that has text which includes datatable row.

You can fix this in two ways:
1. Add Set variable to the beginning of the For each -loop that takes in the text value that you want to have in CurrentItem. Do it like so:
=ReadCell(CurrentItem,1)
In Power Fx indexing starts at 1 so that would read first columns value from the CurrentItem that is Datarow -type (contains one row from a table).

Now that should work in the CurrentItem.

Remember to add quotation marks around the CurrentItem in the Selector

Second method to fix this: Convert the ListNames -datatable into a list with Retrieve data table column into list -action. This way it will be just array of text items and you don't need to use ReadCell on it.