Questions tagged [sharepoint-list-filter]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
25 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 ...
user avatar
1 vote
1 answer
92 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 ...
user avatar
  • 103
0 votes
1 answer
9 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 ...
user avatar
1 vote
1 answer
42 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 ...
user avatar
  • 11
0 votes
1 answer
22 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 "...
user avatar
0 votes
0 answers
22 views

How to display all lists and filter for empty columns?

I'm new to Sharepoint and hope you can help me. I need to make a "inventory analysis" of our customers Sharepoint lists and export them to Excel. I want to access this data via the ...
user avatar
0 votes
1 answer
28 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 ...
user avatar
  • 131
0 votes
0 answers
28 views

How to filter Sharepoint list through Visio diagram

I would like to create a SP Page with 2 web parts: a Visio diagram and a list. The list should be filtered based on the shape the user click at. I'm using Visio Professional 2016. All examples I have ...
user avatar
  • 1
0 votes
0 answers
13 views

Office 365 SharePoint list - filtering and updating specific column values using URL

As the title explains briefly, I want to add a URL to an email body, that when the user clicks it, it will apply a filter in a column of a Office 365 SharePoint list (that part is fine), and update ...
user avatar
0 votes
1 answer
33 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 ...
user avatar
  • 1
0 votes
2 answers
60 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 ...
user avatar
  • 129
0 votes
1 answer
159 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 ...
user avatar
0 votes
0 answers
26 views

Filter link items from list using Page destination column and site Page name

I have a request from a client to use an link library (list) for multiple pages, the idea is to have one link library where you can put a name of a page destinaton, i.e.: Link Icon: "redfolder&...
user avatar
0 votes
1 answer
139 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 &...
user avatar
  • 103
0 votes
0 answers
97 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 ...
user avatar
0 votes
1 answer
243 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 ...
user avatar
0 votes
1 answer
46 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 ...
user avatar
0 votes
1 answer
168 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 ...
user avatar
  • 171
0 votes
1 answer
88 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 ...
user avatar
  • 1
1 vote
2 answers
206 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 ...
user avatar
2 votes
1 answer
451 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 ...
user avatar
  • 23
0 votes
0 answers
33 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, ...
user avatar
0 votes
1 answer
34 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 ...
user avatar
  • 1
0 votes
1 answer
33 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 ...
user avatar
  • 91
0 votes
1 answer
65 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 ...
user avatar
0 votes
1 answer
2k 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 ...
user avatar
0 votes
1 answer
317 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 ...
user avatar
  • 1
1 vote
1 answer
322 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 ...
user avatar
  • 11
1 vote
0 answers
195 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 ...
user avatar
1 vote
1 answer
21 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 ...
user avatar
  • 2,959
0 votes
1 answer
687 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 ...
user avatar
  • 2,818
1 vote
1 answer
142 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?
user avatar
  • 13
0 votes
1 answer
381 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 ...
user avatar
0 votes
2 answers
667 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 ...
user avatar
  • 57
0 votes
1 answer
23 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 ...
user avatar
2 votes
2 answers
819 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=...
user avatar
2 votes
2 answers
443 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 ...
user avatar
  • 51
0 votes
2 answers
982 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; ...
user avatar
  • 489
1 vote
1 answer
125 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)" ...
user avatar
  • 31
0 votes
0 answers
22 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 ...
user avatar
0 votes
1 answer
23 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 ...
user avatar
  • 473
0 votes
1 answer
115 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 ...
user avatar
  • 47
1 vote
1 answer
154 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:
user avatar
  • 209
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/...
user avatar
  • 28.2k