How to Bind SharePoint Lookup Column in Power Apps Dropdown?

Do you know how to bind SharePoint Lookup Column in Power Apps Dropdown? No worries!

In this Power Apps tutorial, I will explain how to bind and display a SharePoint lookup column in the Power Apps dropdown control with a simple scenario.

How to Bind SharePoint Lookup Column in Power Apps Dropdown

We will discuss adding a SharePoint lookup column in the Power Apps dropdown control here.

Example:

1. I have a SharePoint Online List, i.e., [Patient Tracker]. This list contains the below fields.

Column Name	Data Type
Patient ID	This is a default single line of text; I just renamed it as “Patient ID”
Name	A single line of text
DOB	Date and time
Disease	Lookup

2. This SharePoint lookup column [Disease] is added from another SharePoint source list named “Diseases List“. This list contains the below fields.

Column Name	Data Type
Disease	It is a default single line of text, I just renamed it as “Disease”
Doctor’s Name	A single line of text
Doctor’s Experience	Number
Doctor’s Fees	Currency

3. In Power Apps, a “New Form” is connected to the SharePoint Online list. This form contains a Dropdown field called Disease [Lookup Column], having values like Diarrhea, Influenza, Lyme disease, etc.

4. When a user selects any value from the dropdown control, the text inputs will display the disease-related doctor’s name and fees based on the selected disease.

Refer to the below screenshot:

To achieve the above example, follow the below-mentioned steps. Such as:

5. Create Power Apps Canvas app -> Connect to the SharePoint Online list [Patient Tracker]. Once the SharePoint list is added, it will appear under the Data section below.

6. Insert an Edit form [frm_NewPatient] -> set its DataSource as:

DataSurce = 'Patient Tracker'

Where,

• ‘Patient Tracker’ = SharePoint Online List

7. To display the SharePoint list fields in the form control, click the Edit fields option and add fields as needed.

8. To get the Edit Form to a New form, just set the Default mode as “New” as in the screenshot below.

9. Insert a Text input [Textinput_Doctor’sName] control inside the form and set its Default property to the code below.

Default = LookUp(
    'Patient Tracker',
    Disease.Value = drp_Disesase.Selected.Value,
    'Disease: Doctor''s Name'.Value
)

Where,

• LookUp() = This Power Apps LookUp() function is used to find a single record that matches one or more criteria
• ‘Patient Tracker’ = SharePoint Online List
• Disease.Value = SharePoint lookup field value
• drp_Disesase = Dropdown Control Name
• ‘Disease: Doctor”s Name’ = It is a SharePoint additional column from the source list

10. Then, insert another Text input control [Textinput_Doctor’sFees] -> Set its Default property as:

Default = LookUp(
    'Diseases List',
    Disease = drp_Disesase.Selected.Value,
    'Doctor''s Fees'
)

Where,

• ‘Diseases List’ = SharePoint Source List
• Disease = SharePoint Lookup column
• ‘Doctor”s Fees’ = SharePoint Currency Field

11. Save, Publish, and Preview the app. If a user selects any value from the dropdown control then, text inputs will display the values based on the dropdown selected value as shown below.

This is all about the Power Apps dropdown control lookup.

Conclusion

I hope this Microsoft Power Apps tutorial explained all the Power Apps dropdown lookup information.

Here, we learned how to add a SharePoint lookup column in the Power Apps dropdown and how to add Power Apps’ new form using the dropdown lookup.

Also, you may like some more Power Apps tutorials:

• Power Apps Dropdown Values Not Showing
• Display SharePoint Person Column in Power Apps Dropdown
• Add a Lookup Column to Power Apps Collection
• Display Column Names in Power Apps Dropdown
• Display Multiple Columns in Power Apps Dropdown
• How to Validate Power Apps Dropdown Control