Unanswered

Referencing Datatable Row with Variable (After Searching for Matches)

(0) Share

Report

Posted on by Ukiman1014

After finding a match in one column of a datatable, I want to read a different column value in that same row. The error I'm getting below is that the value of the row, the row number of the match, is not a valid property. Meaning, if it finds a match on row 55, it successfully sets the "MasterPV_Row" variable to 55, but then when trying to reference row 55, I get "55 is not a property" error. What am I doing wrong?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

This is because for some reason (no idea why) the Find or replace in data table action returns the row and column indexes as strings. But you need them to be numeric to use them to reference a value in the table. So, you need to use the Convert text to number action on the index to convert it to a valid numeric index. After you've converted it, you can use it the way you're already doing it - your syntax is actually correct.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Ukiman1014 on at

Like (0)

Report

That did it - thanks! I also have it step through the matches, as there could be more than one.

Was this reply helpful? Yes No
fabianmaltempo 2 on at

Like (0)

Report

Hi all. When I try to convert the text tu number, it is giving error: Can't convert text 'DataTableMatches2[0][0]' into a valid number (text provided is either in a non-recognizable format or contains too many characters

It is a 1.

Has anyone faced something similar?

Was this reply helpful? Yes No