Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
0answers
15 views

Automatically reset text box after filter

I have a coprorate directory displayed on an ASPX page, using a List View Web Part. I have a HTML Box Webpart, which I have connected and use this as a filter so that users can enter in a name, to ...
0
votes
0answers
13 views

Connected webparts (list and task)

I have a list web part where I want to add a task web part to it. Main Objective for this web part is to have a list entry once clicked on it would see only the tasks associated with this entry. The ...
0
votes
0answers
7 views

Chart Web Part Excel filter

I have a chart web part that I am using an Excel file as the datasource. I can connect to the data just fine, but want to filter the rows with an "or" condition. The filter in Step 3 of Data and ...
0
votes
0answers
13 views

Sharepoint online Choice column remove (Empty) option in the filters

why do empty option appears in the filters for choice columns in sharepoint, even though all the items are filled with any of the option is there anyway to remove "(Empty)" option in the filter
2
votes
0answers
27 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 ...
0
votes
0answers
27 views

external data source filter with multiple values

I've an external list with data from a SQL database. I got some IDs (by querying a custom list) and want to get all items of the external list where those IDs match. The external list is very large so ...
1
vote
0answers
12 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
23 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
0answers
23 views

Current User Filter: filter person field

I'm attempting to implement a Current User Filter Web Part (as described here) filtering on a list field type Person/Group. Due to the number of options available in the bottom dropdown here, I ...
0
votes
0answers
8 views

Change Text filter webpart to not search exact match

So I've got a list of publications in SharePoint 2013 that I want to give the users options to search by specific fields. I've set up the filter web parts and for the most part they work fine, but ...
1
vote
0answers
14 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
16 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 ...
0
votes
0answers
16 views

Filter an AngularJS list for people in a certain Sharepoint group?

I have a list with reports which I'm calling with AngularJS, nothing fancy so far: <table ng-app="app" ng-controller="controller"> <thead> <tr> <th>Title</th> ...
0
votes
1answer
22 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 ...
0
votes
0answers
13 views

infopath forms help! views/permissions/help

good morning! I am trying to create a performance management form with InfoPath. Basically I have the employee name, manager, and reviewer as a person/group field. And what I would like is for when ...
2
votes
2answers
40 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
56 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
30 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
21 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
33 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/...
0
votes
2answers
21 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. ...
1
vote
1answer
32 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
39 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 ...
0
votes
0answers
20 views

How i can add more than 10 filters to my list view and apply AND/OR operators

I am working on SharePoint on-premises 2013, where i have a custom list, and i want to create list views which have the following filters:- View named "VIP". filtering criteria (customer name = N1 ...
1
vote
0answers
19 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
17 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 ...
0
votes
0answers
10 views

Connecting column from 3 list with links and search them by filters

I have got three lists how to connect them to show one two three or all records from this list with checkboxes and add to them filters to show one or more elements from list.
0
votes
0answers
8 views

Add Document Library WebPart with in EditForm with specific SubFolder

In a given project we have a SharePoint list. To each item we now want to add several files which we'll store in a subfolder named by the item ID in two seperates DocLIbs. Now I want to display the ...
1
vote
1answer
34 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 ...
0
votes
0answers
5 views

Filtering on a list web part from a URL or text within page (but not a search function)

I have a SharePoint site which tracks all projects in my area. Each project has its own site page, which hosts links out to relevant project information and contact details. Each page has the format ...
1
vote
0answers
13 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
41 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
12 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
166 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
29 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, ...
0
votes
0answers
17 views

SharePoint 2010 Filter WebPart sorting ID in wrong order

Is there a way to get my Search Filter WebPart to sort in the Natural Sorting Order and not the Lexical (Alphabetical) order? My list is Filtered by its ID Field. For reference: Natural Order - 1, ...
0
votes
0answers
14 views

How to display the results of Current User Filter?

I am having some problems where certain users are not being able to see list items that they have created in a filtered webpart. I am using the Current User Filter linked to a list. I have been unable ...
1
vote
2answers
606 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 ...
0
votes
2answers
60 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
87 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..
0
votes
2answers
242 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
112 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
0answers
28 views

Contains Text Filter for Wiki Library without Designer

I’m trying to create a search like text box to filter a Wiki Library based on the Page Name. I need it to include partial matches. I found this blog that would meet my requirement but I do not have ...
0
votes
0answers
11 views

How to modify a user profile property string and pass it to a list filter

I'm trying to retrieve a user profile property "Lowest Level" which returns a string "xxx-ABC". I want to use the right 3 characters "ABC" and pass that to a list as a filter. Currently I'm using ...
1
vote
2answers
242 views

Filtering Calendar Items Using REST API

I'am trying to get calendar items and filtering by EventDate and EndDate fields using rest api. DateTime field filtering works fine on other lists but I can not filter calendar items by EventDate and ...
0
votes
1answer
50 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((...
0
votes
0answers
18 views

select/mark documents as favorite

Is there any way to let users select/mark files in a document library as "favorite". The idea is to make the site a bit more personal, by displaying documents that are linked to users. Something like ...
1
vote
0answers
55 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
22 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 ...
0
votes
0answers
63 views

Query String Filter - Data View Web Part - using a lookup column

On my home page I have a drop down of country names from a list. This opens a "country page" with a query string of Country=XXXXX (depending on what country is selected in the drop down). This works ...