web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / LookUp records based o...
Power Apps
Answered

LookUp records based on Text input value

(0) ShareShare
ReportReport
Posted on by 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

 

 

Categories:
I have the same question (0)
  • Rajkumar_M Profile Picture
    3,743 Moderator on at

    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.

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    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)

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 84

#2
WarrenBelz Profile Picture

WarrenBelz 79 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 40 Super User 2026 Season 1

Last 30 days Overall leaderboard