LookUp records based on Text input value

(0) Share

Report

Posted on by Angry_Sys_Admin

181

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

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: LookUp records based on Text input value

Hi @Angry_Sys_Admin

Have you solved your problem?

Do you want to display the name and current location based on the employee ID?

Please set the Tex property of the Label as below:

LookUp('SPList', TextInput1 = ThisItem.'EmployeeID', 'Staff_Name'.DisplayName)

If Staff_Name is a Person type, please refer to the DisaplayName parameter of Person column.

LookUp('SPList', TextInput1 = ThisItem.'EmployeeID', LocationField)

This is for displaying location field(assuming it is a Text column).

To display both name and location, you could use Concatenate them using the "&":

LookUp('SPList', TextInput1 = ThisItem.'EmployeeID', 'Staff_Name'.DisplayName)&LookUp('SPList', TextInput1 = ThisItem.'EmployeeID', LocationField)
Rajkumar_M 3,614 Super User 2025 Season 1 on at

Like (0)

Report

Re: LookUp records based on Text input value

Hi,

Plz try this formula

LookUp('SPList', EmployeeID = TextInput1.Text, Staff_Name & ", " & Current_Location)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.