Feb 03 2022 06:27 AM - edited Feb 03 2022 06:28 AM
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 |
Feb 04 2022 06:52 AM