Questions tagged [filter]

A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.

Filter by
Sorted by
Tagged with
3
votes
1answer
66 views

Link Document Library to Search Filter

I have a SharePoint Content site which also has a document library. The document library has columns that classify the document. I am trying to (on the homepage of the content site) add a Search ...
0
votes
2answers
37 views

Filter a list by User or Group column in CAML Query

Is there a way to filter a list by User or Group column? I need to get all the tasks assigned to each user in a site. I got the below code for now, but that only works if I'm trying to get my tasks. ...
0
votes
1answer
15 views

Date column grouping header links to page with date format incorrect and no results shown

I have a SharePoint Online list using the Modern view that I have grouped by a date column. When showing the list of groups everything appears fine. However, when I click the group header to view all ...
0
votes
0answers
20 views

Managed metadata filtering with hierarchy

I have a termset with hierarchy in sharepoint online in a document library. When I tag a document in the library with a child in the hierarchy and then try to filter from the tree view nothing is ...
0
votes
1answer
23 views

How do I make the “Created by [Me]” filter work after saving a list as a template

I created a list from a template where one of the views is filtered using the "[Me]" value of the "Created By field" so users can only view their entry and their entry only. Now, in the new list I ...
1
vote
1answer
35 views

Filtering Sharepoint Server 2013 list with multiple “OR” column view filters above the 5000 item threshold

I have a list that's butting up against the 5000 item threshold and I've added a couple of dummy items so I can experiment with the threshold before I cross over with real data. My list is structured ...
0
votes
1answer
12 views

Microsoft Graph Change contentType of uploaded file and filter

I have a VBA macro I'm using to interface with the graphAPI to upload a ton of files to SharePoint Online. That's working fine. The issue is changing the contentTypes after the fact. I'm using the ...
0
votes
1answer
21 views

Filter tiles view of a Document Library in modern sharepoint

I have a document library in a modern SharePoint on which I use custom formatting to customize the tiles view. The library contains leaning material for the users in different languages. The document ...
0
votes
1answer
13 views

Rest query, get values IN a collection

I would like to get the items whose field A is IN (X,Y,Z...). I've seen ways to do it with ORs (Rest API - $filter multiple values) but is there a simpler way? Something like: /_api/web/lists/...
0
votes
1answer
59 views

Filtering large list (more than 5K items) using two columns with REST API

I have a list which has more than 5K items in it and I need to filter it by using multiple columns. Below is the challenge that I am facing. Scenario 1: Below REST API fails with Microsoft.SharePoint....
1
vote
1answer
20 views

How can we sort the filter options in the information panel?

Head scratcher here. I'm wondering how/if we can change the display order of choice options in the filter info pane. Does anyone how to do this, or even better, why this appears to be an order set at ...
1
vote
1answer
27 views

Filtering a view with multiple 'and' & 'or'

I have couple of columns I want to filter on **1)**Request Type and **2)**Status Request Type has 7 possible options of which I only want to return values when: A) [Request type] = "Ing Variance" or "...
0
votes
0answers
36 views

Threshold error message upon opening filter drop-down on indexed column already filtered by *one* value

I have a list with 7000+ items on a SP 2016 environment that has the default threshold of 5000 items. I created a view filtered on 'ID is less than 2500'. This view contains 5 columns (all indexed), ...
2
votes
1answer
35 views

Exclude items from view using a filter (“does not contain”)

I know there are several other threads on this topic, but haven't seen anything that would assist with my issue. Unfortunately I cannot rely on my users to regularly update meta-data (even something ...
1
vote
1answer
23 views

list view Filter between dates

I have a list where I have 2 date time columns names as start and End date. I'm looking to create a list where items can be filtered if they lies within these date ranges of start and end date. ...
0
votes
1answer
24 views

Filter gallery by current user in Powerapps

I would like to Filter the gallery by the current user in Powerapps. It tried using Filter('Declaraties';Naam.Email=User().Email) in the Items field in the gallery. But did not work. Than I ...
0
votes
0answers
8 views

Advanced Boolean to Filter views

