Autofill form through sharepoint data

(1) Share

Report

Posted on by minibee11

Hi All,

I currently have a sharepoint list that includes "employee name" as a single line of text and "gender" as a choice.

When filling out a form via PowerApp I want to be able to type in the employee's name and if it matches the SharePoint list it will autofill the "gender" box.

How would i go about making this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!
Hey @minibee11 ,

You can do it by putting in default of your dropdown
If(CountRows(LookUp(SharepointList, Name=TextBox.Text))=0,Blank(),LookUp(SharepointList, Name=TextBox.Text,Gender))

Let me know if it helped you

Was this reply helpful? Yes No
minibee11 23 on at

Like (1)

Report
Copy link

Link copied!

Hi Thanks for your reply.

This doesn't seem to work.

I forgot to mention in my original post that the via app form is based off a separate SharePoint list.

E.g. I have a sharepoint list 1 named "staff register" which has employees names and their gender.

I have created a sharepoint list 2 where I can input their leave applications. When inputting their leave applications i want to be able to type their name and their gender is autofilled based of sharepoint list 1

Was this reply helpful? Yes No
Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hey @minibee11 ,

Did the solution I provided return any error?

Was this reply helpful? Yes No
minibee11 23 on at

Like (1)

Report
Copy link

Link copied!

It says "Delegation warning. The highlighted part of this formula might not work correctly with column 'Full Name' on large data sets."

Was this reply helpful? Yes No
Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

That won't be a problem.

Just a quick explanation: The delegation warning says it can't process more then 500 records. since with the lookup function the app only wants 1 record this will never cause any problem for you. If this should be the reason, why the code doesn't work you can simply ignore it.

Was this reply helpful? Yes No