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?