Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [sharepoint-list-filter]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
17 views

How to make the filter apply to all files in the folder?

I have a document library with few metadata columns. There are several folders, sub folders and files. The files have the metadata columns (example: choice column, managed metadata columns, etc) ...
variable's user avatar
  • 4,470
1 vote
1 answer
111 views

Preserve all filter choices in a list when saving a new view with filters applied

Problem: Let's say you have a column in a list with choices: Red Blue Green Yellow Great. Now I want to filter the list items so that only Blue, Green, Yellow appear in the list. I do so. After ...
Jack's user avatar
  • 13
0 votes
0 answers
24 views

List view web part hides last 2 items in a filtered view

Seeing a really odd phenomenon when I filter a list view either using the column's filter by property or using dynamic filtering with a connected web part. The filtered view should show about 30 or so ...
matt's user avatar
  • 589
0 votes
1 answer
56 views

Refinable String managed property uneditable

I have just purchased microsoft365 for business (becoming a freelance), and I want to set new managed properties for a list I've created. when trying to edit new refinableString properties, most of ...
Nitai's user avatar
  • 15
1 vote
2 answers
260 views

SharePoint Online List view is not showing Item with Group By" filter

In my SharePoint Online List, One of the views is having a problem as given below: Adding One Filter to get specific data --> Item shows as expected. Try to add a "Group By" filter, --&...
Md. Tahmidul Abedin's user avatar
0 votes
0 answers
35 views

Default value in daynimic fitering

I am using SharePoint online moden page. I have two libraries as below Countries : have list of countries Related Documents library: this library has lookup of Countries as metadata On Home page I ...
Umang Soni's user avatar
1 vote
1 answer
900 views

Microsoft Graph general exception using filter expression with 'and' condition

I am trying to query a SharePoint list where I need to pull the last name (title), first name, email, and replacement name by filtering on the last name (title) and first name to make sure we have the ...
shannon's user avatar
  • 25
1 vote
1 answer
168 views

SharePoint List "Filter By" pane is not respecting View Filters?

I have created a SharePoint List several months ago, this list includes several filtered views - both for usability purposes, and to avoid hitting the 5000 lines threshold. We have data for different ...
dontknowanything's user avatar
0 votes
2 answers
39 views

Group headings lost when a filter is applied

I have an interesting bug occurring - only to a select number of people (so not everyone has this issue.) I have a customized view display, grouped by a given field. Some of my users will open the ...
VASoftball5's user avatar
1 vote
1 answer
3k views

List Filter View Based on Date's And Current Week Days

I am creating different list views for different pages so I can restrict access. Each list item contains dates for each day of the current week. The list items go back a couple months, so I would like ...
BeerusDev's user avatar
  • 113
0 votes
1 answer
55 views

Asset Management App - How do I filter a collection of lists displayed in a PowerApps gallery using a comboBox of people names?

I am trying to find a way to filter a collection of SharePoint Lists displayed in a PowerApps Gallery using a ComboBox dropdown. This ComboBox dropdown gets data from another sharepoint lists for ...
Omar Osman's user avatar
1 vote
2 answers
664 views

Why filtering by date still exceeds the list view threshold?

I try to prepare a view for a list containing more than 5k items. When I try to filter it by an equal value in one column via REST API /Items?$filter=Status eq 'Not completed' , it does show a list ...
Jacek's user avatar
  • 11
0 votes
1 answer
65 views

pnp search filter and search result v4

Has anyone used pnp search filter and search result. I have a choice field "LearningStack" in 7 different list and 6 different libraries. The idea is to have a page where I can display "...
Jessica Dells's user avatar
0 votes
1 answer
90 views

how to build a url to filter a list available on Easy Tabs

SharePoint 2019 + Easy Tab Have 4x Tabs with same columns of data, looking to build a url that filters the data of lists on all tabs automatically. On each tab the column can be filtered and ...
mcv's user avatar
  • 131
0 votes
1 answer
63 views

Filtering pane issues

When trying to apply a filter using the column Filter by choice, the filter pane opens to look like the screenshot below. If the cache is cleared, it seems to revert back to normal. have also tried in ...
Thomas's user avatar
  • 1
0 votes
2 answers
334 views

List header: show only some filters

I have a JSON customized list view with about 15 columns. For the end user only about 5 of them are useful or should be available for sorting/filtering. If I hide a column from the view, the ...
Der_Fab's user avatar
  • 187
0 votes
1 answer
944 views

