Forum Discussion
Solved
Team Site Choice Filter
I'm new to SharePoint, am an Access user for years, and want to filter a site which has Discussions, and Documents based on a single list (such as a Choice Filter). This one list should be offered to...
So basically you have a list category to create. Put your categories in it.
Add a column to discussion board of lookup type and point to the category list. This will provide a drop down of categories and pull it from that list you create.
On the page, add the category list as a web part. Edit it down to be just title etc. then setup connected webparts. The UI for filtering is a little wierd this way because you have to use the icon as far as I know but it's the only way I know how to do this, outside of doing powerapps with modern UI in SharePoint online :p.
Instead of using Filter web part, use a custom list called category, then you have to create a column in your discussion board to use that column as a "lookup column" data type. Then add that category list on the page and provide the filter to the discussion board list, that should technically filter and have a single point for maintaining that list.
So basically you have a list category to create. Put your categories in it.
Add a column to discussion board of lookup type and point to the category list. This will provide a drop down of categories and pull it from that list you create.
On the page, add the category list as a web part. Edit it down to be just title etc. then setup connected webparts. The UI for filtering is a little wierd this way because you have to use the icon as far as I know but it's the only way I know how to do this, outside of doing powerapps with modern UI in SharePoint online :p.
Add a column to discussion board of lookup type and point to the category list. This will provide a drop down of categories and pull it from that list you create.
On the page, add the category list as a web part. Edit it down to be just title etc. then setup connected webparts. The UI for filtering is a little wierd this way because you have to use the icon as far as I know but it's the only way I know how to do this, outside of doing powerapps with modern UI in SharePoint online :p.
Thanks for the reply and sorry for taking so long. The light is SLOWLY going on. I am an Access/VBA guy, and its very different.
Another question (don't know if I should post again)
The below (at 24:33) basically states that central lists are stored at the root level. How do I see them in Access? or SP? I don't have root permission. I want to do proper Governance (diligence ... smarts.... etc) and use existing but don't know how to find them. I should also preface that I work for the government (Michigan) and are VERY behind. I have Designer but don't know how to easily see existing lists ... and preferably, business descriptions
Thanks for your help!!
