Power Platform Community Forum Thread Details

Hi Everyone,

I'm diving into Model driven apps now and am struggling to create a view that effectively shows my data.

I have three tables - Transactions, Jobs, Clients, Contacts where there is a relationship or lookup between the Transactions table and the Jobs table, and relationships between the Jobs table and the Clients and Contacts tables. What I want to do is display the following fields :

Date, Status - from Transactions

Title - From Jobs

Name - From Clients

Contact Name - From Contacts

But when I add these to my view, the Client > Name and Contact > Full Name columns are empty / blank, despite their being available in the field navigator. I've tried to find out if these multi layer relationships can be traversed but had no luck. I would have expected though, that if the fields weren't available due to this navigation limit, they wouldn't be available in the field selector.