I have two list mapPins which has all of the employee assigned to a specific desk, the other list is the list to move from one desk to the other.
I have a form that is the intake for the move request. I want to prefil the Move From field in the from looking up the current user in the mapPins list and populate it with the desk location.
I tried this while it doesnt throw any errors it is not returning any value. I know i am missing something.
LookUp(
mapPins,
Title = DataCardValue3.Selected.Email,
'Current Occupant'.Email
)

Report
All responses (
Answers (