Answered

Configuring model-driven app view to show related data

(0) Share

Report

Posted on by ilied84

Hello!

I'm currently building a model-driven app and I noticed a problem, which on paper seems simple, but I can't seem to find a solution. Here's the problem in a nutshell:

1. I have a table called "Placementlocation" and a table called "Customer". The point is, that the user can select a customer to be put in a placement location.

2. I created a lookup column on the Placementlocation table, that points to the Customer table. I can select a customer and it works as it should.

3. I created a view on the Placementlocation table, that shows which customer is on which location. This works fine.

4. I need to create a view on the Customer table, which shows all the customers and in the same view, shows the location where the customer is placed. I can't seem to find a way to do this. When I edit the view, it does not show the placementlocation, since there is no lookup field to the Placementlocation table. The relationship is there, but how do I show the related data in the view in this case?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ilied84

You cannot create that because there is no one-to-one relationship in Dataverse. There is only one-to-many and many-to-many.

You will need to rely on the placement location table and modify the view to see which customer is in which location.

You can try adding a lookup in customer table as well and maybe use a flow to update when either of the lookup is modified but this is not a good idea as it creates confusion and might cause misinformation later down the track.

Hope this helps.

Cheers!

Was this reply helpful? Yes No
realwillwright 772 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @ilied84

There is a good video from Lisa Crosbie which might help, it won't show it directly in the view but you can expand it to show it as a nested item. (38) Boost Your Model Driven App's Functionality: Creating Nested Child Grids in Under 5 Minutes - YouTube.

Failing that, similar to what narayan suggested, you could create a text column in Customer and create a Process Workflow which updates this column to match the placementlocation, you would create the Process Workflow against the placementlocation table and to run when the placementlocation 'Customer' column is modified.

Was this reply helpful? Yes No
ilied84 18 on at

Like (1)

Report
Copy link

Link copied!

Thanks for all the help! I solved this with a lookup field in the customer table, which in turn is modified by real time workflows and business rules, to avoid any mixups in the future. The app works in a very specific way, where the possibility of an error regarding this functionality is minimal, so this solution works perfectly.

Was this reply helpful? Yes No