SOLVED

Filter, multiple items

%3CLINGO-SUB%20id%3D%22lingo-sub-1587133%22%20slang%3D%22en-US%22%3EFilter%2C%20multiple%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587133%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20filter%20approx%20200%20items%20from%20a%20sharepoint%20list%20of%201400%20items%20and%20I'm%20trying%20to%20figure%20out%20the%20most%20efficient%20way%20to%20do%20this!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20field%20that%20needs%20to%20be%20filtered%20is%20the%20title%20field.%26nbsp%3B%20%26nbsp%3BEach%20of%20the%20200%20items%20have%20a%20unique%20title.%26nbsp%3B%20I%20have%20them%20in%20an%20excel%20spreadsheet%20so%20I%20can%20copy%20and%20paste%20them%20somewhere%2C%20but%20I%20can't%20seem%20to%20put%20more%20than%20one%20at%20a%20time%20in%20a%20filter%26nbsp%3B%20(I%20mean%20I%20can%20put%20more%20than%20one%20at%20a%20time%20on%20filter%20and%20then%20click%20apply%20but%20I%20can't%20paste%20200%20in%20I%20have%20to%20put%20each%20one%20in%20separately%20!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20to%20achieve%20what%20I%20want%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1587133%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1587560%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%2C%20multiple%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587560%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F758696%22%20target%3D%22_blank%22%3E%40vffdd%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20option%20I%20can%20think%20which%20is%20a%20bit%20labour%20intensive%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECreate%20a%20new%20column%20called%20%22Show%20in%20View%20X%22%20or%20similar%20and%20populate%20it.%20Filter%20on%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1588549%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%2C%20multiple%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588549%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214649%22%20target%3D%22_blank%22%3E%40Andrew%20Hodges%3C%2FA%3E%26nbsp%3B%20No%20100%25%20sure%20what%20you%20mean%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1588573%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%2C%20multiple%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588573%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F758696%22%20target%3D%22_blank%22%3E%40vffdd%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20the%20moment%20there%20is%20no%20way%20to%20identify%20the%20200%20items%20in%20your%20list%20from%20the%20other%20items.%20To%20be%20able%20to%20create%20a%20view%20on%20those%20200%20items%20we%20need%20to%20be%20able%20to%20identify%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECreate%20a%20new%20column%20in%20the%20list%20with%20a%20Choice%20field%20or%20similar%2C%20call%20it%20whatever%20you%20want.%20For%20each%20of%20those%20200%20items%20set%20that%20column%20to%20Yes%20or%20the%20values%20that%20you%20set%20in%20the%20choice%20field.%20Then%20create%20a%20new%20view%20that%20filters%20on%20that%20column%20when%20it%20is%20not%20%3D%20%22%22.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20will%20then%20create%20a%20view%20with%20only%20the%20200%20items.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi 

 

I need to filter approx 200 items from a sharepoint list of 1400 items so that I can edit them and I'm trying to figure out the most efficient way to do this!

 

The field that needs to be filtered is the title field.   Each of the 200 items have a unique title.  I have them in an excel spreadsheet so I can copy and paste them somewhere, but I can't seem to put more than one at a time in a filter  (I mean I can put more than one at a time on filter and then click apply but I can't paste 200 in I have to put each one in separately !)

 

Is there anyway to achieve what I want?

 

TIA

3 Replies
Highlighted

@vffdd 

 

One option I can think which is a bit labour intensive:-

 

Create a new column called "Show in View X" or similar and populate it. Filter on that.

 

 

 

 

 

 

Highlighted

Thanks @Andrew Hodges  No 100% sure what you mean?  

Highlighted
Best Response confirmed by vffdd (New Contributor)
Solution

@vffdd

 

At the moment there is no way to identify the 200 items in your list from the other items. To be able to create a view on those 200 items we need to be able to identify them.

 

Create a new column in the list with a Choice field or similar, call it whatever you want. For each of those 200 items set that column to Yes or the values that you set in the choice field. Then create a new view that filters on that column when it is not = "".   

 

That will then create a view with only the 200 items.