cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (7,959)