Forum Discussion
How to create a List from nested files in a Document Library?
I'd like to have an SPO List of any items (PDF, XLS) in a Document Library that are tagged with specific properties. I have a library of nested folders where I've set a Choice column to Active if a file is current.
How can I filter by Active within nested folders? I assume I would have to create a separate list to gather the column status of all the nested files.
I've tried to do this using Lookup but the column I want to filter by isn't present.
So, to illustrate in the following example, I want to create a List of any items in the Document Library that are In Stock.
Doc Library
Grocery Store
PRODUCE
| Item | Status |
| Apples | In Stock |
| Oranges | Not In Stock |
| Pears | Not In Stock |
MEAT
| Item | Status |
| Chicken | Not In Stock |
| Beef | In Stock |
| Pork | In Stock |
SPO List
| In Stock Items |
| Apples |
| Beef |
| Pork |
1 Reply
- I ended up creating a new Page and used the Highlighted Content element to filter by a column in the Document Library. I suppose this will do but I still feel like there's a better way. For instance, this element doesn't show all the columns in the Doc Library.
