Answered

Showing label data on screen from multiple data sources

(3) Share

Report

Posted on by alan_user

I am looking for advice on if it's possible to create a canvas app with labels pointing to data on multiple Dataverse tables and the data is related so updates when one selection is made?

I have copied some tables from a local database to dataverse tables. I set up a relationship based on customer ID.
I would like to have labels pointing to different fields across several different tables in Dataverse, is this possible?

At the moment my workaround is to display 2 galleries on one page, the first gallery displays customer data and the second gallery displays transactions and more data, based on a filter where gal1.customerID = gal2.customerID

Is there a better way of doing this? I have a good few tables to relate but can’t get this working like a traditional database model.
Can anyone advise me on if this possible?
Thanks

Categories:

Building Power Apps

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @alan_user,

Yes, this is possible in a Canvas app.

Approach:

If your tables are related using Dataverse lookup columns, you can reference related fields directly in labels. You can expand the lookup column and show the appropriate data.

below example assume "Customer" is lookup column i want to show customer address then i can simply expand that lookup column and do.

ThisItem.Customer.Address1_City

Alternatively, for pulling data from other tables using LookUp():

below example I'm just comparing the CustomerId column and pulling the amount from Transactions table.

LookUp( Transactions, Customer.CustomerId = galCustomers.Selected.CustomerId ).Amount

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

1 people found this reply helpful.

Was this reply helpful? Yes No
alan_user 73 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kalathiya, thanks for your assistance. I have used both solutions successfully on my app now.

The first suggestion works best for me in this instance, so I will use that. Thanks again for your help and the quick response

Alan

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @alan_user,
Thanks for letting me know! I’m glad to hear it’s working well. Happy to help anytime!

Was this reply helpful? Yes No