Hi All.
Sorry not a very descriptive title however I need some help with a transfer function in my app.
When I set up a new member of staff on the app via a person picker their base location it taken from their User Profile and written into their record in the SharePoint list as plain text.
The manager of each site accesses the app is only able to view staff who's office location matches theirs.
When someone transfers to another location, at the moment I have to edit their location in the SP list but I want to make this a process for manager to initiate a transfer.
In order to do this, I have a page with a text input box, when the manager enters the employee ID I need it to look up and display the staff members name and current location in a Text Label, I then need to them to be able to select a new location from a drop down.
I thought I could use something like this:
LookUp('SPList', TextInput1 = ThisItem.'EmployeeID', 'Staff_Name')
However this doesn't work.
Can anyone suggest how I can get this to work?
Many thanks
