Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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
1answer
49 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 ...
1
vote
1answer
134 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..
1
vote
1answer
129 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 ...
1
vote
1answer
415 views

SharePoint Designer CALL HTTP filter by choice field

In SharePoint Designer, CALL HTTP web service, is there a difference between filtering by single line of text vs. choice? I'm trying to filter the columns [ScheduleType] and [AccountStatus], which ...
1
vote
1answer
392 views

Filter a list based on two due date columns

We have a list in SharePoint 2013, which we want to filter based on two date columns. The due dates refer to two different tasks. We want to see only elements with due date within the next 7 days og ...
1
vote
2answers
19k 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.
1
vote
1answer
36 views

List still nearing view threshold despite filter

We added a filter to our list to avoid reaching the view threshold (original question was here: SharePoint List View Filter display 1 week) but despite the filter being active (currently the view is ...
1
vote
1answer
574 views

Remove “clear filter” option from the column

I’ve connected SpListFilterWebPart filter to the list and it works fine filtering the list except that I can’t clear filter selection. That is, once filter is applied to the list, little “filter” icon ...
1
vote
2answers
332 views

Can you set a text filter value in a hyperlink?

I have been trying to find information on how to do this. I have a web part page that has 3 lists, and those 3 lists are are all connected via a text filter. The goal is, to create a link in a ...
1
vote
1answer
49 views

SharePoint view issues

I'm having some issues on a SharePoint list view. I have a people picker column "Work Allocated" and have enabled the Folders in the list view. I'm creating folders for each month and I would want the ...
1
vote
2answers
2k views

How to filter webpart for multiple values

I've added a list webpart (using UI) to a webpage and also added a Choice Filter Webpart. It appears I can only filter the list using a single value, i.e. multi-values are not supported. Is there any ...
1
vote
2answers
259 views

What is the French equivalent of [Today]?

I'm creating a view in French where it filters on items greater than today's date. Unfortunately, I cannot find the French equivalent for [Today]. Anyone know? Thanks.
1
vote
1answer
772 views

REST API get by author differences by platform

I find that when I want to retrieve custom list items by author (in this case, by the current user) I need to use a different query whether using SP2013 on premise or O365. I tried creating the same ...
1
vote
3answers
2k views

Sharepoint 2013 CQWP - Filter by Approval Status

I'm kind of stuck in a Content by Query Webpart. (Yes, i'm aware i'm on 2013, and yes, i could use Content by Search WebPart, but this is a standard edition, so no, finally i can't use CSWP) I would ...
1
vote
2answers
5k views

Filter lookup column based on another field value

Scenario: I have Tasks list with a (lookup) column Project. I have also a multivalue lookup column Predecessors pointing to the Tasks list itself. Question: Is it possible to filter available Tasks ...
1
vote
1answer
60 views

Wiki search options

For example I have 2 wiki pages. First page includes such keywords as AD.180, AD.159, AD.200, second page includes keywords AD.300, AD.180, AD.159. If I search for AD.300 it displays me all pages ...
1
vote
3answers
3k views

Sort and Filter Rich Text

i have a sharepoint list with a few rich text columns but in the view the headlines of these doesnt have the button to sort or filter them like all other non rich text columns have. is there a way to ...
1
vote
1answer
930 views

Multiple filters with query string

Imagine this situation: a SharePoint 2010 teamsite 2 lists 1 query string filter webpart to connected to the first list the 1st list is connected to the 2nd to filter the 2nd When I click an item on ...
1
vote
1answer
2k views

How do I set FilterOperator1 in the URL?

I know I can filter a SharePoint list by adding ?FilterField1=fieldname&FilterValue1=value to the URL. Microsoft's documentation also lists a property FilterOperator1 that you can use if you want ...
1
vote
1answer
614 views

Autocomplete filter using Sharepoint PerformancePoint Dashboard Designer

I am using Sharepoint 2010 with PerformancePoint Dashboard Designer. I am creating a dashboard that has a filter at the top of the page. The filter contains a very long list of items and I was wonder ...
1
vote
1answer
7k views

What is correct syntax for filtering a list on field values?

Salvete! I want to filter a list like this. Now, [othercolumn] is supposed to be the value of the field in the X-Field column. I want to see if the X-field column contains the text given in the ...
1
vote
2answers
2k views

Custom Search Page Filter Results

I have created a custom search page with a core search web part. It builds a query string in URL to populate the search results. k=[keyword] is the first, then to narrow the search to specific ...
1
vote
2answers
4k views

How to filter column in chart web part?

I have a list with 3 columns, Month, volvo, benz. I have created a chart which contains 2 series, volvo and benz. It shows 2 series based on month, for example for jan, it shows value volvo & benz ...
1
vote
1answer
3k views

SharePoint - Showing folders in a filtered view

I have a library with a few folders in it, and the files in the folder have a "Status" property and an "Assigned To" field. I want to make a view with the following logic: If (Content Type == Folder)...
1
vote
1answer
3k views

Filter Multiple connections List (no-code solution)

I have a mission to create a filter for any field of my list, there are many. The connection is just made in the first filter, I cannot connect more than once... I've searched for code which would ...
1
vote
1answer
1k views

How to format the spgridview filter data?