I am trying to filter an approval database. There is one tag that switches from to A1 to A2 to A3 to A4, to again, based on current approval level. There is also 4 userID tags - Approval 1, ...
1
vote
1answer
25 views

Difference between ME & Current User Filter

I was creating a sharepoint page where I wanted to input minutes of one-one with my directs - my requirement was such that if I enter the minutes of meeting - the person who's alias/email address that ...
0
votes
1answer
26 views

How to filter by a date range in SharePoint online

I am migrating a solution from SP2013 to SP Online. I have a library of documents with start and end date for when they were applicable. I need a way for the user to enter a date range, and then ...
0
votes
2answers
39 views

classic view filter on managed metadata

I need to keep one library in classic view and would like to occasionally create a view with a filter on a managed metadata column. Writing the item in the filter does not produce the desired result ...
0
votes
0answers
31 views

Filter SharePoint Page based on a User's Logged with javascript [duplicate]

In my company's Sharepoint website, each user account includes Display Name (LastName, FirstName and Initial). I need a selective View based on the User's name. I'm not using People Picker, so I can'...
0
votes
0answers
25 views

Filter Sharepoint List in PowerApps that has lookup table column

Maybe I am missing something easy but I have a SharePoint List that has two columns: col1: Category (Single Line Text) col2: Items (Lookup populated from another SP List) Each category has several ...
1
vote
0answers
29 views

Sharepoint API filter result

When using following request: [...]/_api/web/Lists/getByTitle('SVC')/items?$select=FileRef,File_x0020_Type&$top=5000 I get the top 5000 items in the result. However when adding following filter ...
0
votes
1answer
71 views

Document Library - Lookup Column Filter

I have metadata tags utilized in my document library - several of them are lookup columns. One of these lookup columns is to a list named "Projects". This list also has several other columns - "...
0
votes
1answer
54 views

filtering by file type is not working in share point 2016 on-premises rest API

I am trying to filter the files in a document library folder by file type and using the below API call for it. But the filtering doesn't work and it returns files with all the file types regardless of ...
0
votes
0answers
157 views

Filtering documents on SharePoint Online Library folder in a different site

I have a mammoth document library with folders on a site. I'm trying to show specific files in these folders so this is how the original Library View displays: I've migrated this over from a ...
1
vote
1answer
161 views

SharePoint Online View Filter Help Needed - Multiple And/Or Conditions

I hope someone can provide some insight as I've been struggling with a View. No previous question/answer on StackExchange seems to quite get at what I need. I've combed the web and reviewed the blog ...
0
votes
1answer
57 views

SharePoint List Filter - Apply Filters button

In SharePoint Online, I have a web part page in which I have different SharePoint List Filters allowing to filter List Web Parts. I am facing issues regarding the Apply Filters button, especially with ...
2
votes
1answer
345 views

Multiple $filter in OData query

Here is my OData query: https://XXX.sharepoint.com/sites/pwa/_api/ProjectServer/Projects?$filter=Id eq guid'xxxx'&$select=Id,Name,StartDate&$expand=Tasks&$select=Tasks/Id,Tasks/Name I ...
0
votes
1answer
52 views

Metadata Navigation and column filtering

We have a document library with metadata navigation enabled. Some columns in the library are eligible column types for metadata navigation and others aren't. The column filtering via the column ...
0
votes
1answer
36 views

News feed SP Online

Is it possible to grabs news from different site? If I select news source: this site, everything is working fine and I have all the needed filters but as soon as I change to different news source: ...
0
votes
1answer
53 views

SPO: Show Autocomplete Filter WP results as Title field values but filtering from another field's value [closed]

I am using an autocomplete filter customized in the HTML Form WP. When a user begins typing the name of a Company (i.e. Title field from the Companies list), all matching results autopopulate as the ...
1
vote
1answer
35 views

Filter pane bug in modern experience when using a calcuated column

I've run into an odd bug when using the filter pane to filter a calculated column in SharePoint 2019 on premise. When using the see all option, the "8_" text is added to the filter value and the ...
-1
votes
2answers
841 views

