SharePoint Document Issues

How to Create a Cascading Activity and Task List in SharePoint

Ayan Masood Oct 1, 2026 868 views

Question details

The user wants to create related activity and task selections (cascading dropdowns) in a SharePoint Online document library.

How to Create a Cascading Activity and Task List in SharePoint

Product: SharePoint Online
Device & OS: not provided
Scenario: Organizing and filtering tasks by specific activity types in a document library (e.g., filtering cooking tasks by food type) to streamline metadata entry.
Observed behavior: Standard SharePoint lookup columns do not natively support real-time dynamic cascading dropdowns, requiring specific list relationships or custom solutions like Power Apps.

Before you start

Ensure you have Site Owner or Full Control permissions in your SharePoint Online environment to create new lists, add lookup columns, and access Power Apps for form customization.

Solution 1Recommended

Set Up Standard SharePoint Lookup Columns

Establish the foundational lists and connect them using standard lookup columns. This creates the relationship between activities and tasks.

To build a cascading structure, you first need distinct lists to store your categories and subcategories. While standard lookups will link the data, note that they do not natively provide dynamic, real-time filtering on the form itself.

Create the Activities List

Navigate to your SharePoint site, click 'New', and select 'List'. Name it 'Activities' and populate it with your high-level unique categories (e.g., Cooking, Cleaning).

Create the Tasks List

Create a second list named 'Tasks'. Add your specific tasks to the Title column.

Link Tasks to Activities

In the Tasks list, add a 'Lookup' column. Point this lookup to the 'Activities' list so that every task is properly mapped to its parent activity.

Add Lookups to Document Library

Go to your target document library. Add two Lookup columns: one pointing to the 'Activities' list and another pointing to the 'Tasks' list.

Set Up Standard SharePoint Lookup Columns

Native Limitation: Standard SharePoint lookups do not dynamically filter the Task dropdown based on the Activity selection in real-time. For dynamic filtering, you must customize the form.

Solution 2

Enable Dynamic Cascading with Power Apps

Customize your SharePoint list form using Power Apps to enable real-time filtering of tasks based on the selected activity.

Free Microsoft Office alternative

Enhance Your Document Productivity with WPS Office

While managing advanced SharePoint list forms requires specific Microsoft tools, everyday document creation doesn't have to be complicated. WPS Office provides a free, lightweight, and fully compatible alternative to Microsoft Office for all your Word, Excel, and PowerPoint needs.

1. Download and Install: Get WPS Office for free from the official website and run the lightweight installer.
2. Open Office Formats: Easily open, edit, and save .docx, .xlsx, and .pptx files seamlessly.
3. Boost Productivity: Utilize built-in templates and powerful PDF tools without expensive subscriptions.

Seamless compatibility with Microsoft Word, Excel, and PowerPoint file formats natively used in SharePoint.Lightweight application design ensuring fast loading times for heavy documents.Intuitive tabbed interface offering a familiar UI for a zero-learning-curve migration.Free built-in PDF editing, merging, and conversion tools to simplify daily workflows.

Frequently Asked Questions

Can Power Automate be used for real-time cascading dropdowns?

No, Power Automate can update field values in the background after a list item is saved, but it cannot dynamically filter dropdown selections in real-time on the user interface while the user is actively filling out the form.

What is an SPFx extension in SharePoint?

The SharePoint Framework (SPFx) allows developers to build custom client-side solutions. Advanced users and developers can use SPFx to build custom field customizers that provide real-time cascading dropdown functionality directly within standard list views.

Why don't standard SharePoint lookup columns filter automatically?

Natively, SharePoint lookup columns act as independent connections to target lists. Out-of-the-box SharePoint list forms lack the built-in conditional logic required to filter one lookup column based on the selection of another, necessitating external tools like Power Apps.

Document & File Issues