Dataverse related tables PowerApps Canvas

Can anyone help me please, I am trying to retrieve data about Employee and Project from Gallery (DataSource: AssignmentDate),

My tables are connected like this: I am able to retrieve data about Project/Employee if I connect my gallery to assignemnt, but not from assignment date.

Any ideas?

enter image description here

I am trying to display data from connected tables

Solution

you won't be able to get data about Employee and Project from AssignmentDate.

If you see in your data model your project and employee are connected to assignment.

solution, first you will have to retrieve assignment record, fields project code and emplyoee hrd. Then you will have to do lookup function for each project and employee based on your fields project code and emplyoee hrd