cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yamamoto
New Member

Combine multiple data table from form processing model

Hello everyone,

 

I just created one form processing model to process my pdf file, the pdf file have multiple table tagged inside.

This both table share a same identity row which call ID number, I want to know is that any way to combine this two table into one table?

I tried use array to merge two table, but I want to pass the combined table data into Power Automate Desktop to perform some automation process. I can't pass array inside because I defined input variable in PAD.

 

 

3 REPLIES 3
CedrickB
Power Apps
Power Apps

There are several options to achieve what you want.

You can take a look at this post which provide a solution

Create super fast joins of 2 arrays in Power Automate (sharepains.com)

Yes, but I only want pass a single value to my PAD which share same ID, not whole array.

For example :
I have a table A with ID,name and table B with address.

I want to combine this two table, so when I pass table A ID and name to PAD, I will be able to pass address with same ID.

 

Hi Yamamoto,

Looks like I'm struggling to understand your use case because the link I have posted above does exactly this

 

Table 1
ID | NAME

Table 2
ID | ADDRESS

Resulting table
ID | NAME | ADDRESS

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (2,814)