Share
Report
25I receive an email every morning that is a table of employee numbers and the projects that they work on.
Here's a diagram example:
Empl # Proj #
1001 99Z1445
1002 99A5874
1002 99B1234
1003 99KZ546
1004 99Y2322
Every employee has 1 project, but employee 1002 has 2 projects.
I have another list that is a master list of employee's with names, phone numbers, supervisors, etc. It kind of looks like you would expect.
Okay, one more list. I create a brand new list that is going to be used with a power app that is for commenting on project #'s for each employee to capture those comments. What I'm trying to do is, when a comment is input, the 3rd list not only records the comment, but also the supervisor's name (pulled in from the master list). It seems that when I use a lookup field in the 3rd list, and because employee 1002 has 2 entries, the lookup field is .
Is there a quick solution to record the supervisors name inside that comment (3rd) list?
All responses (
Answers (
