web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Autofill boxes

Power Apps

Answered

Autofill boxes

(0) Share

Report

Report

Posted on by mao247

I am trying to create a data entry app. where part of it is entering the employee details. I want it to work in a way that if I put the employee number, the name, manager and cluster will auto-populate based on the sharepoint list I have connected on the app. How can I do this? Also, how can I make so that the name, manager and cluster cannot be edited as well and the only entry field will be the employee number? Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
HI @mao247 , The DisplayMode of control for name, manager and cluster can be

DisplayMode.Disabled

The default property of Name control:

LookUp(SPLISTNAME, employeenumbercolumnName = employeenumbercontrolname.Text).Name

The default property of manager control:

LookUp(SPLISTNAME, employeenumbercolumnName = employeenumbercontrolname.Text).manager

The default property of cluster control:

LookUp(SPLISTNAME, employeenumbercolumnName = employeenumbercontrolname.Text).cluster

If this does not resolve then please elaborate the column type and name.
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
mao247 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much. This worked!

Was this reply helpful? Yes No

Join the conversation