i need to create a SharePoint page with 2 lists on one page, one for filtering like…
- User
i need to create a SharePoint page with 2 lists on one page, one for filtering like categories menue and when you select one of them the secoun dlist shoulb be filtered. help me achive this outcome it's very urgent
Assistant
I'll help you create a SharePoint page with two connected lists where one filters the other. Here's the quickest way to achieve this:
Method 1: Using List Web Parts with Dynamic Filtering (Easiest)
Step 1: Create Your Lists
First, create two lists:
- Categories List - Contains your filter categories
- Main List - Contains items with a lookup column to Categories
In your Main List, add a lookup column that references the Categories list:
- Go to Main List → Settings → Create column
- Choose "Lookup" type
- Select your Categories list as the source
Step 2: Add Lists to Your Page
- Edit your SharePoint page
- Add a List web part for Categories
- Add another List web part for your Main List
- Position them side by side using sections
Step 3: Configure Dynamic Filtering
- Edit the Main List web part
- Click "Edit web part" (pencil icon)
- Under "Dynamic Filtering", toggle it ON
- Save and publish the page
Now when users click items in the Categories list, the Main List will automatically filter!
Method 2: Using Filter Web Part (More Control)
- Edit your page
- Add "Filters" web part from the web part gallery
- Configure it to use your Categories list
- Add your Main List web part
- Connect them:
- Edit the Filter web part
- Choose "Connect to a web part"
- Select your Main List
- Map the filter field to the lookup column
Method 3: Quick Power Apps Solution
If the above doesn't work for your scenario:
- Create a Power Apps canvas app
- Add two galleries:
Gallery1: Categories list Gallery2: Filter(MainList, CategoryLookup.Value = Gallery1.Selected.Title) - Embed the app on your SharePoint page
Which method would work best for your specific needs? Let me know if you need detailed steps for any of these approaches or if you're encountering any issues!
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.