Forum Discussion

vffdd's avatar
vffdd
Copper Contributor
Aug 13, 2020
Solved

Filter, multiple items

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 f...
  • Andrew Hodges's avatar
    Andrew Hodges
    Aug 14, 2020

    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.

Resources