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
1 answer
879 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 ...
1 vote
1 answer
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 ...
1 vote
1 answer
1k views

Have a webpart in a Page layout get filter value from column value

I'm new with SharePoint but I feel like I'm catching on pretty well. I'm creating a new page layout and I plan to put a list webpart in the right column. The list webpart will be filtered using the ...
0 votes
1 answer
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
1 answer
1k views

Empty Filter Option display even no empty value exist

Empty Filter Option is showing in Person or Group column even when there is no empty value existing in the column. Is it normal behaviour?
0 votes
1 answer
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 ...
0 votes
1 answer
1k views

SharePoint Online 'Filter By' not showing all available options

I have created a custom list which contains around 32,000 items. There is a 4 part key which looks something like 'T1-0000-X-XX'. Each part has a meaning. In order for users to be able to filter by ...
1 vote
2 answers
12 views

filter by color after adding conditional formatting

If you create conditional formatting on a column in SharePoint list that is dynamic, say for example all dates before today are red, today is green and dates after today are amber, is there a way to ...
5 votes
2 answers
3k 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
1 answer
958 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 ...
1 vote
1 answer
1k 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
2 answers
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 ...
2 votes
1 answer
3k 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
1 answer
26 views

SharePoint REST API Query is Not Valid

I am trying to filter a list by multiple different columns, and then when I add the array filter towards the end, it tells me that the query is not valid. I have tried two different methods which are ...
0 votes
2 answers
7k 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' ...
0 votes
1 answer
3k 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 (...
5 votes
3 answers
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 ...
3 votes
2 answers
2k 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 (?...
4 votes
1 answer
5k 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
1 answer
1k views

Querying a sharepoint list with more than 5000 records returned while supporting sorting and filtering

We are facing some problems dealing with large list on SharePoint online via API, we tried below methods but no luck, please advise if there is a proper way to handle such cases. Requirements ...
0 votes
3 answers
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
2 answers
2k 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
2 answers
2k views

SharePoint CSOM list group by and filter

I have a list with columns "fruit" and "ripeness". Using csom, how can I return "Banana" where Yellow count >= 3? ClientContext ctx = new ClientContext("https://sharepoint.blah.com"); List list = ctx....
0 votes
1 answer
890 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, ...
3 votes
3 answers
5k views

Workflow Task List - View Filtered By Assigned To = [Me] not working for SPGroups

I want to filter my Workflow 2013 Tasks list only to display the tasks assigned to the current user. Hence I went ahead and set a filter 'Assigned To' is equal to [Me] in the view. However, I am not ...
0 votes
4 answers
1k 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 ...
2 votes
3 answers
2k 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
2 answers
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 ...
0 votes
0 answers
23 views

display filter pane on list view or HCWP on sharepoint online

im using sharepoint online. My goal is to always display filter pane so that customer can use it. Is there a way to expand the filter pane by default to a SharePoint document library? In the same way ...
3 votes
1 answer
1k 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
1 answer
1k views

Tagging news and filter them afterwards

Currently I´m trying to figure out whether is it possible to tag my news with a # or something else and then to create a news feed where every user can filter individualy by them self the news ...
1 vote
1 answer
141 views

SharePoint List Filter Query By UTC Date Not Valid

I am having an error with my filter with other people located in separate time zones. It was recommended to me to switch to filtering with a UTC date instead of an ISO date and that should fix the ...
2 votes
1 answer
2k 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 ...
4 votes
0 answers
768 views

Query string filter on an InfoPath lookup field

I am trying to use a query string filter to filter data on an InfoPath form using this guide. The column that I'm trying to filter is a lookup field and it is not available in the list of Consumer ...
0 votes
1 answer
1k 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 ...
0 votes
1 answer
1k 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 ...
2 votes
1 answer
1k 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 ...
0 votes
1 answer
1k 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 ...
0 votes
1 answer
25 views

Dynamic Filtering on Non-Default View of Document Library

Is it possible to filter a Document Library by a List without going back to the default view prior filtering? I have 2 views, one for Current Year documents and the other containing All documents. ...
0 votes
1 answer
21 views

pnp search filter and search result v4

Has anyone used pnp search filter and search result. I have a choice field "LearningStack" in 7 different list and 6 different libraries. The idea is to have a page where I can display "...
0 votes
0 answers
9 views

create a new visualization calendar with filter by membership

A need show events on calendar using filter membership using camlQuery. Can i replace the ListViewXml on the aspx? i use javascript on the sharepoint designer.
0 votes
1 answer
419 views

Filter or populate choice/lookup column based on another list without Power Apps? Or format column based on another list?

I'm working on a project where I have a main list called "Requests". It includes a "Course" column (pre-populated) and a "School" single-value choice column. I want to ...
0 votes
0 answers
29 views

ODATA Filter for lists/libraries using TemplateFeatureId guid property

24Hrs into learning about OData queries for a SP project that was dumped on me. I can get the data i need from _api/web/lists?$select=Title,TemplateFeatureId,Author&$expand=Author But I tried to ...
0 votes
0 answers
179 views

Add custom column to PNP Search filter web part

I am working on PNP Modern Search v4 web part inside our SharePoint Tenant from this URL - https://github.com/microsoft-search/pnp-modern-search/releases/tag/4.4.1. I have tried to use search box, ...
0 votes
0 answers
50 views

SharePoint List Filter - and/or condition? Search box?

the users wish for and/or filter conditions to apply on a SharePoint list. Example Filter-search 1 (multiple columns connected with 'or': Either column "Active" can be set on "yes" ...
0 votes
0 answers
7 views

New's post calculation

There are hundreds of different News Post pages in our Sharepoint site and we need to calculate how many are there. Also they have different target audiences assigned and would be nice to also see/...
1 vote
3 answers
21k views

SharePoint Online - List Filtering by Date Range

I have a SP List with multiple columns, two of them are Start Date and End Date. I added this list view web part to a page and added two date filter columns connected to Start Date and End Date. This ...
0 votes
0 answers
22 views

Issues with filtered list in SharePoint?

The full question is more along the lines of preventing someone from adding a filter to a list since that seems to "hold" the filter within the the list on SharePoint for everyone. Or is ...
0 votes
2 answers
14 views

Filter by group but showing percentage instead of number

Is it possible to filter a list by group and showing percentage instead of numbers? I know we can group by a list by some column but it shows no. of records. Is it possible to show percentage? I am ...
0 votes
1 answer
236 views

SharePoint REST API List View Threshold

I have a SharePoint List with over 5000 records created by me. The below query when using ID in filter works. But when I Filter With CreatedBy me it gives me List View Threshold Error. Error: _api/...

1
2 3 4 5
17