cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alandilworth
Frequent Visitor

Cannot reference columns in Table B from Table A after forming relationship

Hello,

 

I'm in dire need of help. I have been struggling with this for weeks now. I'm trying to form the equivalent of a SQL join and I am not able to reference columns from the other table. I can see the columns when I use the lookup (the predictive text), but there is no data. It appears to be joining off the incorrect column, but there is no way to specify the columns when creating the lookup.

 

My desired result is to be able to do something like LookUpColumn.ColumnFromOtherTable. I've read things about needing to do something with the GUID but do not fully understand it.

 

Any help will be incredibly appreciated. I am using a canvas app by the way

5 REPLIES 5
Mira_Ghaly
Dual Super User
Dual Super User

@alandilworth 

Have you tried using the lookup function, so you can lookup the row from the lookup table then you will be able to reference the row fields.

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Thanks for the response Mira. I’m trying to avoid this if possible. I really prefer to use my tables in a true relational way since I want to have a scalable application with minimal overhead.

@alandilworth 

I have tried a sample on my side , so in my case I have account and a Primary contact field which is a lookup field on the Account and this is the way to get information from Primary contact, you can't reference directly as you are referring to or at least as per my knowledge.

Mira_Ghaly_0-1658904214982.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
alandilworth
Frequent Visitor

I'm really trying to avoid using the lookup function to reduce overhead and take advantage of my table structure

AhmedSalih
Super User
Super User

Hello, @alandilworth, are you using a Gallery in your powerapps? Also, would you share a screenshot of your screen design?

 

Regards,
Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,250)