Two Lists: Choice field (lookup column) in first list should auto-filter column in second list. Help!

I have two SharePoint lists on the same site. One list (List A) has a lookup field (called Select Material) that displays the variables in the "Description" column in list (List B). I have ...
Its_Jen's user avatar
0 votes
1 answer
624 views

SharePoint List View Filter

I have a choice column "Position" which I am referencing in the new list view filter to create a bunch of different views for departments. Each department can only view certain relevant &...
BeerusDev's user avatar
  • 113
0 votes
0 answers
188 views

Create dynamic calculated column for filtered list view

I have a SharePoint list of 20000 items, where each item has 11 different columns, with values (tags) as per the item, that I add manually. So, I want to create a new column with a URL where the user ...
Grey fox's user avatar
0 votes
1 answer
588 views

Filter list dropdown based on another list dropdown within same form

I have a SharePoint list which has a drop down column called PM No - This is a list of numbers ranging from T1 to T200. Each T number relates to different machines. I want to have the option, for when ...
user97177's user avatar
0 votes
1 answer
142 views

Possible to apply Filter Views on a SharePoint document library when attaching documents in Outlook?

I have a document library in SharePoint with various Filter Views created to help users find the documents they might be seeking. This works well if the user accesses the library via the native ...
mrpeters's user avatar
0 votes
1 answer
682 views

managed metadata columns and filtering

I use some term sets to be used in columns. The term sets are hiearchically nested with several levels. E.g. Machine Mechanics Frame Bottom Lid Lid bolts Structure Plate 1 Plate 2 Fixture ...
Ariser's user avatar
  • 171
0 votes
1 answer
848 views

How do I create a summary view of a list that can be filtered by dates?

I have a calendar for employees that assigns them to a "work period". Each work period is 12 hours long, and employees are typically assigned to 3 straight days of work periods. The events ...
Chris's user avatar
  • 1
1 vote
2 answers
470 views

How do you filter a SharePoint list based on a current user's email. (Guest users)

I have a modern SharePoint Online Team Site where users that are external to the organization have been granted guest access. There is a list that has a column containing various email addresses ...
Michael Morin's user avatar
2 votes
1 answer
2k views

Multiple sharepoint list column validation in list settings

I am new to SharePoint and Power Automate. I have to put multiple conditions in SharePoint list validation settings. Example: =IF(ISBLANK([Unit Amount]),TRUE,[Unit Amount]=[PO Amount]) Which would ...
neha's user avatar
  • 23
0 votes
0 answers
94 views

Add a filter menu to the list page

I created Sharepoint - List as a stock list. I have a button in the column that sends a request for an item and at the same time adds a reserved flag to the item. As a result of the search, ...
František Dolejší's user avatar
0 votes
1 answer
48 views

Document Library Filter by Metatag to 2nd, 3rd Level

First question from me here, so please go easy on me, if my question is stupid. I'm building a document library in SharePoint for photos, videos and such. For the sake of this example, let's say it's ...
OVOAO's user avatar
  • 1
0 votes
1 answer
83 views

Performance on using hierarchical tasks in a huge task list

We combined multiple task lists into one to overcome different difficulties. This resulted in a task list with about 90.000 items. Upon opening a hierarchical task view with an additional filter on an ...
Urs's user avatar
  • 91
0 votes
1 answer
83 views

Sharepoint column - Calculate number of hours to next day 11AM

In share point lists, How to find if the record was created between 10 AM yesterday to 11 AM today ? Need this for List->View ->Filter and also to check in Power automate to see if the record is ...
skpraveen's user avatar
  • 101
0 votes
1 answer
4k views

Filter Data Table in Power Apps

I'm new to Power Apps and trying to work out something which feels like it should be simple. I have a screen with a text box (txtSearch) and a data table (tblCatalog). The data source for the data ...
JohnLBevan's user avatar
0 votes
1 answer
1k views

How to select multiple values in dropdowns in datatable for Sharepoint 13 list?

I have a list in SharePoint 13. The list is customized using Data table.Currently I have three filters with dropdown option. I want to select multiple option in the dropdown and show the result in the ...
Naidi's user avatar
  • 1
1 vote
1 answer
541 views

SharePoint Current User View using JavaScript

I'm running SharePoint 2013, I would like to have a Current User Filtered View using Javascript. the [Me] would not be feasible because I'm not using the "People Picker" as the field type. I used a ...
JuaP's user avatar
  • 11
1 vote
0 answers
337 views

Infopath form load rule set value filter not working

