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
1
vote
1answer
21 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
20 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
15 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
21 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
27 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
31 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
27 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
49 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
44 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
26 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
140 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
50 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
27 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
48 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
31 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
279 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
23 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
17 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
19 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
71 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
265 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
32 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
12 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
33 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
124 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
95 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
205 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
39 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
229 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
34 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
30 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
18 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
40 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
26 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
45 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
39 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
41 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
59 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
72 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
565 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
95 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 ...

1
2 3 4 5
16