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
0
votes
1answer
58 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....
0
votes
1answer
1k views

How to Connect a list from another Sharepoint Web Application

How Could I connect a SharePoint another list which is situated in another web application? A mast get another list from another web application, and give a filter to show only this elements, which ...
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 ...
0
votes
1answer
1k views

Filter SharePoint lists by a Person or People Picker

How can I create a web part page, where the search web part is a "peoplepicker" like control which then filters 3 SharePoint lists below it on the "CreatedBy" column. Scenario: Find all entries made ...
1
vote
1answer
32 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
9 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 ...
3
votes
2answers
1k views

Why doesn't FilterOp work with Inplview?

I am trying to pass a URL into a SharePoint listview with parameters for filtering. The FilterOp paramter doesn't work with inplview for me. If I pass the parameters in normal query string format (?...
0
votes
2answers
3k views

SharePoint List View Filter by [Me]

Wondering if someone can point me in the right direction please. I have a created a custom list view with a filter on a field called 'User' this is a 'Person or group' field setup to show the 'Name' ...
5
votes
3answers
2k views

Remember filter value using jquery and cookies

I am looking for a solution for the following problem: I have a large list that is related to a second list. The two list web parts are on one page, when you select an item in the first list, the ...
5
votes
2answers
2k views

How to create SPQuery by filtering date interval

I have a custom aspx form where I retrieve list items by filtering two values EventDate and EndDate. I have a realization but it returns nothing: DateTime eventDate = Convert.ToDateTime(properties....
0
votes
1answer
12 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/...
1
vote
2answers
1k views

Cannot filter in quick edit in Sharepoint 2013

I have a list which have a lot of data. I can filter list in standard view but when I use quick edit view, just some column can filtered. It's not display "show filter choice" when the column have too ...
0
votes
0answers
33 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), ...
1
vote
1answer
17 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
26 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 "...
4
votes
1answer
4k views

Filter list in a WebPart by Contains not Equals (adding a wildcard)

If I need to "search" list data using a wildcard, I have to modify the XSL code. A step-by-step instruction for doing it in SP2007 has been provided at Can I Filter a List/Data View using Contains ...
0
votes
1answer
2k views

Exclude items from a view using filter

I want to create a view which rules out several items in a list, i.e., if there are options A,B,C,D,E in column X, I'd like it to contain all list items except those that contain options D or E (...
2
votes
1answer
19 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 ...
3
votes
3answers
6k views

SharePoint views - Filtering by date and time

We have a custom web-part that uses a View to filter Procurements (Tenders) by date. We are trying to filter the view using the [Today] function but from what I gathered it only uses the Date and ...
0
votes
3answers
4k views

Filter a List View based on data in another list

I'm looking for guidance on how to approach a problem. I have two lists, Goals and Tasks. Goals is a simple custom list with Name and People-Involved. Tasks is a task list with a lookup field to ...
1
vote
1answer
715 views

Filter by “Created by” is not working

I have created a list view that filters documents on "Created by" column. Users within my organization are able to see the information correctly. However, users who are logging via external account(...
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
17 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 ...
1
vote
3answers
451 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
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
2answers
3k views

SharePoint Calendar view with Query String Filter

I need to create two custom columns inside SharePoint Calendar List and I need to apply Filtering to calendar view with regards to custom columns for the users. I need to apply the same using default ...
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 ...
1
vote
1answer
1k views

SharePoint 2013 REST API Filter hidden Fields

I have a little Problem. I'm trying to do the following. There is a Field on SharePoint List items called HasUniqueRoleAssignments that is hidden on a standard REST call. If I put it in the select ...
1
vote
4answers
4k views

Need to filter a list with 10+ criteria

Need to create a list filter with over 10 criteria. Research tells me that it can be done with a Data View web part but I have not found any instructions on how this is done.
1
vote
2answers
1k views

Update InfoPath form field value in SharePoint Online document library?

I have saved InfoPath Form in a Form Library & also saved field values in separate columns, now I have retrieved one record in InfoPath Form 2013. I'm trying to update Status columns value from ...
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'...
1
vote
1answer
703 views

Manipulate Filters in Javascript

Is there any code in JavaScript which allow to manipulate filter to a library webpart?
0
votes
1answer
24 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
31 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
1answer
819 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
1
vote
1answer
2k views

how to filter a list by current user DISPLAY NAME

Background infomation In my company's Sharepoint website, each user account included two account infomations: user ID (DomainName\StaffID) and Display Name (DepartmentID/StaffName). Now I need to ...
0
votes
0answers
23 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
28 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 ...
3
votes
1answer
955 views

Filter sharepoint list using multi line text field

I'm trying to filter a sharepoint list using ajax api. So one of the filtered field is Multi line text field (FieldType.Note) , after performing request it throws an error telleing that the field ...
0
votes
1answer
945 views

Filtering list view based on querystring using jQuery?

Using Sharepoint 2010 Content Editor Web Parts (some links dynamically created) List View Web Part Ability to add additional software or packages to the system extremely limited (so would prefer ...
0
votes
1answer
779 views

How to create a html form webpart filter for 2 list columns

I have a html form webpart (in the form of textbox input). I would like to filter 2 list columns using the same webpart: So instead of the usual filtering for 1 list column, this webpart will be used ...
1
vote
1answer
644 views

Datetime format when using $filter in ListData.svc

I'm using ListData.svc to retrieve items from a SharePoint 2013 calendar list. I have two jquery ui datepickers to select the date range. Values are read with the following: var s = moment(jQuery('....
1
vote
1answer
954 views

Passing employee id from AD to a SharePoint list

I have a property named EmployeeId in AD. UPS is configured and is getting all users EmployeeID from AD. I have made an external list. I want to pass logged in user's EmployeeID to that list so it ...
1
vote
5answers
3k views

Disable column header filter and sorting

I am using SP2013 on-premise. On a list view all the columns' header come with a filter+sorter function. It is not useful on some columns (e.g. photo, which show a picture and no point to sort, and ...
0
votes
1answer
2k views

Document Library - Show Only document inside of folder

I have gotten a big document library. I must show only documents which are in specific folder. How could I show these documents? I have got many folders, but I want to show only the content of one of ...
0
votes
1answer
57 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
971 views

Sharepoint 2013 - Search files into File Share (content source) with filtering by folders

I crawled content that is on stored on file server (File Share - content source in SharePoint Server) and i get the results in SharePoint search. Everything is fine but i need to have some kind of ...
1
vote
1answer
1k views

Issues with SPFilterDropdown in SPD2013

To start things, I have little knowledge beyond the basic concepts of SPD and being a newbie... What I want to accomplish is to only have certain values from another list show up in which their ...
0
votes
3answers
917 views

Document Library Not Filtering Columns

There is a document library which has over 5000 items, it has passed its item view threshold. The view was reduced to show items that met certain requirements. This view now shows less than 1000 ...

1
2 3 4 5
16