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
Solved! Go to 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
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
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
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.