Customer experience | Sales, Customer Insights,...

Want to take values from two table and put them in one table

(0) Share

Report

Posted on by Prashant.ITT

153

Hello all,
I have created total of 3 tables and I want to combine the data from 2 tables to one table. There are some columns in one table and there are some columns in second table and in third table, all columns are present. So, I want to take values from all columns and fill in third table. When i combine the data from two tables then in third table it should come in one row.
Is it possible? If yes then how can i do this ?
I am open to use any thing like cloud flow, workflow, plugin.

Thank you in advance

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Pradeep Rai 5,489 Moderator on at

Like (1)

Report

RE: Want to take values from two table and put them in one table

Hi,

You can use below option:

1. Export and Import - Export data from both tables and Create one combined columns excel and import that file directly in CRM.

2. Power Automate (Cloud Flow) - You can write one Scheduled Power Automate which will fetch data from first table and then matching record from second table. After this you can directly create record third table.

Note: First and Second Table must have some field based which you can identify the link between records.

Was this reply helpful? Yes No
Arulmozhi N 40 on at

Like (1)

Report

RE: Want to take values from two table and put them in one table

Hi Prashant,

You can achieve it by using Power Automate Flow. Follow the below steps.

1.Select Your table 1 from Dataverse

2.Select Your table 2 from Dataverse and write the fetch xml query for 2nd table. You need to filter based on common values from two tables.

You can use the XRM toolbox for fetch xml query.

3.

4.Finally save &run the flow.

5.Now you can see your third table with the combination of 2 tables and it will be come in one row.

Was this reply helpful? Yes No
Vignesh565 5 on at

Like (0)

Report

RE: Want to take values from two table and put them in one table

You can use a Power Query in Power Platform to combine data from two tables into a single table

Here's a basic example using two tables, "Table1" and "Table2", with a common column, "Column A":

Open Power Apps and go to the "Home" tab

Select "Get Data" and choose the appropriate data source for your tables

Load the two tables into the Power Query Editor

In the Power Query Editor, right-click on one of the tables and choose "Reference"

Right-click the other table and choose "Combine Queries" > "Join"

Choose the join type you want to use (e.g. "Inner Join", "Left Join", etc)

Specify the columns you want to join on

Load the combined table into your report or app by clicking "Close & Apply" in the Power Query Editor

You can then use this combined table in your report or app as needed

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

RE: Want to take values from two table and put them in one table

Does this tables related to each other in any means ? because if they are then it will be little difficult process. Mainly power automate can help. But there are other factors depending on the tables.

My suggestion will be first check how you can related this tables each other. and make sure to cover the scenarios like what if any one of the record is disabled/Inactive. what if it is changed by the user? does it have any custom logic on it the how will you implement on new table.

Thank you,

Amit Katariya

Was this reply helpful? Yes No