Questions tagged [filter]
A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.
0
votes
1answer
16 views
Customize Filter Icon and filter pane in a Modern Experience document library
I am learning that the modern experience of SharePoint Online does not leave much room for customization. I had a request from the line of business to make the filter ICON considerably more visible ...
0
votes
1answer
17 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
13 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 ...
1
vote
0answers
13 views
Page filter doesn't work in edit mode
In my library I have the document id service turned on. So each new document gets an unchanging id. That is working.
I then have some other documents which are related to a given page. I've created a ...
0
votes
2answers
31 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
21 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
10 views
Losing CQWP filter “Contains all of” when applied/saved
I've added a CQWP to a web part page. In the web part properties, the source is from a single list, and i'm trying to add additional filters. If the second or third additional filter is set to "...
0
votes
1answer
33 views
Please tell, can we filter data on SharePoint Hyperlink Description but not URL using sharepoint query [closed]
Please tell is there any way or workaround we can filter on hyperlink "Description" using sharepoint query.
I know we can filter listview rendering using JSlink and hide rows but problem is when user ...
2
votes
1answer
34 views
Sharepoint large list filtering
Currently in Sharepiont 2010.
I have a list that just went over 5000 items. I have columns indexed and all views are filtered with these indexed columns. One of the columns is a "Date and Time" type ...
0
votes
1answer
20 views
View showing new list items
Is there a view (or a way) that show new items only to a list? My goal is to have a "New Items" list, or view that will be updated automatically shows any thing within the past 24 hours. Filtered ...
1
vote
1answer
26 views
Is there a limit of conditions count for oData query using $filter?
I have a long $filter query like ID eq 1 or ID eq 2 or ID eq 33 or ID eq ... and it works like a charm when we have up to 159 conditions joined by or.
But, when I add one more condition (started from ...
0
votes
0answers
26 views
SharePoint - Infopath - Lookup Field - Filtering Out Items
I'm working with a SharePoint List (we'll call it List A) that has a lookup field to a second list (List B).
List B has two fields: REPORT_NAME & RETIRED. RETIRED will either be blank or have an '...
1
vote
1answer
17 views
Items that SHOULD be showing in a view, aren't
So, I have a large list, with ~10,000 items.
I have created several views that filter via indexed columns that show below the threshold amount.
But I just modified one of the views, (changed the ...
0
votes
0answers
24 views
Filter Secondary data source based on two filter values - Infopath
I have fields 'Project Description' and 'Stage' in my secondary data source and also 'ProjDesc' field in my main data connection.
I am trying to filter my secondary data source when 'ProjDesc = ...
0
votes
0answers
14 views
Filter not working in List created from template
We use a list template to create new Lists in our SharePoint 2013 environment.
Everything works, but when we try to filter 2 values from one column all elements are displayed again (see screenshots).
...
0
votes
0answers
18 views
Filtering a List View with multiple conditions
I have a view I am editing in SP Designer 2013 and I keep getting a "Cannot complete this action. Please try again.Correlation ID:d47ecb9e-10f2-a0dd-4e30-aaddb657494b" error.
My desired filter: (a &...
1
vote
1answer
24 views
Unable to filter multiple columns of “Person or Group”
I am trying to create a view for our agents so that they can see if they created an item or if they have been added to an item. To do this I thought it would be as simple as:
Agent Name (Indexed)
is ...
0
votes
1answer
63 views
Filter list view by current year on SharePoint Online
I have a year column in one of the SharePoint list.
I want to create a view to filter the items by current year.
How to do this?
I have tried a lot but it doesnt work.
Please help
0
votes
0answers
33 views
Filter File types from Folders/Files
I am able to pull in the data I need with using part of this sEndPoint
Main folder I'm pulling from:
https://company.sharepoint/sites/Site/_api/Web/GetFolderByServerRelativeUrl('Folder Name')?
...
0
votes
0answers
91 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
0answers
200 views
Quick Chart Web Part - Data From SharePoint List Confusion
In SharePoint Online, I can't seem to get my quick charts to work or display the data I would like.
The Column that has data to display option seems to just grab columns with numerical values. Is ...
0
votes
1answer
76 views
CAML filtered list views - filter more than one nested level?
do you know if it's possible with CAML to write a SharePoint list view filter query to retrieve a user that is a member of a group which in turn is a member of another group i.e. nested groups?
I've ...
1
vote
1answer
45 views
How can I filter the Highlighted content web part to only show things that the user flagged as “Save for later”?
Seems like it should be pretty straight forward however I am not seeing it.
There is already a baked in feature where people can tag a page or document "Save for later" at the bottom of most pages ...
0
votes
1answer
41 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 ...
1
vote
0answers
79 views
How to filter on a Edm.Double type using rest api?
I'm currently working on a small project where I need to query the Access Request list of a site, while this list is sort of hidden the REST api works perfectly (Mind you the title might be different ...
2
votes
1answer
39 views
SP2013 Custom List - Case Sensitive Filter with JQuery
Good Morning Friends;
I am using a JQuery script to act as a filter on a custom list. The text in my custom list is all Uppercase. Currently the filter is case sensitive. I tried using text-...
0
votes
0answers
9 views
“Shaded” Custom List View Class?
Good Afternoon;
I am using JQuery to filter a Contact List. The code I am using is attached below. This code works with the default view, however does not work with Shaded View. Does anyone know ...
1
vote
0answers
19 views
Want Filter fetch data from SharePoint lIst on the below code of autocomplete JS
where DocumentOwner(People Group Type Column) = Me (Current Logged in User)
Here i save current logged in user in a variable named as OwnerTitle
and RequestStatus(Choice Type Filed) is equals to ...
1
vote
1answer
74 views
Get field value from form and pass to web part list view filter
In SharePoint 2016, I have created an edit form with a web part in the footer area that displays list data. I would like to grab the value from the field named Start Day and then use that value to ...
6
votes
4answers
502 views
Filter Created in SP REST API
I have this code below:
jQuery.ajax({
url: res3 + "/_api/web/lists('" + normlistid + "')/items('" + normid +"')?$select=ID,Title,Created,QuemLeu/Id&$expand=QuemLeu",
method: ...
0
votes
0answers
15 views
Sharepoint Dataview URL Filtering and “Day 1” not working, other “Day n” works
We have a SharePoint site with a DataView. We are filtering the list by a field. The field is a Choice Field with the options "Day 1, Day 2, Day 3".
When we put in
SitePages/Next%20Month-End.aspx?...
1
vote
0answers
59 views
Me Filter on Multiple Selection Lookup Column
I have found plenty of information about filtering lookup columns (title: Employee)during searches but I haven't located something that said using [Me] filter. I created a lookup column that has ...
1
vote
1answer
244 views
PowerApps Gallery Filter not working
I'm having another issue with my Filter formula. I have a gallery and I added a control (an icon) called FilterToggle which has a simple toggle action -- the OnSelect says
UpdateContext({...
0
votes
1answer
145 views
Date range filtering in a list using JSOM
I want to add a date range filter on a list/library. I tried with the out of box date filter web part but it is causing some issue as search box disappeared & no items in the list if the value is ...
1
vote
0answers
47 views
How configure List Filter Webpart?
I have two list :
Users:
Fields: username (AD users), region and city.
Cities:
Fields: regions and cities
I would like to filter Cities list by current user's region.
I created List filter ...
1
vote
1answer
37 views
Implement date filter on a list
I want to implement a date range filter on my sp2016 list, having two date fields (To and From date) and where a person can select the date range and filter the list data. I tried with the out of box ...
0
votes
1answer
87 views
SharePoint Lookup Column Additional Field Value
Hello SharePoint Community!
So, I have a list of a item content type that has a Yes/No field. I reference this content type in a lookup relationship on a Document Library. From that lookup ...
1
vote
1answer
115 views
Getting objects with today's date in Rest API
I need to fetch task objects which are completing today using Rest API , Can anyone please suggest how can we use today option to filer the data?
I am using below query:
/api/Objects/Task?$filter=...
1
vote
0answers
24 views
Metadata Menue checkbox alternative
I've got a situation where I'm building a document library, with large number of values for each field in metadata and check boxes as a filter do not make sense there, since the list will be extremely ...
1
vote
0answers
48 views
Problem with date range filter
I have implemented date range filter on my SharePoint 2016 list using date filter web part. The complete procedure you can find here
But after this implementation my list search box vanished. Even ...
2
votes
1answer
478 views
PowerApps Sort and Filter
I don't see a similar question based on a quick search, so I'll ask a newbie question about PowerApps:
I have a SP Online list relating to incoming parts (raw materials) and I'm creating a new form ...
0
votes
1answer
31 views
Pass Sharepoint List Filter Value to Content Query
I have a Sharepoint List Filter and want to connect it to a Content Query.
I tried to use variables like [PageFilterValue: MyFilter] but did not work
1
vote
1answer
814 views
Filter Columns with Multiple Values [closed]
is there an OOTB feature in sharepoint 2013 to use multiple values when filtering a metadata column? thanks
1
vote
1answer
103 views
Search: Adding AD Office Location as a Search Filter
I'm struggling building a People search page, everything is going great until I want to use AD "Office Location" information (Which we all have setup already, see the orange box in the screenshot) as ...
1
vote
0answers
39 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.
...
1
vote
1answer
43 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
175 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
29 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
98 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
26 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 ...
