Questions tagged [sharepoint-list-filter]
The sharepoint-list-filter tag has no usage guidance.
42
questions
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/...
- 36.7k
2
votes
2
answers
969
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=...
- 141
2
votes
2
answers
735
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 ...
- 51
2
votes
1
answer
950
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 ...
- 23
1
vote
1
answer
955
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 ...
- 113
1
vote
2
answers
304
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 ...
- 11
1
vote
2
answers
342
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 ...
1
vote
1
answer
444
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 ...
- 11
1
vote
0
answers
251
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 ...
- 11
1
vote
1
answer
22
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 ...
- 2,898
1
vote
1
answer
188
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?
- 13
1
vote
1
answer
172
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)" ...
- 31
1
vote
1
answer
207
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:
- 219
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; ...
- 489
0
votes
2
answers
191
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 ...
- 149
0
votes
1
answer
341
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 &...
- 113
0
votes
1
answer
411
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
...
- 171
0
votes
1
answer
867
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 ...
- 2,816
0
votes
1
answer
24
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 ...
- 8,449
0
votes
1
answer
25
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 ...
- 483
0
votes
1
answer
17
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 ...
0
votes
0
answers
37
views
Filter Microsoft List by week and show items that fall into multiple weeks
Hi I currently have a Microsoft list that has a week start and week end date columns. I have items that run through multiple weeks, but I want them to show in each week in filtering or grouping.
For ...
0
votes
1
answer
35
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 ...
- 39
0
votes
1
answer
40
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 ...
- 11
0
votes
1
answer
38
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 "...
0
votes
1
answer
48
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 ...
- 131
0
votes
1
answer
41
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 ...
- 1
0
votes
1
answer
488
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 ...
- 1
0
votes
0
answers
130
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 ...
- 1
0
votes
1
answer
435
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 ...
0
votes
1
answer
62
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 ...
- 1
0
votes
1
answer
321
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 ...
- 1
0
votes
0
answers
48
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, ...
0
votes
1
answer
41
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 ...
- 1
0
votes
1
answer
53
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 ...
- 91
0
votes
1
answer
72
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 ...
0
votes
1
answer
3k
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 ...
- 187
0
votes
1
answer
792
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 ...
- 1
0
votes
1
answer
507
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 ...
0
votes
2
answers
716
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 ...
- 57
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 ...
0
votes
1
answer
160
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 ...
- 47