Showing results for 
Search instead for 
Did you mean: 
Advocate V
Advocate V

Datatable Joins

I have two DataTable variables in PAD and need to join them. Is there a way to do this in PAD without using a SQL database?

Resolver III
Resolver III


The number of columns needs to be the same.

try it sample.


SET NewVar TO {[1, 2, 4], [6, 7, 8] }
SET NewVar2 TO {[8, 2, 4], [6, 7, 8], [5, 6, 7] }
LOOP LoopIndex FROM 0 TO NewVar2.RowsCount - 1 STEP 1
SET NewVar TO NewVar + NewVar2[LoopIndex]

スクリーンショット 2021-06-02 010133.jpg

Thanks for the reply @ZS440 , but it looks like your solution produces a UNION, but I'm looking for a JOIN (specifically LEFT JOIN).

Hi @ZS440 , I know that this is an old post but your solution would be exactly what I need.

But I failed to apply it.

When I apply the last Set variable action, it is like this:


On your screen you don't have the ' among the +.

How did you get that?


Thank you in advance.

Resolver III
Resolver III


%NewVar% + %NewVar2[LoopIndex]%

Note the "%" and try writing

%NewVar + NewVar2[LoopIndex]%

Helper I
Helper I

You're my hero! 🙂

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (6,266)