News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps data table - displayin...

Power Apps - Building Power Apps

Answered

data table - displaying records from 2 tables

(0) Share

Report

Report

Posted on by cheezy

148

i have two data sources - sample of some fields from each source:

Common link between the two tables is the ApptID.

Source 1 -Table 1 - ApptID , Date, Time, Name, Address, Phone

Source 2- Table 2 - ApptID, Comments, Actions

Not all records in table 1 would have a related record in table 2

I am trying to display related records from both tables as single rows in a data table, so something like this:

ApptID , Date, Time, Name, Address, Phone, Comments, Actions

and if no related records in table 2 then Comments and Actions in the data table would be blank.

I understand i need to change the items in my data table? but just how? thanks

Categories:

General Questions

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

WarrenBelz 146,668 Most Valuable Professional on at

Like (1)

Report
Re: data table - displaying records from 2 tables

Hi @cheezy ,

The Items of your Data Table would be something like this

AddColumns( RenameColumns( Table1, "ApptID", "AID" ), "Comments", LookUp( Table2, ApptID = AID ).Comments, "Actions", LookUp( Table2, ApptID = AID ).Actions )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Re: data table - displaying records from 2 tables

Hi @cheezy

We have to get using Addcolumns from other sources and bind to Datatable. For example

AddColumns( IssueTracker, "EventName", LookUp( EventIItinerary, Event.Id = ThisRecord.ID ) )

In the above example, It gets all data from IssueTracker and Event name from EventItinerary source