SharePoint Document Issues

How to Create Dependent SharePoint Dropdowns with Power Apps

Muhammad Talha Sep 29, 2026 869 views

Question details

The user needs to set up a Product Type dropdown field in a SharePoint list that changes its available choices based on the selected content type.

How to Create Dependent SharePoint Dropdowns with Power Apps

Product: SharePoint / Power Apps
Device & OS: not provided
Scenario: Customizing a SharePoint list form to include cascading or dependent dropdown choices.
Observed behavior: SharePoint list forms do not natively support dependent dropdowns based on content types, requiring Power Apps integration to achieve conditional logic.

Before you start

Ensure you have the necessary permissions to customize list forms in SharePoint and have access to Power Apps within your Microsoft 365 environment.

Solution 1Recommended

Customize the SharePoint Form with Power Apps

Use Power Apps to replace the default SharePoint form and write a conditional formula to filter dropdown choices dynamically.

Since SharePoint does not natively support dependent dropdowns across different content types out-of-the-box, Power Apps is required to handle the conditional logic. By customizing the form in Power Apps, you can use conditional functions to dictate exactly what choices appear.

Open Power Apps from SharePoint

Navigate to your SharePoint list. In the top command bar, click 'Integrate', select 'Power Apps', and then click 'Customize forms'.

Locate the Data Cards

Once the Power Apps studio opens, ensure your form includes both the Content Type data card and the Product Type data card. Select the Product Type dropdown control within its card.

Apply Conditional Logic

In the formula bar at the top, change the property dropdown to 'Items'. Enter an 'If' or 'Switch' formula to define your choices based on the Content Type control. For example: If(ContentTypeDropdown.Selected.Value = "Content Type A", ["Option 1", "Option 2"], ContentTypeDropdown.Selected.Value = "Content Type B", ["Option 3", "Option 4"]).

Publish and Test

Click 'File' > 'Save', and then select 'Publish to SharePoint'. Return to your SharePoint list, click 'New' to open the form, and test each content type to verify the dropdown updates appropriately.

Customize the SharePoint Form with Power Apps

Advanced Logic Assistance: If you are working with complex forms involving multiple content types and dependencies, consult the Microsoft Power Platform Community forums for advanced formula troubleshooting.

Free Microsoft Office alternative

Manage Your Everyday Documents Efficiently with WPS Office

While SharePoint and Power Apps handle complex list data and conditional forms, WPS Office is an excellent lightweight alternative for creating, editing, and collaborating on your daily Office documents. It is fully compatible with Microsoft formats and completely free.

1. Download and Install: Visit the official WPS Office website to download the installer and complete the quick setup process.
2. Open Your Files: Launch WPS Office and directly open your existing .docx, .xlsx, or .pptx files without any conversion.
3. Edit and Save: Edit your documents using intuitive tools and save them in standard formats for seamless sharing with Microsoft users.

Seamless compatibility with Microsoft Word, Excel, and PowerPoint formats.Lightweight installation and fast performance on Windows, Mac, Linux, and mobile.Rich set of built-in templates and advanced PDF editing tools.Free to download and easy to use with a highly familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Can I create dependent dropdowns in SharePoint without Power Apps?

Out-of-the-box SharePoint modern list forms do not natively support dependent or cascading dropdowns. You must use Power Apps or custom SharePoint Framework (SPFx) development to achieve this functionality.

How do I reference the Content Type in a Power Apps formula?

You can reference the Content Type by selecting its dropdown control and using a formula like `DataCardValue.Selected.Value` (replace 'DataCardValue' with your actual control name) to determine which options to display in your dependent field.

Why aren't my Power Apps form changes showing up in SharePoint?

After making changes in the Power Apps studio, saving the app is not enough. You must explicitly click 'Publish to SharePoint' so the customized form becomes live and visible to users accessing the list.

Document & File Issues