Answered

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

Like (0) Share

Report

Posted on 3 Jan 2024 17:22:03 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:

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on 04 Jan 2024 at 02:53:55

Like (0)

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

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
mmbr1606 13,535 Super User 2025 Season 2 on 03 Jan 2024 at 19:32:27

Like (0)

Report

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

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