News and Announcements icon

Power Platform CommunityForums Power Apps - Microsoft Dataverse Dataverse see two tables

Power Apps - Microsoft Dataverse

Answered

Dataverse see two tables

(0) Share

Report

Report

Posted on by _Judy_

91

Hello, Could I ask if I want to see two dataverse table join togeter.

How to do it?

That is my design.

Table A

key	Course_Type
0001	A
0002	B

Table B

TableA_key	Course_Name	Course_Type_lookUP
0001	Music
0001	Art
0001	P.E.
0002	Cook

I want to see :

TableA_key	Course_Name	Course_Type
0001	Music	A
0001	Art	A
0002	P.E.	B
0001	Cook	A

Thanks.

Categories:

Microsoft Dataverse

All responses Img

All responses (2)

Answers Img

Answers (1)

_Judy_ 91 on at

Like (0)

Report

Re: Dataverse see two tables

Thank you dpoggemann.
: )
Verified answer

Drew Poggemann 9,278 Most Valuable Professional on at

Like (1)

Report
Re: Dataverse see two tables

Hi @_Judy_ ,

Create the table A for your Course Types in Dataverse

Create Table B with your Courses and you should add a column to this table as a Lookup and then point this lookup to Table A (course types)

At this point you will have created a 1:N relationship from Course Type (table A) to Course (table B). You can add a tab in your Course Type form to show the list of all the related Courses (using Subgrid) or even add to the same tab as well.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Apps - Microsoft Dataverse

#1

stampcoin 17

#2

mmbr1606 15 Super User 2025 Season 1

#3

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans