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

4 REPLIES 4
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>

 

 

 

 

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.

I need the same for a CHOICE field. 

2254
New Member

0

I tried using the Calculate function when defining Dataverse table column for getting a value out of another column (lookup) in the same Dataverse table. It should work based on Microsoft note (https://docs.microsoft.com/en-us/power-apps/maker/data-platform/define-calculated-fields) by add a "." and the required column name from the source table. I was able to save the Calculate function without errors prompted. However, after adding a new record, such Calculated field shows blank results while other fields in the same table are correct. Anyone has any ideas on what might went wrong? Thanks

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 (3,838)