Filter choice column with distinct value in powerapps

I want to get distinct value in PowerApps where Active (choice column)="Yes", trying below but I am not getting correct value it returns false value: Distinct(Filter(Splist, Active =true),'...
0
votes
1answer
29 views

Remove pin icon from filters pane

Is it possible to hide or remove the pin icon from filters pane which would prevent users to click on it or remove the pinned column from the filter pane by any chance? Such as making it default ...
0
votes
1answer
20 views

In Power App How to filter created by Me and Status

I had written below formula to get item created by me but how to add one more filter of status = Draft Filter(test,Lower('Created By'.Email)=Lower(CurrentUser))
0
votes
2answers
24 views

Filtering the calendar items base on checkbox

I have a SharePoint calendar for activities which users choose in a column (Choice) what platform is that activity IE. Windows, Unix, Network and so on. Is there a way to filter this using a check ...
0
votes
2answers
27 views

Sharepoint limit lookup dropdown entries by “pre-filter”

Following scenario: List A contains several thousand items, List B has a lookup-column to List A. When a user is creating item in List B he has to select the List A item via the mentioned lookup-...
0
votes
1answer
18 views

Filter view for column for each indivual in list

How do I filter the view for each user in a list group? So that only the individual user can view there inputted column like SS?
1
vote
1answer
27 views

Force SharePoint list filters to display alphabetically?

Does anyone know of a way for force the top five filters for each column of a list (before you click See All) to display alphabetically?
1
vote
1answer
110 views

Is there a way to have a single Metadata Navigation which work on multiple documents libraries which share the same site columns

I am working on an online modern team site collection. and we have 5 documents libraries, where these document libraries share the same 3 managed metadata site columns. Now for each document library, ...
1
vote
3answers
512 views

Dynamically filter documents inside a document library using their folders and sub-folders

I am trying to find the best approach to follow, to implement this business need:- 1- We need to create a document library inside our sharepoint online site collections. 2- the ability to search and ...
0
votes
1answer
24 views

Saving views after applying filter to column

I am attempting to create filtered views to share with pertinent staff. I imported an Excel data sheet to create my list. And, up until now I have been able to achieve my desired end. Until ...
0
votes
3answers
35 views

Search Result by filter does not find an existing and crawled document

This is related to SP 2013 On-Premises. We have a custom Search Page and we use Keyword-Query to filter the Result. The related document which cannot be found by that page has at least two meta data ...
0
votes
1answer
16 views

Save filtered view not working

I created an Item list with column headers imported from a table created in Excel. I notice that when i try to sort (Ascend/Descend, etc) the column says, "This column type cannot be sorted." Why is ...
0
votes
1answer
52 views

How to filter a list using Button in Sharepoint Designer 2013

I have added a column as category in Announcement list and I want to filter the announcement based on category. I have created no of buttons for the category. I created parameter as Param1 to filter. ...
0
votes
2answers
255 views

Filter a Library and multiple Lists on a Page based on the same column (date)

In classic mode a List Filter Web Part is available but what to do in a modern site. Is it still possible to use a classic page in a modern site with the List Filter Web Part? If yes how if no, is ...
0
votes
1answer
152 views

'Select All' option in SharePoint 2013 list column filters

I have SharePoint 2013 list. Need to get 'Select All' option in list filter (on the columns' filters). Currently SP only has 'Clear Filters'. The feauture I need is the same as in Excel Autofilter: ...
0
votes
0answers
25 views

Trying to filter a list based on right now

I'm trying to filter a simple Employee Sign Out list in SharePoint 2013. I have a column for departing (date/time) and returning (date/time) and want to filter so that only the people that have ...
0
votes
2answers
348 views

In SPO list why would FilterFieldX/FilterValueX work while FilterName/FilterMultiValue is ignored?

I am using a custom list with standard OOB AllItems.aspx view using the modern experience. (NOT a web-part, NOT the classic experience) When I filter using .../AllItems.aspx?FilterField1=...

1
2 3 4 5
16