Unanswered

Joining 2 database in 1 datatable

(1) Share

Report

Posted on by cha143

Please show me how to arrange the data table with two databases, because the first table appeared on the upper. but I need to combine and sort them according to the transaction date.

and also in the second database, the value didn't display on the datatable; it looked like this.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

royg on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @cha143,
To join 2 tables, use the Table() function. Any matching columns will be merged into a single column, and unique columns will be appended to the table. For example, add a button that collects to tables:
ClearCollect(tbl1, {ID: 1, Title: "A", Value: 1000}, {ID: 2, Title: "B", Value: 2000}, {ID: 3, Title: "C", Value: 3000}, {ID: 4, Title: "D", Value: 4000}); ClearCollect(tbl2, {ID: 5, Title: "E", TextValue: "AAA"}, {ID: 6, Title: "F", TextValue: "BBB"}, {ID: 7, Title: "G", TextValue: "CCC"}, {ID: 8, Title: "H", TextValue: "DDD"})
Then, add a table control to display the merged tables and set its Items property to:
Table(tbl1, tbl2)
You should get the following:
Hope this helps

Was this reply helpful? Yes No
cha143 55 on at

Like
a
(1)

Report
Copy link

Link copied!

my table are from sql and SP i think i didnt declared the value of the table

Was this reply helpful? Yes No
royg on at

Like
a
(1)

Report
Copy link

Link copied!

No need to declare, that was purely for demo purposes.
Try joining both your table objects using the Table() function and share the results.

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
hi @cha143 ,
Retrieve Data from Both Databases
Assume you have two databases, DB1 and DB2. First, retrieve the data and store it in collections.

// Retrieve data from the first database ClearCollect(CollectedData1, DB1); // Retrieve data from the second database ClearCollect(CollectedData2, DB2);

Combine Data
Combine the data from both collections into a single collection.

// Combine data from both collections ClearCollect(CombinedData, CollectedData1, CollectedData2);

Sort Combined Data
Sort the combined data collection by the transaction date.

// Sort the combined data by transaction date ClearCollect(SortedData, SortByColumns(CombinedData, "TransactionDate", Ascending));

Display in Data Table
Bind the sorted collection to the data table.
Add a Data Table control to your PowerApps screen.
Set the Items property of the Data Table to SortedData.

SortedData

This approach ensures that data from both databases is combined, sorted by the transaction date, and displayed correctly in the data table. If there are specific issues with the second database not displaying values, ensure to debug by checking field names, data types, and connections.

Was this reply helpful? Yes No