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
60 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
312 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
180 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
362 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=...
0
votes
0answers
41 views

Filtering a list by input date between 'start date

I have a MeetingTopic list (things to discuss at a meeting), with a StartDate field and an EndDate field. I am trying to create a page that takes a date parameter (MeetingDate) and presents all topics ...
0
votes
2answers
509 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
1answer
35 views

How can I filter a library using multiple columns?

I'm trying to filter a library using multiple columns, by project number, type, and an additional category, however when I use multiple filters, the filters applied last don't apply properly. For ...
1
vote
0answers
34 views

Filter for noobs [closed]

I'm trying to learn about filters in SharePoint. A colleague tried to setup alerts for his tasks. He made a view filtering all of his tasks out of his departments tasks and then created an alarm about ...
1
vote
1answer
33 views

current user filter web part in SharePoint

I would like the user to only see their tasks that are meant to their department for example (IT Users when they are logged into to Tasks list ) they should only see Tasks for IT department only. I ...
0
votes
1answer
49 views

How To Apply filter to List View Web Part based on content of Data View field

I am building a project management tool. the top of each project page shows a List View webpart which displays information about the project's current status. A second List View displays a Task List ...
0
votes
1answer
43 views

Use image icons to filter library view web part

We are on SharePoint O365. I have created a wiki page on a classic page setup. On that page I have placed several .gif images and the library view web part. What I'd like to do is filter the ...
2
votes
2answers
71 views

List “filters pane” works fine for text STARTING WITH. But how to filter on text that CONTAIN words?

In Sharepoint 365 I created a list and by default you can filter with the filter pane. For instant I have a company colum and a company name in ABC International. I want to filter for all compies with ...
1
vote
1answer
62 views

document-set filters?

I have a library with multiple document sets, each of which has custom metadata. I want to create a filter for use within doc-set A that filters on A's custom metadata, and a filter for use within doc-...
0
votes
2answers
53 views

Custom List Header Column Sort/Filter

I'm trying to re-format the sort/filter drop down box on the column header of a custom list (font-family, font-size, background etc). This appears to be possible by using the following rule in a ...
1
vote
2answers
23 views

How to filter out this?

Im a beginner.. I have searched now for some hours for a solution without success. I have following list with 3 columns and 3 items Date Id Place 190725 1 A 190724 1 B ...
0
votes
0answers
80 views

Odd Behavior for Rest API lookup Column filtering

I've recently been working on a project requiring Rest Queries against a large SharePoint list (5000+ items) and ran into an interaction I can't quite find an explanation for. The scenario is that I ...
1
vote
1answer
110 views

Disable Filter on Individual Column Headers of Custom List

I'm working with SharePoint 2013 and my Company don't allow the use of SharePoint Designer. I have created a custom list and am looking to disable the column header filter from a number of the ...
2
votes
1answer
1k views

Is it possible to filter search results when searching in a modern document library?

I noticed that when I search for something in a document library and click "See All" for all the search results, the filter icon in the top right corner disappears and I am unable to use any of the ...
0
votes
1answer
119 views

Possible to get tasks based on a local custom field value using Project Server JSOM?

I have been working on a web part that lives on a SharePoint site in a Project Web App instance, and interacts with Project Server using the Project REST API. I need to be able to get tasks based on ...
0
votes
1answer
311 views

Customize Filter Icon and filter pane in a Modern Experience document library

I am learning that the modern experience of SharePoint Online does not leave much room for customization. I had a request from the line of business to make the filter ICON considerably more visible ...
0
votes
1answer
24 views

Filter Event Calendar by Column

I have a SharePoint calendar that I have added a drop down column called SalesAgent, which contain Sales Agent names that is selected when event created. Each agent has numerous events on a calendar. ...
0
votes
1answer
18 views

Creat a view with Sharepoint List: Sort by column then filter everything but the most recent

I have a list coming in from forms with a serial number and a date: [Serial Number] [date] a-6/10/19 a-6/12/12 a-2/4/14 b-3/2/15 b-4/1/12 I want to create a view where I only display the most recent ...
1
vote
0answers
21 views

Page filter doesn't work in edit mode

In my library I have the document id service turned on. So each new document gets an unchanging id. That is working. I then have some other documents which are related to a given page. I've created a ...
0
votes
2answers
150 views

Exporting a list to csv from a custom page

I have a custom page created to allow users to be able to select their own parameters to filter items in a list using web-parts (with help from SharePoint designer 2013). This filtered list needs to ...
0
votes
2answers
33 views

Turn Title bar filters on at all time

We have a number of custom lists, and on some of the larger ones the sidebar popping up is undesirable. We added Filter=1 to the links to the lists which turns on the filters at the top, which is ...
0
votes
1answer
52 views

Please tell, can we filter data on SharePoint Hyperlink Description but not URL using sharepoint query [closed]

Please tell is there any way or workaround we can filter on hyperlink "Description" using sharepoint query. I know we can filter listview rendering using JSlink and hide rows but problem is when user ...
2
votes
1answer
51 views

Sharepoint large list filtering

Currently in Sharepiont 2010. I have a list that just went over 5000 items. I have columns indexed and all views are filtered with these indexed columns. One of the columns is a "Date and Time" type ...
0
votes
1answer
23 views

