Questions tagged [filter]

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

325 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
2answers
35 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
19 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?
0
votes
1answer
58 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
41 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
217 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
2answers
624 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
50 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
55 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 ...
0
votes
2answers
62 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 ...
0
votes
0answers
83 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 ...
0
votes
1answer
27 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
20 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 ...
0
votes
2answers
165 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
33 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
100 views

Filtering view and workflows for lookup columns

I have 2 lists with the following columns: List A - "Status" (choice column)/"Name"(Single line)/"ReqNr(Number)" List B - "StatusNameReq"(Lookupcolumn based on the columns in List A) Now, I want to ...
0
votes
1answer
218 views

Search SiteGroups API not working when case sensitive

I'm using the API to search for sitegroups as below: "/_api/web/SiteGroups?$orderby 'Title'&$select=Id,Title,LoginName" + skiptop + "&$filter=startswith(Title,'" + value + "')" However, I ...
0
votes
1answer
393 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 ...
0
votes
1answer
77 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?
0
votes
2answers
63 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 ...
0
votes
1answer
41 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 ...
0
votes
1answer
156 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
1answer
21 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
1answer
96 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
2answers
535 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
341 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
1k views

Empty Filter Option display even no empty value exist

Empty Filter Option is showing in Person or Group column even when there is no empty value existing in the column. Is it normal behaviour?
0
votes
1answer
473 views

What are the limitations on a “single-line-of-text” column for sharepoint REST filters?

So, I am messing with my REST queries again, and was having some of these random errors. After some testing, it was determined that it appears that whenever a filter was applied to the title field, ...
0
votes
1answer
851 views

How to create a html form webpart filter for 2 list columns

I have a html form webpart (in the form of textbox input). I would like to filter 2 list columns using the same webpart: So instead of the usual filtering for 1 list column, this webpart will be used ...
0
votes
1answer
92 views

Filtering an asset library in Sharepoint 2010?

I've created an asset library with the headshots of several hundred of my company's employees. I want people to be able to search for the photos by last name and image type. I've added both of those ...
0
votes
1answer
293 views

SharePoint Online - filter lookup text field on new item form to current user

I have 2 lists: Traveler: Employee - Text (Ex:'Smith, John') Profile link - Url Travel Authorization Request: Traveling Employee - Lookup "Traverler:Employee" I need to apply a filter to the ...
0
votes
1answer
102 views

Textfilter with wildcards no results

I followed this tutorial SharePoint 2010 - Configure textFilter to but no matter what I search for (write a text, then press enter), I get no results. After a great deal of trial & error I can't ...
0
votes
1answer
172 views

Is inplview.aspx api based on search in SharePoint Online?

I want to filter a large library in SharePoint Online using columns headers filters on managed metadata fields. I know it's also possible to use Managed Metadata Navigation in classic mode, but users ...
0
votes
2answers
84 views

filter Document library based on metadata

Using SP-2016 I have a document library with 10K+ document and 12 metadata fields which is lookup columns from different different lists. to search specific genre of records, I want to filters that ...
0
votes
1answer
71 views

Hide list items based on results from another list (limited options)

Team, I have a very restricted Sharepoint environment; no access to designer no access to Filter webparts workflows limited to (1) Approval (2) Collect Feedback (3) Collect Signatures (4) Three-...
0
votes
0answers
378 views

Filter Custom List/ Document Library display via JQuery Rest Api

I tried using Api rest to filter the Custom list / Document Library display via jQuery , the script is working but the display of the list is not changing. Am i missing something? Thanks! function ...
0
votes
1answer
219 views

sharepoint search OR query with filter

I had the following query: https://[tenant].sharepoint.com/_api/search/query?querytext='Path:"https://one365dev1.sharepoint.com/teams/privegroep/Gedeelde%20%20documenten/*%22Isdocument=1"'&...
0
votes
0answers
83 views

SPGridView multi column filter issue

I have taken SPGridView Control and kept allow filtering as true. But I am not able to filter on more than one column. Any help would be appreciated Thanks
0
votes
1answer
45 views

Filter a document library for distinct file names with file date >= Prior Month end

File List: 20170320_My FileName.pdf 20170320_Another FileName.pdf 20170313_My FileName.pdf 20170313_Another FileName.pdf 20170306_My FileName.pdf 20170306_Another FileName.pdf 20170228_My FileName.pdf ...
0
votes
1answer
399 views

Filter Search source/results by list's choice column

Hello Sharepointers, I've created a Discussion List, with a choice column where users must specify either Internal or External (our discussions will either cover internal or external issues). When ...
0
votes
1answer
17 views

Library seach boxes not showing for some users

I have a sharepoint library which includes a filter/search box for each field. The search boxes were built by a 3rd party so I'm not sure how they are programmed. They are view specific. These boxes ...
0
votes
2answers
484 views

Passing multiple queries from a Web Part in order to filter a view

I am aware that using URLs like http://site/Lists/MyList/AllItems.aspx?FilterField1=Title&FilterValue1=ExactTitle&FilterField2=Year&FilterValue2=ExactYear will display a filtered view ...
0
votes
1answer
261 views

Search 'refiner' on first letter of sitename

In our SharePoint Online tenant, we use multiple site collections for teams and other collaborations. We want to make those site collections available via a search page on a site in the root site ...
0
votes
1answer
361 views

Filter [ME] is not working after migration from Domain A to Domain B. Working for user with entry in Only Domain B

I am the primary site collection administrator on my SharePoint 2013 environment. I have a task list with a filter view: "assigned to = [me]". My own tasks show fine when I am logged in. However ...
0
votes
1answer
333 views

Check if parameter contains column value in filter for data view web part

I am trying to filter a dataview webpart using a parameter ($Users) which is a string of usernames delimited by a semicolon (domain\user1;domain\user2;domain\user3;domain\user4). This string is ...
0
votes
1answer
48 views

Sharepoint 2010 send data from custom webpart to another custom webpart

I have 3 site collections : -site collection portal (http://xxx/SitePages/Home.aspx), -site collection Spain (http://xxx/sites/spain/SitePages/Home.aspx) -site collection China(http://xxxx/sites/...
0
votes
1answer
21 views

Rows don't show up when searching/filtering specific column

I'm new to Sharepoint 2013 and have a little problem: I have a big list with more than 5000 elements, now i want to filter the list via a view filter I know that this filter should return less than ...
0
votes
1answer
169 views

how to enable ldap filter

We have AD import synhronization in SharePoint 2013. I wrote LDAP filter which works fine on Domain Server. When I insert it LDAP filter I start incremental sync and not workig. I tried Stop Start ...
0
votes
1answer
105 views

InfoPath 3 DropDown pull inforamtion based on selction

I'm working on a form and am in need of some assistance. I used the following link, as a reference when I was creating this form I have three separate drop-downs (Name, Address, Phone Number) When ...
0
votes
1answer
3k views

Exclude items from a view using filter

I want to create a view which rules out several items in a list, i.e., if there are options A,B,C,D,E in column X, I'd like it to contain all list items except those that contain options D or E (...

1
3 4
5
6 7