Pull data from two SPO Lists based on People Column

[Travis5150]

Two SPO Lists.

Assignements

Engineers

Assignments has an AssignedTo column, that is a lookup column to Engineers.Title.

Engineers.Title has the SMTP address of the user.

Engineers.Engineer is a People or Group Column.

I have set this up so that managers can search for the engineer by their displayname instead of smtp, just making it visually easier.

My drop down is working.

My Table is pulling stats from the same row as the engineer picked in the combobox.  This is working.

The problem is the Assignements SPO List.

There is an AssignedTo column, that lookup column to Engineer.Title.

I am trying to find a way, so that when the user in the drop down is selected, we somehow do a lookup of the email of the selected user.  I know what I currently ahve does not work.

I was even thinking of adding a text box that I could populate with the Engineer.Title or something and reference that?  But that did not work either.

So what should happen is we select the user in the drop down.  My datatable is populated.

We somehow do a lookup of Assignments.AssignedTo and match it with the Engineer.Title somehow from the above, and it should list the assigned items to that engineer in the BrowseGalery1

[RandyHayes]

@Travis5150 

I'm getting a little confused!!  You are posting this same scenario in multiple posts.  I would suggest that we work on one of them and resolve the issue there.

I was about to reply to your other post from earlier and then saw this one.  Which do you want to work from?

[Travis5150]

Yep, I screwed up.  I was trying to consolidate the threads I made, cause I kept changing direction to cause LESS confusion.  Looks like that did not work LOL.  It doesnt help that I named the threads almost exactly alike now that i went back and looked at them.....no coffee yet :(.

These two posts today, this one and then this:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Find-Default-user-using-User-Email-and-compa...

Are the two I am working on today.

To me they seem very different, but to you they are more than likely the same as you know what you are doing :).

Lets work the other one for now.  If it turns out the solution is similar, I will try it here, if it does not work, I will tag you and we will continue working this one.

For now, I will ping you in the other thread.

[Travis5150 · Accepted solution]

I was able to resolve this by adding an additional Lookup Column back to Engineers for UPN, all within SPO.

I could then filter on UPN in the same list.