Answered

Display data from multiple Dataverse tables.

(0) Share

Report

Posted on by Az8PnG

Hi everyone!

Anyone have the idea on how to display data from multiple Dataverse tables in a single view without physically appending the data into a new table?

I have 3 tables here which is Test123, Test 123b, and Test 123c.

I am planning to join this 3 table, into 1 big table.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

BCLS776 8,994 Moderator on at

Like (0)

Report
Copy link

Link copied!

There are two main ways to bring table values together: through lookups or through relationships. Lookups work when there is a common column between the two tables, so you can use that column to find the corresponding value in the other table.

Relationships, for relational databases such as dataverse, take this one step further. The common column is a lookup-type column, so using the dot operator in Power Apps we are able to directly drill down to the desired field. Once you have defined and populated a lookup column in your Orders table to your Customers table, you could directly get a value for a gallery of Orders using ThisItem.Customer.Age

Hope that helps,

Bryan

Was this reply helpful? Yes No
Z_Lukowski 216 on at

Like (1)

Report
Copy link

Link copied!

Hello @Az8PnG
I believe You're looking for solution using SQL Joins, its possible in Power Apps but need couple of functions:
1) Left Join:
https://youtu.be/tABaxLVAnvs
2) Inner Join:
https://youtu.be/2n4j3t_0Obo

What I see in your tables is the common column problem, You showed no column that is used between all the tables, so how can you know to which ID which name is matched? I think if these are Orders they should match on ID and food from order should match Food on {Order} which is some kind of sub-category for food?

Hope you find it helpful 🙂

Was this reply helpful? Yes No
Az8PnG 85 on at

Like (0)

Report
Copy link

Link copied!

Hi @Z_Lukowski & @BCLS776 thank u for helping me out!

Is it I need to have an ID or name that match between 3 tables? Is there any possible way to display all 3 tables in 1 table without append to create a new table?

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report
Copy link

Link copied!

As @Z_Lukowski pointed out, you need a column in each table that is common to at least one other table - this is how you perform queries using LookUp() or Filter() in PowerApps.

There is nothing wrong with having more than one table; in fact, as your data schema grows this will help you keep it organized and logical

Was this reply helpful? Yes No
Az8PnG 85 on at

Like (0)

Report
Copy link

Link copied!

Alright @BCLS776 do you have any example on using the lookup and filter function? Thanks!

Was this reply helpful? Yes No
Verified answer

BCLS776 8,994 Moderator on at

Like (1)

Report
Copy link

Link copied!
Yes, there are plenty of examples if you do a search on here, or if you look in the official Microsoft Documentation. You'll want to get very familiar with both of those sources of information - they are daily references for me.

The one thing to remember: LookUp() returns the first matching record, while Filter() returns a table of matching records:

Filter(OrderTable, Order = "Desserts")

Returns a table of the items in the OrderTable with the Order column value of "Desserts"

While:

LookUp(OrderTable, Order = "Desserts")

returns the first matching record

Was this reply helpful? Yes No