Access Related table data in a Gallery Control

[Poweruser1101]

Hi All,

I am trying to display related table Column in a gallery control but i am unable to do so.

I have a lookup of Entity B on Entity A in dataverse. I have created a gallery control in my canvas app and the items property of gallery is set to 'Entity A' and I want to display a column say 'Category' from 'Entity B' in the gallery.

Category is an option set on 'Entity B'

I tried the below formula however i am getting an error say 'Expected Text Value'

LookUp('Entity B','Entity B'=GUID(ThisItem.'Entity B'.'Entity B')).Category

Kindly help

[dpoggemann · Accepted solution]

hi @Poweruser1101 ,

One easy thing you can do here is to create a view in Dataverse that adds your columns from Table B into a Table A View and since it is a Lookup column it will allow you to do this.  In the Gallery you can then utilize this view and you will have access to your columns from Table B directly from the columns.

Thanks

Drew

[rampprakash]

Hello @Poweruser1101,

You can try @dpoggemann solution hope it will work, if you want to do it in PowerApps add all the values in a COLLECTION and display the same..

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

[Poweruser1101]

Hey, 

Thank you for responding. I created the view and added the column from the lookup entity and tried the below in the gallery
ThisItem.'Entity B(LookUp)'.'Name'  It worked.