Questions tagged [filter]
A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.
0
votes
0answers
9 views
Optimize Retrieval of Multiple Lists
The below code snipped retrieves all items within each list in a subsite. Then filters by list title so that only information from lists containing "RDTEN" or "procurement" in their title get parsed. ...
1
vote
1answer
15 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 ...
5
votes
4answers
178 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
14 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
24 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
26 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
37 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
21 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
34 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
35 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
29 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
13 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
24 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
52 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
24 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
42 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
41 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
15 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
36 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
43 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
20 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
45 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
17 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
27 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
11 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
29 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
1answer
23 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
101 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
61 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
38 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
37 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
36 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
50 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
25 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
10 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
6 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
14 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
319 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
35 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
20 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
16 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 ...
