Concat two tables based on a given column in each table

(0) Share

Report

Posted on by goncaloperes

Hi!

Currently using Power Automate Cloud.

I have two Excel Sheets, each with a table, that I want to join.

Table 1 has names "Column1" and "Column2"
Table 2 has names "Country", "Description", "Zip",...
The "Column1" in Table 1, has values that correspond to "Country" in Table 2.

My goal is to have a final table, with: "Country", "Description", "Zip",... and "Column2".

In Python, for example, one could concat, but concat doesn't seem to be available in PAC. How can one achieve this?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-peijunz-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @goncaloperes

Based your description, I have made a simple test for your reference.
1. Excel files with tables:
2. Here is the flow:
3. Result:

Best regards,
Sylvia

Was this reply helpful? Yes No
goncaloperes 85 on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-peijunz-msft.
That solved the problem.
However, as the tables were relatively big, and according to the Process Advisor it was taking more 8min to run, ended up using Python.
For those considering the Python approach, this might be relevant: https://stackoverflow.com/q/53645882/7109869

Was this reply helpful? Yes No