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

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
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (11,664)