Questions tagged [filter]
A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.
770
questions
0
votes
1answer
20 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
31 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
31 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 ...
-1
votes
0answers
18 views
Custom Filter by single column
I am currently using the below code for a jquery filter on a custom list. Is it possible to narrow this code, so it only searches on
<script type="text/javascript">
jQuery(document).ready(...
0
votes
1answer
23 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
47 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
26 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
56 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
21 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
15 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
15 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
16 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
24 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
47 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
2answers
170 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
20 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
30 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
11 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
28 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
61 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
58 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
24 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
133 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
34 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
130 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
33 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
32 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
23 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
0answers
14 views
how can i filter a list in a view on a page without breaking pagination?
I have an app part placed on a page in which i want to filter the data in the list to show. The data needs to be filtered by multiple conditions. i have most of the filtering done, but filtering by ...
0
votes
1answer
37 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
23 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
31 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 ...
0
votes
1answer
29 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
39 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
22 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
42 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
53 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 ...
0
votes
0answers
19 views
SharePoint Refinement Filter Display One Column and Sort by Another Column
I have a refinement webpart on a search page with several refiners. The issue I am having is that I need to sort the refinement filters based on another column or some other way to perform a custom ...
2
votes
1answer
310 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
76 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
189 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
21 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
15 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
17 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
72 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
23 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
0answers
11 views
Losing CQWP filter “Contains all of” when applied/saved
I've added a CQWP to a web part page. In the web part properties, the source is from a single list, and i'm trying to add additional filters. If the second or third additional filter is set to "...
0
votes
1answer
43 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
45 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 ...
