Answered

Pass value of one data table to another in Power Automate Desktop

(0) Share

Report

Posted on by Marutha_K

I have used "Find and replace" in Data Table function (just find) and the result of this function is stored in the Data table "DataTableMatches" -> example output is (1,0) -> it finds the match and displays the row and column number of the match as shown below

Now, I need to pass this value of Row (9) and Column (0 + 1 - adding +1 to find a specific value in a row hence column index will be 1) to another Data table (let us say it is called DataTableFinal) to find a specific row.

How to pass this value to the data table "DataTableFinal" so that I can find a specific value from it? I have tried many ways but no luck yet.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

%DataTableMatches[0][0]% will give you the rowvalue 9 so store it in a variable lets say myRow

Likewise, %DataTableMatches[0][1]% will give you the columnvalue 0. Store it in a variable lets say myCol

(If the data you need is not on the 0th row of your data table then you will need to use a For each)

Then use them as variables on your final data table.

%DataTableFinal[myRow][myCol]%

Add 1 where you see as necessary.

Was this reply helpful? Yes No
Marutha_K 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply. Sometimes, we miss the easiest way to handle variables. I was successfully able to extract the X and Y values separately (myRow and myCol values are displaying as expected in the flow variables result section) but when I pass it I get this error which is strange:
%DataTableFinal[myRow][myCol]%

%DataTableFinal[myRow][myCol]% -> myRow Value is 8, myCol values is 0. But when it's passed it shows the above error.

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

@Marutha_K , you have closed the thread after your above reply. Hope your issue is resolved. If not please post screenshots of your datatable and the flow with the action that has the row and column variables.

Was this reply helpful? Yes No
Marutha_K 51 on at

Like
a
(0)

Report
Copy link

Link copied!

@VJR Yes, I have understood what needs to be done to easily pass the values from "DataMatchesTable" to another data table to find the exact row hence marked the answer as solution. But when I passed the value to the final data table, I have received an error. Below screenshot for reference.

DataMatchesTable:
DataManufacturerTable to which I am passing values of row and column value extracted from DataMatchesTable to get desired output
Expression or action:

Error message
Thanks for your help!

Was this reply helpful? Yes No
Verified answer

Marutha_K 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Found the issue why there is an error while passing value as Row and Column to the Data Table. While extracting the values from DataTableMatches -> it's stored in a variable Row which is stored as text but not number which is expected while passing to %DataTableFinal[myRow][myCol]%

Hence converted myRow and myCol to Number using "Convert Text to Number" action and then passed those values as numbers to DataTableFinal. This fixed the issue.

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

In my example to you I have declared myRow and myCol as Number datatype in the Input variable section.

Was this reply helpful? Yes No