Get Value of related table

(0) Share

Report

Posted on by wshalex123

160

Hello everyone,

i don't quite understand the relationships between tables in dataverse or i just can't find a solution for my issue:

i got two tables:

EmployeeAttendanceList

ID of the employees
1 or 0 if the employee is attendant or not

Employees:

ID of the employee
Name of the employees

... these tables are generated by a dataflow out of a SQL Server.

My goal: Display a Attendance list (In a SP List) of all attendant employees WITH their Names.

-> Since the Name of the employees is not in the Source table of the SQL Server, i need to create a relation between the EmployeeAttendanceList and the Employees table.

So far, i created a lookup column in the EMployeeAttendanceListe and therefore create a relation between thos two tables. Also, i created a calculated column linked to the related table:

cr811_meinezeiten_employees is the "Employees" table
.cr811__login is the "Name" column in this table.

... with my research, there should be displayed the Name of the Employee now. But the column is empty....

What am i doing wrong here?

I appreciate any help!

Cheers,

Alex

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, @wshalex123, You might need to use a Formula Column instead.

Was this reply helpful? Yes No
wshalex123 160 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @AhmedSalih. Thanks for the tip, i also hopped over on of your youtube videos during my research.

Yould you show my how the forumla could/should look like for this scenario?

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@wshalex123, is the EmployeeAttendanceList table, Create new Column and select the Data type as Formula:

In the Formula, you need to use the LookupColumnName.cr811__login

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

New Project.png

Was this reply helpful? Yes No

wshalex123 160 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @AhmedSalih,

it does not display me any data. (Also when deleten all entries and refreshing the dataflow).

PS: I dont know if its relevant, but my lookup column is also empty.

I am just wondering, how the lookup function knows, that it needs to compare the EmployeeID's as primary key in order to get the referred "_Login" value? In PowerBI you also need to select which two Columns a Relation should compare.

Would appreciate your help.

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@wshalex123, the LookUp Column should show the values that are in the Primary Name Column of your Employee Table. Do you have any values in that column?

Was this reply helpful? Yes No
wshalex123 160 on at

Like
a
(0)

Report
Copy link

Link copied!

@AhmedSalih , yes it shows the values of the primary column of the Employees table, but only in a dropdown if i click in the field. The field itself is empty.
(Lookup Column of EmployeeAttendanceList)

Was this reply helpful? Yes No
wshalex123 160 on at

Like
a
(0)

Report
Copy link

Link copied!

#up

Was this reply helpful? Yes No