View showing new list items

Is there a view (or a way) that show new items only to a list? My goal is to have a "New Items" list, or view that will be updated automatically shows any thing within the past 24 hours. Filtered ...
2
votes
1answer
399 views

Is there a limit of conditions count for oData query using $filter?

I have a long $filter query like ID eq 1 or ID eq 2 or ID eq 33 or ID eq ... and it works like a charm when we have up to 159 conditions joined by or. But, when I add one more condition (started from ...
1
vote
1answer
19 views

Items that SHOULD be showing in a view, aren't

So, I have a large list, with ~10,000 items. I have created several views that filter via indexed columns that show below the threshold amount. But I just modified one of the views, (changed the ...
1
vote
1answer
63 views

Unable to filter multiple columns of “Person or Group”

I am trying to create a view for our agents so that they can see if they created an item or if they have been added to an item. To do this I thought it would be as simple as: Agent Name (Indexed) is ...
0
votes
1answer
503 views

Filter list view by current year on SharePoint Online

I have a year column in one of the SharePoint list. I want to create a view to filter the items by current year. How to do this? I have tried a lot but it doesnt work. Please help
0
votes
0answers
98 views

Filtering view and workflows for lookup columns

I have 2 lists with the following columns: List A - "Status" (choice column)/"Name"(Single line)/"ReqNr(Number)" List B - "StatusNameReq"(Lookupcolumn based on the columns in List A) Now, I want to ...
0
votes
1answer
218 views

CAML filtered list views - filter more than one nested level?

do you know if it's possible with CAML to write a SharePoint list view filter query to retrieve a user that is a member of a group which in turn is a member of another group i.e. nested groups? I've ...
1
vote
1answer
158 views

How can I filter the Highlighted content web part to only show things that the user flagged as “Save for later”?

Seems like it should be pretty straight forward however I am not seeing it. There is already a baked in feature where people can tag a page or document "Save for later" at the bottom of most pages ...
0
votes
1answer
192 views

Search SiteGroups API not working when case sensitive

I'm using the API to search for sitegroups as below: "/_api/web/SiteGroups?$orderby 'Title'&$select=Id,Title,LoginName" + skiptop + "&$filter=startswith(Title,'" + value + "')" However, I ...
1
vote
0answers
146 views

How to filter on a Edm.Double type using rest api?

I'm currently working on a small project where I need to query the Access Request list of a site, while this list is sort of hidden the REST api works perfectly (Mind you the title might be different ...
2
votes
1answer
113 views

SP2013 Custom List - Case Sensitive Filter with JQuery

Good Morning Friends; I am using a JQuery script to act as a filter on a custom list. The text in my custom list is all Uppercase. Currently the filter is case sensitive. I tried using text-...
1
vote
0answers
20 views

Want Filter fetch data from SharePoint lIst on the below code of autocomplete JS

where DocumentOwner(People Group Type Column) = Me (Current Logged in User) Here i save current logged in user in a variable named as OwnerTitle and RequestStatus(Choice Type Filed) is equals to ...
1
vote
1answer
352 views

Get field value from form and pass to web part list view filter

In SharePoint 2016, I have created an edit form with a web part in the footer area that displays list data. I would like to grab the value from the field named Start Day and then use that value to ...
8
votes
4answers
2k views

Filter Created in SP REST API

I have this code below: jQuery.ajax({ url: res3 + "/_api/web/lists('" + normlistid + "')/items('" + normid +"')?$select=ID,Title,Created,QuemLeu/Id&$expand=QuemLeu", method: ...
1
vote
1answer
839 views

PowerApps Gallery Filter not working

I'm having another issue with my Filter formula. I have a gallery and I added a control (an icon) called FilterToggle which has a simple toggle action -- the OnSelect says UpdateContext({...
0
votes
1answer
614 views

Date range filtering in a list using JSOM

I want to add a date range filter on a list/library. I tried with the out of box date filter web part but it is causing some issue as search box disappeared & no items in the list if the value is ...
1
vote
0answers
75 views

How configure List Filter Webpart?

I have two list : Users: Fields: username (AD users), region and city. Cities: Fields: regions and cities I would like to filter Cities list by current user's region. I created List filter ...
1
vote
1answer
123 views

Implement date filter on a list

I want to implement a date range filter on my sp2016 list, having two date fields (To and From date) and where a person can select the date range and filter the list data. I tried with the out of box ...
0
votes
1answer
385 views

SharePoint Lookup Column Additional Field Value

Hello SharePoint Community! So, I have a list of a item content type that has a Yes/No field. I reference this content type in a lookup relationship on a Document Library. From that lookup ...
0
votes
1answer
356 views

Getting objects with today's date in Rest API

I need to fetch task objects which are completing today using Rest API , Can anyone please suggest how can we use today option to filer the data? I am using below query: /api/Objects/Task?$filter=...
1
vote
0answers
38 views

Metadata Menue checkbox alternative

I've got a situation where I'm building a document library, with large number of values for each field in metadata and check boxes as a filter do not make sense there, since the list will be extremely ...
1
vote
1answer
133 views

Problem with date range filter

I have implemented date range filter on my SharePoint 2016 list using date filter web part. The complete procedure you can find here But after this implementation my list search box vanished. Even ...

1
2
3 4 5
16