cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TrentRush
Level: Power Up

pulling record from one table into another table from dynamics 365

I am wanting to pull username from one table based on matching userID's (both tables have this data) and add the user name with the rest of the data from the opportunity data (see photo below)

both tables are being pulled from dynamics 365

 

How do either merge tables or do a lookup from one table to list the username in another table?  without doing an "apply to all" which only lists the opportunities multiple times with every username in the table.

 

 

 

flow data.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
v-zhos-msft
Level 10

Re: pulling record from one table into another table from dynamics 365

Hi @TrentRush ,

It seems you want to add the user name from one table to another.

There is a matching column(ID).

I have made two tables, shown as below:

Capture9.PNG

Then I made a flow to add the Name from Table1 to Table2 based on the ID.

Capture10.PNG

Result:

Capture11.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-zhos-msft
Level 10

Re: pulling record from one table into another table from dynamics 365

Hi @TrentRush ,

It seems you want to add the user name from one table to another.

There is a matching column(ID).

I have made two tables, shown as below:

Capture9.PNG

Then I made a flow to add the Name from Table1 to Table2 based on the ID.

Capture10.PNG

Result:

Capture11.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

TrentRush
Level: Power Up

Re: pulling record from one table into another table from dynamics 365

I ended up just adding invisible fields in the opportunities data set that were single line text and used a flow to compare the common field and update record.  Works for me since we only run this flow weekly, so I just run the other flows that copy data right before so that the data is current.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,276)