Answered

Searching through datatable to find value and then provide row number

(0) Share

Report

Posted on by JezAuditore

Hi all,

I have a datatable scraping from the web. The values change position depending on previous steps that are working fine. What I am looking to do is scrape the datatable to find "X" value and then send me back the row number. This is so I can then use that row number as a variable later in the flow. Please let me know if this is possible!

Thanks 🙂

Categories:

Power Automate Desktop

All responses (7)

Answers (2)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You could turn the proper column into a list, and then use a loop to search on the list to report back the right row number, but this could take a while if you have a lot of rows.
Verified answer

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JezAuditore

Use the Find action of the datatable

If you do not see this action in your list then you do not have the updated version of PAD.
JezAuditore 44 on at

Like
a
(1)

Report
Copy link

Link copied!

I'll update thank you
JezAuditore 44 on at

Like
a
(0)

Report
Copy link

Link copied!

@VJR , This has worked but it gives a row and a column saved in a variable, is there an easy way to extract just the row?
Verified answer

VJR 7,635 on at

Like
a
(5)

Report
Copy link

Link copied!

Yes, there is..

If this is your DataTableMatches

Then %DataTableMatches[0]['Row']% will give you the direct value

Meaning:

The word FOUR was found on the 3rd row (starts from 0)

You can do a +1 to get the answer as 4th row

%DataTableMatches[0]['Row'] + 1%
JezAuditore 44 on at

Like
a
(1)

Report
Copy link

Link copied!

@VJR legend thank you
josephspengler 123 on at

Like
a
(4)

Report
Copy link

Link copied!

@VJR Great stuff.

Taking it one step further, let's say I have a Column 3 in MyDataTable and I want to know that value.

To get that, amusingly the +1 actually is important! Otherwise the result the the text '3'. In fact, if you want to get the actual row, it's easiest to use +0 to force it to be a number. (you could also add an extra step to convert text to number).

So in your example table, to get the third column, from the table where to row contains FOUR the formula is:

%DataFromWebPage[DataTableMatches[0][0] + 0][2]%