Unanswered

Merge two excel table based on the unique id

(0) Share

Report

Posted on by Tourist

I want to merge two excel tables which have different columns but one same unique column "ID". So I wanna merge every row of first table relevant to their row in 2nd table based on that ID column

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

powercorner 477 on at

Like (0)

Report

hello @Tourist ,

you could make arrays out of them and then use some join logic like this guy explains here:
Create super fast joins of 2 arrays in Power Automate (sharepains.com)

With regards,
Kevin

Was this reply helpful? Yes No
Tourist 65 on at

Like (0)

Report

@powercorner No. Of columns and their names will be different every time only ID column will be same
@Paulie78 @Pstork1 @yashag2255 @abm

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Since the connector needs to know the columns in the table to be instantiated its not possible to dynamically change the schema of the table. You would need one connection for each table.

Was this reply helpful? Yes No