web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,240 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No

Join the conversation