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

Connecting dataverse tables via multi fields

My schema requires I use multi-element access between tables...  (ie. Company+Employee) not an uncommon database problem.  Power Apps allows you can create multi-field keys but does not allow you to use then in model-driven development.  

 

I read that one method is to create a calculated field and concatenate the fields into that.  but the CONCAT() function does not work with fields that are either LOOKUP or  CHOICE.

1 ACCEPTED SOLUTION

Accepted Solutions
HSheild
Super User
Super User

Hi @cshinneman 

 

Have you tried the Concat function using a string field from the Lookup? I.e. here are the instructions from Microsoft docs

 

You can access parental columns via the Lookup column to the parent table, such as <LookupFieldName>.<FieldName>

 

 

 

 

View solution in original post

2 REPLIES 2
HSheild
Super User
Super User

Hi @cshinneman 

 

Have you tried the Concat function using a string field from the Lookup? I.e. here are the instructions from Microsoft docs

 

You can access parental columns via the Lookup column to the parent table, such as <LookupFieldName>.<FieldName>

 

 

 

 

View solution in original post

This worked great in getting a calculated field that was a concatenation of two fields.  Thank you!

 

Now I am attempting to use that field as a lookup in the child table.  It works in a very odd way.  In one instance it brings in the locally defined field (of the calculated column) in the parent table but on the looked-up field in the parent.  In another case the parent table shows as a popup table but when a record is selected no data is copied into the child field.  In another case  where the parent calculated field is composed of two lookup fields no popup table shows at all.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,588)