web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Autopopulate fields in...

Power Apps

Answered

Autopopulate fields in an sharepoint list based on values from another field

(0) Share

Report

Report

Posted on by Francosg

Hi everyone!,

I'm currently working on setting up a SharePoint list to facilitate the request of medical exams from one unit to another. Specifically, I want to include a dropdown list that displays the names of patients, and upon selecting a patient's name, the associated address, phone number, and email fields should auto-fill. I'm relatively new to PowerApps, and any guidance on achieving this would be greatly appreciated. It's worth noting that the database consists of approximately 100 patients.

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hello @Francosg

this is quite simple to achieve:

watch this video and it will work:

How to create Cascading (Dependent) Dropdowns in Power Apps - YouTube

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Francosg,

Cascading dropdowns is not a complex issue only if you have set all the column type as single-line-of-text.😂

For Text columns, cascading dropdown is easy, just filter based on the previous dropdown selected.

1). For PatientName dropdown, set the Items property as:

List_Name.PatientName

2). For dropdowns related to address, phone number and so on, just set the Items property and Default property as the same formula:

LookUp(list_name,PatientName=Dropdown_Patient.Selected.PatientName,Address)
LookUp(list_name,PatientName=Dropdown_Patient.Selected.PatientName).Address

Was this reply helpful? Yes No

Join the conversation