SharePoint

Questions tagged [filter]

Ask Question

A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.

806 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
3
votes
1answer
42 views

“Get Items” returning incomplete list of items in Power Automate

This has been a maddening problem for a few weeks now and I can't seem to find the cause. I have a flow that simply needs to get the items from a list and filter them based on a field. I've tried this ...
1
vote
2answers
23 views

Dynamic filtering using lists, hide information until selected

New to this forum, tried searching without any luck. I wish to hide information from a list until a selection has occurred. I'm using dynamic filtering. Example I got two lists (List1, List2) List 1: ...
0
votes
1answer
26 views

Create a view Filter SharePoint list for items I - [Me] - haven't rated

Is there a way to filter (and subsequently create a view for) a SharePoint list to show items that the current user hasn't rated? For example, in the list below I would like to create a view that ...
0
votes
2answers
31 views

Pass parameters to external list on SP2019 Standard

I have an external list that is displaying data from a SQL Server view. Now, I want to add filtering. The problem is that I'm working on Standard version of Sharepoint, so no Enterprise webparts are ...
0
votes
1answer
72 views

Filtering listview using React Sharepoint

I am trying to display data in react-data-table-component according to the input given in the search field using Rest API. For eg: If a user enters name of the person the react-data-table-component ...
1
vote
1answer
18 views

Filter data based on Taxonomy value [closed]

I am building a search web part in which, I am filtering the data from the SharePoint document library based on the value in the skillset column. It is a managed metadata column. Below is the ...
0
votes
1answer
29 views

Filter list by Author (Created By) field with rest api - SP Online 2019

So I'm sending a REST query like: _api/web/lists/GetByTitle('List')/getitems?$select=AuthorId It works fine, I see 49 records with AuthorId. Now I want to filter by this column. Then I want to filter ...
0
votes
2answers
13 views

Add multiple Fields For the CamlQuery in Sharepoint Hosted App

I am trying to filter two fields or more that is clean of null values. It works for the first field but it is not working for the second field: <View><Query><Where><IsNotNull>&...
0
votes
1answer
16 views

All columns not present in create view filter option

Trying to create a view which filters a specific columns with hyperlinks in it. I went to create view --> filter and that column does not appear in the drop down. Any ideas?
2
votes
2answers
38 views

(another take on) Filtering Sharepoint view based on date range

I know that the answer for this question is easy to find on the internet, including this thread - but the suggested solution doesn't work for me. I need to create a view in a Sharepoint online list, ...
1
vote
1answer
75 views

Sharepoint online — managed metadata term set filter not working

Novice user here. We have created a list of products on sharepoint online. Products are tagged using a managed metadata term set. We would like to use this to either A) filter the list and save views ...
0
votes
1answer
33 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 ...
0
votes
1answer
140 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
0answers
50 views

Filter expanded properties with the REST API

I am trying to query a folder recursively for files that were created after a certain date. I am able to find the files by expanding file properties however I am unable to filter against the expanded ...
0
votes
1answer
57 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 ...
0
votes
1answer
23 views

SharePoint List View Complex Filter Logic

I'm creating a SP list view and trying to apply a filter to it without creating calculating columns to compare: Show items only when the following is true: Status equals to "Cancelled" AND ...
0
votes
0answers
25 views

Multiple input filtering on SharePoint calendar listview using Javascript

I am trying to use the code below generously provided by @Cat in this post; https://stackoverflow.com/questions/63093757/javascript-filtering-by-multiple-columns, to filter a sharepoint listview. Any ...
0
votes
0answers
26 views

Using Query Filter (URL) String with Images

I have a page with a document library & a task list using query URL filter strings. Is there a way to filter images stored in a site assets library? I would like an image on the page to change ...
0
votes
1answer
45 views

Sharepoint REST API - Filter by Negative Number

I'm trying to filter by a negative number but it only seems to work with zero or positive. Does anyone know how to fix this? My query is below: spUrl + '/SitePages/checklist.aspx?filter=ChecklistID/...
1
vote
1answer
162 views

View only Folder items

Can someone explain to me why this is not working (and how to make it work)?: Steps to reproduce : Go to a folder in all document view > edit current view > click show items only when the ...
0
votes
0answers
75 views

JSON list formatting to show/hide items based on SharePoint group membership

Hoping someone can confirm something for me. Here is the scenario: I have a SharePoint list with a 'Managers' column (type: Person/Group). I have created a SharePoint group called 'Managers SP Group'. ...
3
votes
1answer
84 views

Link Document Library to Search Filter

I have a SharePoint Content site which also has a document library. The document library has columns that classify the document. I am trying to (on the homepage of the content site) add a Search ...
0
votes
2answers
234 views

Filter a list by User or Group column in CAML Query

Is there a way to filter a list by User or Group column? I need to get all the tasks assigned to each user in a site. I got the below code for now, but that only works if I'm trying to get my tasks. ...
0
votes
1answer
23 views

Date column grouping header links to page with date format incorrect and no results shown

I have a SharePoint Online list using the Modern view that I have grouped by a date column. When showing the list of groups everything appears fine. However, when I click the group header to view all ...
0
votes
0answers
95 views

Managed metadata filtering with hierarchy

I have a termset with hierarchy in sharepoint online in a document library. When I tag a document in the library with a child in the hierarchy and then try to filter from the tree view nothing is ...
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 ...
1
vote
1answer
41 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
135 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
55 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 ...
0
votes
1answer
23 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/...
0
votes
1answer
126 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....
1
vote
1answer
88 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
45 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 "...
0
votes
0answers
59 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), ...
2
votes
1answer
564 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 ...
1
vote
1answer
43 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
215 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 ...
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
1answer
29 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
71 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
119 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
38 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
30 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
159 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
110 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
383 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
519 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
166 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
1k 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 ...

1
2 3 4 5
…
17