Unanswered

Table in the container - how to add column from related table

(0) Share

Report

Posted on by stribor45

I have table A that I am displaying inside the container in my canvas app. This table have multiple columns and one of the columns is column called Product which is of data type Lookup. This look up related table is Product table that has multiple columns which includes Color column. I would like to display this column in my container where I am showing table A but I am not having much luck with this formula as it is not showing me any data. This is my fx code

AddColumns('Table A', Color, Product.Color)
 
This doesn't give me any errors and my table no displays nothing.
 
Help please!!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @stribor45,

You did not state your data source type, but I will assume SharePoint for the purposes of this response. You also did not state the field name in the other table that you are looking up, but the structure would be something like this
AddColumns( 'Table A', Color, LookUp( OtherTable, FieldLookupedUp = Product ).Color )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
stribor45 54 on at

Like (0)

Report

This gives me bunch of errors every argument seems to be underlines with red lines. These table don't have specific relations. All connections between these tables is suppose To build using lookup field which is column "Product". I added both of these tables as dataverse sources but only seem to be able to see the first table

so if i click add source and select Table A then I click add source and add Product I only see data for table A

so if I click add source and select Product and I click add source and add Table A I only see data for Product

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@stribor45,

That is why is it is good to state your data source in your initial post. I assumed SharePoint (as per my post). It still should work however - what is the exact code you attempted ?

Was this reply helpful? Yes No