Skip to main content

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
0 votes
1 answer
14 views

SharePoint Document Library - Column Filters - Search Bar Not Available

I have a document library with a "Topics" column that contains various tags describing the document. The list of manually entered tags is now quite long. When clicking the column header, ...
Andy Garcia's user avatar
0 votes
0 answers
38 views

Graph API to filter by multi-choice person column (SharePoint)?

How to filter by a multi-choice person column's Email (SharePoint)? I tried this format by referring to Graph filter method, and it's not working &$filter=fields/RequestorDetails/any(x:x eq 'name2@...
kartrabby's user avatar
0 votes
1 answer
31 views

Power Automate Flow - Send an email if a SharePoint 'Proposal Date' Column = the current month

I have a SharePoint list with a proposal date column (SP column name is ProposalDate). I want to manually run a flow that will query the entire list, identify items with a Proposal Date this current ...
Chris's user avatar
  • 409
0 votes
2 answers
64 views

SharePoint List View [Me] Filter stopped working

We are using SharePoint Modern experience and have a view that filters all our tasks to display only those that are assigned to the person currently logged in. We use the [Me] keyword on a person/...
Giovanna Pirillo's user avatar
0 votes
1 answer
63 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,429
0 votes
0 answers
18 views

How to set the filter values for a list web part in JavaScript

I created a modern experience site page in SharePoint 2019 on-premises site, and built a tree view web part on the site page. I want to set the filter for another five list web parts on the same site ...
Elton Potato's user avatar
1 vote
1 answer
135 views

Can I add more than 10 filters to a SharePoint view?

Am I capable of increasing the maximum number of filters available in a view? It seems to cap out at 10, and I haven't found anything in the documentation about how many filters you can add:
carrot's user avatar
  • 11
2 votes
1 answer
65 views

SharePoint Online Filter By URL

I am working with the SharePoint API and trying to filter search results based on specific URLs. Currently, I have the following search query: http://www.test.com/_api/search/query?querytext=%27Hello%...
Jedi's user avatar
  • 23
1 vote
1 answer
145 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
1 answer
197 views

Filter a SharePoint list by URL parameters and OR combining filters

my goal is to create a URL that filters a SharePoint list with two filters that are logical OR combined. What I have so far is: AllItems.aspx/? useFiltersInViewXml=1 &FilterFields1=Data1 &...
Finn's user avatar
  • 103
3 votes
1 answer
212 views

Best practices to improve search-ability in SharePoint Online and prepare for AI usage - how to handle meta data and alternative search terms?

I have an intranet article in SharePoint and want to increase the chance that users are able to find it when they use the search feature (or future chat feature). For example the title of the article ...
Stefan's user avatar
  • 141
1 vote
1 answer
107 views

How to filter a list by date > [TODAY]

I have a list for some enterprise events, but I encounter difficulties when attempting to create a view for future events only. The list contains a date_event column which is in the default format, ...
jgran's user avatar
  • 13
0 votes
1 answer
268 views

Clear SharePoint filter after entering folder

This is my first time posting, so I'll do my best. I have reviewed similar problems, but can't find any answers that solve the issue. I have a document library that has metadata columns, that when ...
David's user avatar
  • 3
0 votes
0 answers
13 views

Is it possible to add custom filters from a custom column when searching on SharePoint site?

I have only found a way to add vertical site-level filters. Is there a way to add filters as shown below? We have many marketing reports with a publish date (we created a custom column to categorize ...
Megan Liu's user avatar
1 vote
1 answer
171 views

Document library view filter not working

I have 3 columns: Type (choice field) Comments (text field) Status (yes/no) I need documents in my library to show in this view if the type is "choice 1", the comment column is empty and ...
xUIx456's user avatar
  • 11
1 vote
0 answers
61 views

PowerApps - Two Lookup Columns Issue

I have a canvas app connected to a SharePoint list that contains 2 Lookup columns: Name and Code. There are about 600 line items. In the app I have these two fields side by side, and basically want ...
Chris's user avatar
  • 409
1 vote
1 answer
193 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
1 vote
1 answer
885 views

Updating SharePoint Filters in Specific Views

I created and saved a view within SharePoint that had filters applied on a specific column. I now want to add additional values into the filtered view, however it appears to still only show the ...
Fiona Donaghy's user avatar
1 vote
1 answer
2k views

Using $filter eq query on list items using the msgraph-sdk-java

We have a SharePoint list of items where we would like to filter on a specific field (i.e. EMail = [email protected]) to create a list of entries. We are getting 400 errors saying invalid filter ...
Shannon Quinn's user avatar
1 vote
1 answer
75 views

Filtering out options with identical text strings

One of my SharePoint lists contains a choice column the allows for multiple selections (i.e., a checkbox list.) It's used to identify legislation relevant to the list item, and often multiple pieces ...
Taylor's user avatar
  • 11
1 vote
0 answers
91 views

How to Pin Columns to the Filters Pane. (Pnp.PowerShell)

https://sharepointmaven.com/how-to-add-custom-metadata-columns-to-the-filters-pane-in-sharepoint-online/ Refer to step 5 of this webpage. Can it be implemented using PowerShell?
Charlotte.HonG's user avatar
1 vote
1 answer
44 views

Where does SharePoint 2019 store filtering of columns?

When you click on the column header and then you click on "Filter by", a pane opens on the right and there you can select options to filter. I would like to know where does SharePoint store ...
user20377051's user avatar
0 votes
1 answer
4k views

Filter Query with Rest API (Internal Name or New Name)

I am making a fetch to retrieve information from a SharePoint list that meet a certain criteria. I need the EndDate to be greater than or equal to todays date. I also need to other columns to equal a ...
BeerusDev's user avatar
  • 113
0 votes
2 answers
478 views

Contain function with double quotes

I need to find a string which has double quotes (") in it: "userId": "xyz-bdd2-06870916684f" within another string to use it as condition in a filter action. The userId is ...
Der_Fab's user avatar
  • 187
0 votes
0 answers
1k views

It's possible to filter SP Modern Page Content with URL params?

The challenge here is to get filters applied to certain content (on SPO-OOTB or PnP Modern Search v4 webparts) via URL params. Query String URL Tricks for SharePoint and Microsoft 365 https://docs....
fallout's user avatar
  • 1,015
0 votes
1 answer
3k views

Filtering question with using Modified column when is equal to todays date - Power Automate

I'm trying to filter a list using Get Items in power automate. Something like this: Modified eq 'TodaysDate' But the modified field date has got a date and time and my TodaysDate filed has only date. ...
naijacoder's user avatar
  • 4,294
1 vote
0 answers
12 views

Filter list web part on site page for references to that site page

I have a Site Pages library and a Glossary list. In the Glossary list, I added a lookup column to the Site Pages library (allowing for multiple values). I am essentially looking to "tag" ...
regerror6's user avatar
0 votes
2 answers
634 views

Can we default the filter pane to be turned in SharePoint Online?

I want to be able to globally have the filter pane turned on in SharePoint online. Is there a library setting that sets this? I did not see a way to do this after looking at all the options. It ...
Eric's user avatar
  • 105
1 vote
2 answers
616 views

filter by color after adding conditional formatting

If you create conditional formatting on a column in SharePoint list that is dynamic, say for example all dates before today are red, today is green and dates after today are amber, is there a way to ...
Jennifer's user avatar
0 votes
1 answer
415 views

SharePoint REST API Query is Not Valid

I am trying to filter a list by multiple different columns, and then when I add the array filter towards the end, it tells me that the query is not valid. I have tried two different methods which are ...
BeerusDev's user avatar
  • 113
1 vote
1 answer
567 views

SharePoint List Filter Query By UTC Date Not Valid

I am having an error with my filter with other people located in separate time zones. It was recommended to me to switch to filtering with a UTC date instead of an ISO date and that should fix the ...
BeerusDev's user avatar
  • 113
0 votes
1 answer
142 views

Dynamic Filtering on Non-Default View of Document Library

Is it possible to filter a Document Library by a List without going back to the default view prior filtering? I have 2 views, one for Current Year documents and the other containing All documents. ...
sabog's user avatar
  • 5
0 votes
1 answer
86 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
0 answers
11 views

create a new visualization calendar with filter by membership

A need show events on calendar using filter membership using camlQuery. Can i replace the ListViewXml on the aspx? i use javascript on the sharepoint designer.
Luciano damasceno's user avatar
0 votes
1 answer
3k views

Filter or populate choice/lookup column based on another list without Power Apps? Or format column based on another list?

I'm working on a project where I have a main list called "Requests". It includes a "Course" column (pre-populated) and a "School" single-value choice column. I want to ...
Darryl's user avatar
  • 146
0 votes
0 answers
143 views

ODATA Filter for lists/libraries using TemplateFeatureId guid property

24Hrs into learning about OData queries for a SP project that was dumped on me. I can get the data i need from _api/web/lists?$select=Title,TemplateFeatureId,Author&$expand=Author But I tried to ...
Grant Coghlan's user avatar
0 votes
1 answer
2k views

Add custom column to PNP Search filter web part

I am working on PNP Modern Search v4 web part inside our SharePoint Tenant from this URL - https://github.com/microsoft-search/pnp-modern-search/releases/tag/4.4.1. I have tried to use search box, ...
selam's user avatar
  • 1
0 votes
2 answers
44 views

Filter by group but showing percentage instead of number

Is it possible to filter a list by group and showing percentage instead of numbers? I know we can group by a list by some column but it shows no. of records. Is it possible to show percentage? I am ...
Frank Martin's user avatar
  • 3,702
1 vote
2 answers
2k views

SharePoint REST API List View Threshold

I have a SharePoint List with over 5000 records created by me. The below query when using ID in filter works. But when I Filter With CreatedBy me it gives me List View Threshold Error. Error: _api/...
Joy D'souza's user avatar
0 votes
0 answers
2k views

Exclude groups in office 365 users search PowerApps

I am creating a people picker in the PowerApps using Office365Users connection. I am able to filter the users using the below format. Filter(Office365Users.SearchUser( {searchTerm:cmb_Office365User....
TARUN's user avatar
  • 2,856
0 votes
1 answer
23 views

How to filter approvers based on location?

I am using SharePoint On-Prem 2019 and have Nitro Studio hosting my sites. One site I have manages the purchasing system, and I would like to filter the approvers based on location. I already have ...
Dan C.'s user avatar
  • 1
2 votes
3 answers
279 views

Filter View on [Today] and also include blanks

I'm trying to set up a way of filtering one of my list views and struggling a bit. The first 3 filters are working fine to show the entries with only a date of today or later but when I use the final ...
lozzeroooni's user avatar
0 votes
1 answer
944 views

Filter array of objects based on multiple properties/conditions

I have 5 items in a list that is being retrieved and stored in an array using RestAPI. The end goal here is to filter the array of objects based on 4 conditions(4 columns). 2 List items have the exact ...
Vivek's user avatar
  • 37
0 votes
1 answer
315 views

Average score per student in a Sharepoint list

I have a SharePoint list which is a feedback score dump from PowerApps. The PowerApps has a drop down to select which student email(out of many) they are scoring. Every entry is a new row in the ...
RJoseph's user avatar
1 vote
0 answers
431 views

Get recently added / updated users from Azure Active Directory

I want to fetch all the users from Azure Active Directory who are recently modified/added using Graph API SDK. I tried to search for the lastModified, or Modified property which returns the last ...
Dhruvil Prajapati's user avatar
1 vote
2 answers
3k views

what filtering options are supported MS graph api (List used) - Javascript?

I'm working on a script and I can call the below Graph API endpoint. https://graph.microsoft.com/v1.0/me/insights/used without any issue. But I would like to use filter like so: var srchStr = "...
naijacoder's user avatar
  • 4,294
0 votes
1 answer
324 views

How to select ALL matching results of a filter in a document library (not just those displayed on the user's screen)?

Desired Behaviour Filter items in a Document Library by Column title Click Select All icon ALL items that match the filter are selected (not just those displayed on the user's screen) The desired ...
user1063287's user avatar
0 votes
2 answers
796 views

How to subtract years from a date in a view filter in SharePoint?

In SP2013 view filters, if I want to subtract say a week from today I can do [Today]-7 which works. But I want to remove 30 years, which is [Today]-10950 however it complains that the date is not in a ...
omega's user avatar
  • 2,160
1 vote
1 answer
5k views

SharePoint REST api SPQueryThrottledException

Wondering if anyone can help with an issue I am having with the SharePoint REST API. I currently have a Power Automate flow that runs on a daily schedule, this uses the 'SharePoint HTTP' action to get ...
Adam13Hylo's user avatar
1 vote
2 answers
2k views

How to filter items with a date range using query parameters of Render list data as stream rest api? [closed]

Microsoft Documentation is providing filter operator which takes greater than, less than or equal to but it is working? RenderListDataAsStream URI parameters The documentation says we can use filterOP,...
Ram Girish Karri's user avatar

1
2 3 4 5
18