This is driving me crazy. Super user here (not IT). I have an infopath form tied to populate a sharepoint list. On a field in my form, I have a drop down list. I want to populate that drop down ...
Midwestsusan's user avatar
1 vote
1 answer
24 views

Metadata filtering for a listview webpart

Followed tutorials like this to turn on list metadata filtering. Most of the tutorials I'm finding are form more recent versions of SP, but it worked in our SP 2013 as well. When we have the list ...
Rothrock's user avatar
  • 3,010
0 votes
1 answer
1k views

Filter Choices not showing for single line of Text column in list view in SharePoint 2013

We have a document library in SharePoint 2013 on-premise with nearly 12k items(List View threshold limit was set to 50k items). There is a column with the name Cust Name(Indexed Column) of type Single ...
TARUN's user avatar
  • 2,856
1 vote
1 answer
247 views

Force SharePoint list filters to display alphabetically?

Does anyone know of a way for force the top five filters for each column of a list (before you click See All) to display alphabetically?
Kate's user avatar
  • 13
0 votes
1 answer
651 views

SharePoint list filter based on another list

Thank you for reading I want to create a filtered view based on another list. I plan to have a list with the location of users, and a list where users have to answer a questionnaire. I want the ...
Leonel Guzman's user avatar
0 votes
2 answers
839 views

Filter a Library and multiple Lists on a Page based on the same column (date)

In classic mode a List Filter Web Part is available but what to do in a modern site. Is it still possible to use a classic page in a modern site with the List Filter Web Part? If yes how if no, is ...
JSface's user avatar
  • 57
0 votes
1 answer
25 views

Why filtered views get blown away when edit view is selected?

I am using Modern SharePoint List experience. I am doing following thing. Filtering Items using Modern SharePoint Filter Options. Saving the filtered result as view and it worked. But now when I ...
Aakash Maurya's user avatar
3 votes
2 answers
1k views

In SPO list why would FilterFieldX/FilterValueX work while FilterName/FilterMultiValue is ignored?

I am using a custom list with standard OOB AllItems.aspx view using the modern experience. (NOT a web-part, NOT the classic experience) When I filter using .../AllItems.aspx?FilterField1=...
Peter Bowers's user avatar
2 votes
2 answers
1k views

List "filters pane" works fine for text STARTING WITH. But how to filter on text that CONTAIN words?

In Sharepoint 365 I created a list and by default you can filter with the filter pane. For instant I have a company colum and a company name in ABC International. I want to filter for all compies with ...
LucAna's user avatar
  • 51
0 votes
2 answers
1k views

SharePoint Online - Using [Me] filter for Multi line text column doesn't work

I am on SP Online environment. I have a list with multiple columns. One of the column multi line text column (Approvers) has multiple users of below format. Approvers: User1; User2; User3; User4; ...
AXA240778's user avatar
  • 499
1 vote
1 answer
293 views

SharePoint List Filter WebPart - Advanced Filter Options - Empty values

I want to connect a SharePoint List Filter Web Part to a List View Web part and use the feature to enable users to filter by a null value. In the Advanced Filter Options section, I selected "(Empty)" ...
SMART's user avatar
  • 31
0 votes
0 answers
23 views

Traffic Light Indicator Filter

I already created a traffic light indicator column for a SharePoint list. When I clicked on the column to filter, the options shown as the HTML code. My question here is how do I have the filter ...
Skyy Tran's user avatar
0 votes
1 answer
31 views

Sharepoint create a view for the month of april and march in a list

we need to know how many items are there for the due date column (DueDate) for the month april and march how do we setup a view which shows the number of items for each month ? any help would be ...
Pradeep's user avatar
  • 503
0 votes
1 answer
310 views

Display Query String filter in page

I have query string filter like: Lists/DIIS/Master%20List.aspx?Modality=CT. I would like to display Modality=CT somewhere on the page (not the title since I hide the title). Is there a way to use ...
marco's user avatar
  • 47
1 vote
1 answer
312 views

Versioning History filter

Is there any way to add a filter like we have on a normal list on Sharepoint Online? Version History: Normal list:
CSAnimor's user avatar
  • 219
3 votes
1 answer
1k views

OOTB SharePoint List Filter web part on Yes/No type field

I have one custom list with Yes/No type field in our SharePoint site(tried both on 2013 and 2016 on premise). I did below steps: Created one page. Added OOTB SharePoint List Filter web part on Yes/...
Ganesh Sanap - MVP's user avatar