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
0answers
101 views

I need to dynamically filter Sharepoint 2016 calendar. Is it possible?

I am using sharepoint calendar, but I am stuck at one scenario. I have Team column in my sharepoint list, I need to dynamically filter calendar view based on selection of values in Team dropdown list. ...
6
votes
5answers
15k views

How can I filter a view using a blank multi-line field?

I have a multi-line text field and need to be able to show a view with only items where that field is blank (or functionally blank to a human looking at it). I've tried: field contains "" field ...
1
vote
1answer
52 views

local document link to sharepoint list

I have file a server with huge size (more than 50 TB). What my manager want is to create a search on these document from SharePoint with metadata filters (not content search). Basically what I am ...
0
votes
1answer
434 views

SPO modern list view with multiple filters not filtering list

I have run into an issue where I create a view with the filters in the image below (the list is a modern list in SPO converted over from 13' to SPO by share gate). The issue is that I continue to see ...
1
vote
1answer
101 views

Need Help with SharePoint List view weird behavior?

I have a list in SharePoint online and I am trying to filter using the registration numbers and want to display all the registration numbers greater than 3000 (3001-3600) on a view. The total number ...
0
votes
1answer
96 views

SharePoint Task List filters

I want to add filter on a workflow task list if the task is duplicated (same title with different ID) to show one item per task (show only the most recent one). How to achieve this?
2
votes
0answers
336 views

Filtering a Grouped By view by current year in SharePoint Online

I am aware of this and have done this multiple times before and it used to work fine. However, currently I am facing unexpected behavior and it's different in Modern and Classic views. I have a list ...
1
vote
0answers
42 views

SharePoint 2016: filter on managed metadata column with AND operator

We are using SharePoint 2016 and have a document library with a multiple managed metadata column. In this document library we try sometimes to filter on this column. We can select 1 or more terms in ...
0
votes
2answers
67 views

Filtering List Data

I have a small requirement where in i want to filter the list data based on some columns but i cannot wrap my head around the Rest Api Query. So, i want to filter data based on few columns which are ...
0
votes
1answer
21 views

In SharePoint Online, is it possible to filter a standard View based on the documents that specific group(s)/user(s) have been granted access to?

I'll be creating sensitive financial documents for 20 locations worldwide. I'll stop inheriting permissions and granting permissions at the file level. I would like the permissions I grant for each ...
1
vote
0answers
246 views

Modern page: Show FILTER PANE in Library webpart. Possible?

I am using this modern "filter pane" in my library, but when I use a Document Library Webpart to show this library as part of a page, the filter pane is not present. How can I show the Filter Pane ...
0
votes
1answer
37 views

Filter list top 5000

In order to prevent a list view threshold issue I would like to have a list filtered by the last 5000 records. It would be something like Select Top 5000 order by ID Descending. Tried to implement a ...
2
votes
2answers
733 views

Content Search Web Part filter by user properties on Multi-Choices field

I'm trying to filter a content search web part by using the current user's office value {User.Office} imported from AD. I followed Ben N.'s example here: https://en.share-gate.com/blog/filtering-...
1
vote
0answers
106 views

Filtering SharePoint List by Another SharePoint List

I've been searching the forums and doing research online with no luck- apologies if this has been answered before. I have a list with several thousand items in it. I often receive bulk update ...
0
votes
1answer
169 views

CAML Query to find items with wrong expiry date

I have a library with 65,000 items and for some items the “expiry date“ is not right. The field should actually be calculated automatically from the “creation date“ + 8 years. How can I determine the ...
0
votes
1answer
60 views

Auto assigning from one list to another

I'm trying to set up a reservation for cars in my agency. I would like to try to auto-assign these cars based on what is entered from another screen. Once I find an available car, based on that ...
1
vote
1answer
115 views

Clean up Sharepoint URLs for Google Analytics?

When using Google Analytics on Sharepoint how can I clean up the URLs? I want to have a better idea of what my users are actually doing vs. seeing things like: http://sp.company.com/sites/blah/...
5
votes
3answers
14k views

Filter a Multiple Selection List Box in Sharepoint

I have what I thought a simple problem, but can't seem to find any solutions that work or exist in SharePoint 2013. I have a multiple selection list box in an InfoPath 2010 form. This box defines the ...
0
votes
2answers
33 views

Transform data into a date in a list and make it functional

I am having issues trying to transform data into a functioning date in SharePoint Online in a list. The idea is that we display upcoming birthdays for the company but don't display their actual age. ...
8
votes
4answers
20k views

Filter view by current year

I have a Year column and I already know that it's not possible to filter a view using Year equals =YEAR([TODAY]) and use [TODAY] in calculated columns does not work as expected. Does there exist a ...
1
vote
1answer
61 views

SharePoint Filters and Custom Views Total Calculations

I have a Date column where users can enter any date they want, I also have separate column that shows the month of that same date column. I am trying to create a filter that will count how many ...
0
votes
1answer
321 views

Calculating the GROUP BY total in a SharePoint Column

I am trying to do something here, which I do not know if it is possible. I have a custom list in SharePoint 2010 where the "Course" name is unique. I am using "Group By" in the view which shows me ...
1
vote
0answers
23 views

How to Get User-Generated Columns from Ajax

Is it possible to determine which columns in a SP List or document library were custom generated by the user? I'm essentially trying to recreate SharePoint's front end in my app, and I want to add ...
0
votes
1answer
24 views

Sharepoint online filter list not showing

I'm on SharePoint online and I have a list that a web part is calling from. I saved each group into a different view but when it comes up on the web part it is still showing "all" instead of the view ...
1
vote
2answers
32k views

How to filter SharePoint list column with username of the current user

I need to pass the current user name in the filter for Contains condition - Whenever passing [Me] it gives error: Filter value is not a valid text string.
0
votes
1answer
69 views

Rest api return elements outside the filter

I'm having some problems with my filter / rest call. I'm trying to get the items that match some criteria in a list but it returns way to much. ?$select=Employee_x0020_No_&$filter((...
2
votes
2answers
3k views

How to filter a list by hour

I am on SharePoint 2013 and do not have access to Designer, as a preface. I am trying to create a list view that filters items by whether or not they were added in the last hour. I had done this ...
1
vote
1answer
49 views

List Filter in Look up

I have a list which contains a column for Name and a column for Department I'm building a secondary list which will contain two look up columns. These looks ups will display the Name column from the ...
2
votes
1answer
3k views

Current User Filter Web Part - Wildcard Filter from Multiple Names

I have a list view webpart which contains a field which is a list of users, semicolon delimited. The field is a single line text field. I then have a current user filter web part which filters list ...
1
vote
0answers
116 views

Linking to a webpage with a search function and auto filtering that function

In my company, there is a SharePoint site with a page with a search box on it. Underneath this box are two separate web parts, showing two separate lists. The user is asked to enter a value into the ...
1
vote
1answer
99 views

Get specific data from Sharepoint list

I’m trying to get specific data from sharepoint list. I want user to select from drop down menu and depending selected value get row data from list matching values because i want to fill out ...
1
vote
0answers
21 views

Sharepoint 2013 wiki template with web parts

We're on SP2013 site collection. I'd like to create a template for the 200 different profiles we have. Each profile consists of: 1. wiki for tables and unstructured data, 2. wiki columns (display on ...
0
votes
2answers
3k views

Filtering Large Lists with AND and OR operators

I have a larger list of data including more than 5000 items. Users create entries and assign them to managers for review. Managers action the items and users re-review. I am using SharePoint 2013 ...
0
votes
1answer
133 views

Retrieve all task names from a task list

I have created a task list and a document library. I try to connect these so that it filters the same data at the same time In my document library I have a lookup-column that retrieves the task name, ...
3
votes
2answers
5k views

PowerApps: How to filter a people picker combobox?

I have a combobox in a powerapps form to select a user, works good. The filtering works as text is typed in, but initially it displays the full listing of users. Is there a way to show nothing until ...
1
vote
2answers
268 views

View filter on multiple AND/OR combinations

I'm trying to set up a view to filter on column Status (options are "WIP - Drafting", "Eng Check" and "Peer Check") and the name in columns "Drafter", "Eng" or "Peer". Any one of the engineers could ...
1
vote
1answer
230 views

How to create caml query with group by taxonomy field?

I have a taxonomy field as department .I need to use group by query in this field.is possible to do it? If yes, suggest some idea to implement it..
3
votes
2answers
2k views

Show All Tasks Assigned to Me (including those assigned to Me and Multiple Users)

I have a Task List WP on my Site Page and I want it to show all Tasks Assigned to Me (my name is Jay Scott). This includes both of the following Tasks: TASK 1: Assigned to Me only, ex. 'Assigned to: ...
0
votes
2answers
611 views

Filter Lookup column based on Current Logged in user

I have a small problem i am facing in CAML queries. Currently i am trying to filter a Lookup column based on Current logged in User in SharePoint Online. Here is my code and i am new to using SP ...
0
votes
0answers
390 views

Show all available filters in list filter pane

My company uses a SharePoint list to track projects as they are produced and shipped. This list has around 100 columns of data, but the default view has 20 columns visible. When we open the Filters ...
0
votes
1answer
920 views

Filtering List Items by URL using textbox

I am looking to filter list data by appending to the URL of the list with the query text. This is the only solution I've found to my problem, filtering data using wildcards. For example, If I'm ...
0
votes
1answer
29 views

Using Lookup field but removing some items

We're creating a sign up list for our fortnightly inductions at work. We've got a list which has all the induction dates, and another list for the signups. The signups list has a lookup field to the ...
1
vote
3answers
4k views

Show only the most Recent Item Created

I'm currently looking to create a view that only shows the most recent item created. I have a list that calculates weekly reports and i want to allow the user to have direct access to editing the ...
0
votes
3answers
3k views

Creating a View That Can Filter on Lookup Column

I have a list with a column called Function that is of type Lookup. I try to create a view in the list and I attempt to Filter below: I click OK at the bottom of the page and I get the below error: ...
4
votes
1answer
1k views

BDC List column picker filter - search/filter not working and exact entry says not found?

I'm working with MOSS 2007. Rephrasing the question. I have a BDC column to an external data source in a custom list. Today searching and filtering are not in place and actually exact matches are ...
0
votes
1answer
291 views

Filter Dropdown values on List InfoPath

I have tried this example. https://social.technet.microsoft.com/wiki/contents/articles/32961.sharepoint-filter-dropdown-values-on-list-infopath-form-based-on-current-user.aspx But I came across with ...
0
votes
2answers
76 views

Cannot use a variable in where clause

I am using the PnP SharePoint powershell moudle and trying to filter a users list based on a variable. Currently here is what I have: $RootFolder = '/Path/To/Folder' $folders = Get-PnPFolderItem -...
2
votes
0answers
201 views

Filtered lookup based on lookup

My situation is this: I'm trying to set up a review site for the publishing house I'm working for. Basically, the editors should be able to pick reviewers for new books based on certain categories. ...
1
vote
1answer
155 views

Creating filtered lookup in SharePoint 2010 with InfoPath 2010

I have a requirement similar to this. https://www.sharepointusecases.com/2010/01/creating-filtered-lookups-in-sharepoint-2010-with-infopath-2010/ In my case Project field should be a text field and ...
6
votes
5answers
67k views

Filter a list view using URL parameters

I would like to dynamically construct a couple of URLs for our SharePoint users to filter down a rather large list view we have. Rather than create a bunch of different custom views, I was wondering ...

1
3 4
5
6 7
17