I have a SPGridView where I am binding a calculation field. I am dynamically binding data to sp grid view in a web part. The filter value is displaying like String;#filterexp1, String;#filterexp3, ...
1
vote
1answer
1k views

On a SharePoint list view with filtering, I want to apply jQuery to the filter list, which isn't built until the user clicks the menu

This project is in MOSS, using jQuery 1.6.1. The basics of what I need: When the user filters on a date field, the value of the filter option needs to be "yyyy-M-d" while the text is "M/d/yyyy." ...
1
vote
1answer
1k views

Filter by metadata through connection to another item

I was wondering if it is possible to filter a list item based on metadata values from another list item. I tested it locally but it didn't seem to work althougth another post here said it should work ...
1
vote
1answer
140 views

Best approach to implementing a forced filter on a site?

I'm relatively new to SharePoint development so please excuse the question if it is an obvious one. Environment I have a site hierarchy that looks like this Client Dashboard Client sites (one or ...
1
vote
1answer
464 views

Filtering for recurring events happening [Today]

Is this possible? Ryan Wheeler says its not here. Tim says it is if your view is of type "Standard View, with expanded recurring events" here. I haven't been able to get Tim's suggestion to work. (...
1
vote
2answers
2k views

Sharepoint View Filter (how to check for nulls in Scheduling Start/End Date)

I am trying to use the built in sharepoint U.I to setup a filter for Scheduling Start Date & Scheduling End Date. However I noticed that if you setup something with a "Scheduling Start Date" as "...
1
vote
1answer
3k views

Multiple filters in ECT External Item Picker in SharePoint 2010 BCS?

I am using SharePoint 2010 BCS to connect to a SQL Server database table and created an External Content Type (ECT). In this ECT you can specify a filter and I have done that, and I mapped the ECT to ...
1
vote
1answer
731 views

How do I use a javascript variable in the Filter Criteria for a DVWP?

I am converting some numbers using Javascript and need to filter a list using these conversions. I cannot do the conversions within SharePoint itself, so I had to use Designer and some Javascript. I ...
1
vote
1answer
37 views

Is there a way to have a single Metadata Navigation which work on multiple documents libraries which share the same site columns

I am working on an online modern team site collection. and we have 5 documents libraries, where these document libraries share the same 3 managed metadata site columns. Now for each document library, ...
1
vote
1answer
23 views

current user filter web part in SharePoint

I would like the user to only see their tasks that are meant to their department for example (IT Users when they are logged into to Tasks list ) they should only see Tasks for IT department only. I ...
1
vote
2answers
21 views

How to filter out this?

Im a beginner.. I have searched now for some hours for a solution without success. I have following list with 3 columns and 3 items Date Id Place 190725 1 A 190724 1 B ...
1
vote
1answer
130 views

Is it possible to filter search results when searching in a modern document library?

I noticed that when I search for something in a document library and click "See All" for all the search results, the filter icon in the top right corner disappears and I am unable to use any of the ...
1
vote
1answer
565 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({...
1
vote
1answer
51 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 ...
1
vote
1answer
63 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/...
1
vote
1answer
47 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
2answers
53 views

Display filtered list by category

The current script creates a table showing all Items from the list. e.g. In my list there is a column named 'Category' with 'Cats' and 'Dogs'. What I want to achieve is to FILTER and ONLY display '...
1
vote
1answer
271 views

My SharePoint Online Alert is sending an alert based on anything in the list, not the filtered items

I have a List with a one filtered view. I set an Alert on the list, hoping that the email would only show the items that pass the filter. But everything in the List is showing up in the email. Is ...
1
vote
2answers
380 views

SharePoint Foundation 2013: Is it possible to dynamically filter document libraries?

I'm developing a website and, as part of the specifications, I need to have a number of documents in a central document library, then only display a subset of them to the user at any one time ...
1
vote
1answer
59 views

warning while defining lookup to get single value from a list in workflow

While assigning value from another list to workflow variable with filter I get an error saying "The lookup that you defined is not guaranteed to return a single value. If more than one value is ...
1
vote
1answer
244 views

SP 2013 : CQWP documents filter exclude/do not begin with

Good morning ! I have a really big question, and I found absolutely no good answer to it. I have a SP2013 on premise. I need to display content only by using Content Query WP (my client does not have ...
1
vote
1answer
608 views

Using a parent site calculated field as a lookup source

How can I achieve the following: I have a parent site with a Contacts List. There are columns for "First name" and "Last name", and I made a calculated column called "Full name" to display them both ...
1
vote
2answers
335 views

Creating a choice column (IF statement/display specific choices)

I create an customize list. There are two choice columns and I want to achive the result is, If column A select "aa" column B will only display some specific choices, such as "1.1 aaa" "1.2 bbb" Same ...
1
vote
1answer
447 views

Can't group by a column (Business Area) in my document library

Business Area is a required column in my doc library. It's set up as "Checkboxes (allow multiple selections)". I have created several views, and in some of them I want the option to group by that ...
1
vote
1answer
57 views

Displaying filtered data on a page from a List

Current Scenario is as follows: I have a parent site where I have a list containing multiple projects with project codes. There can be multiple projects against a project code. The same depicted ...