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
2 answers
15 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 ...
user avatar
0 votes
1 answer
27 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 ...
user avatar
  • 103
0 votes
0 answers
24 views

display filter pane on list view or HCWP on sharepoint online

im using sharepoint online. My goal is to always display filter pane so that customer can use it. Is there a way to expand the filter pane by default to a SharePoint document library? In the same way ...
user avatar
1 vote
1 answer
142 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 ...
user avatar
  • 103
0 votes
1 answer
25 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. ...
user avatar
  • 5
0 votes
1 answer
21 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
9 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.
user avatar
0 votes
1 answer
444 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 ...
user avatar
  • 114
0 votes
0 answers
29 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 ...
user avatar
0 votes
0 answers
188 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, ...
user avatar
  • 1
0 votes
0 answers
50 views

SharePoint List Filter - and/or condition? Search box?

the users wish for and/or filter conditions to apply on a SharePoint list. Example Filter-search 1 (multiple columns connected with 'or': Either column "Active" can be set on "yes" ...
user avatar
  • 1
0 votes
0 answers
7 views

New's post calculation

There are hundreds of different News Post pages in our Sharepoint site and we need to calculate how many are there. Also they have different target audiences assigned and would be nice to also see/...
user avatar
  • 23
0 votes
0 answers
22 views

Issues with filtered list in SharePoint?

The full question is more along the lines of preventing someone from adding a filter to a list since that seems to "hold" the filter within the the list on SharePoint for everyone. Or is ...
user avatar
0 votes
2 answers
14 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 ...
user avatar
  • 3,614
0 votes
1 answer
244 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/...
user avatar
0 votes
0 answers
504 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....
user avatar
  • 2,818
0 votes
1 answer
17 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 ...
user avatar
  • 1
0 votes
0 answers
74 views

Difference between MS Graph API and SharePoint REST API in filtering

While working with MS Graph I noticed that if I need to filter list items by custom fields, I had to make this field indexed, or work with header attribute: Prefer: allowthrottleablequeries or Prefer: ...
user avatar
  • 1
2 votes
3 answers
51 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 ...
user avatar
0 votes
0 answers
7 views

Search doesn't work in Browser Gallery

SortByColumns(Filter(Search(AddColumns(Journals,"FlatClientName", Text('Client Name'.Value),"FlatTrainerName", Text(Trainer.DisplayName)),TextSearchBox1.Text, "FlatClientName&...
user avatar
0 votes
0 answers
48 views

How do you set dynamic filtering on with 2 list web parts in SharePoint online using PnP PowerShell?

How do you set dynamic filtering on with 2 list web parts in SharePoint online using PnP PowerShell? I have the below web parts added to a page, I would like to filter the second one by one of the ...
user avatar
0 votes
1 answer
496 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 ...
user avatar
  • 37
0 votes
1 answer
74 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 ...
user avatar
1 vote
0 answers
45 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 ...
user avatar
1 vote
2 answers
1k 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 = "...
user avatar
  • 4,100
0 votes
1 answer
25 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 ...
user avatar
0 votes
2 answers
189 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 ...
user avatar
  • 2,140
0 votes
1 answer
822 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 ...
user avatar
1 vote
2 answers
740 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,...
user avatar
1 vote
2 answers
40 views

Filtering items in SharePoint list view

I've got a SharePoint list with the following columns: City: eg. London, New York, Milan Visit Type: Business, Leisure Date: date visited There could be multiple city visits of the same type, but ...
user avatar
0 votes
1 answer
57 views

SPO filter webpart with folders

Our customer has a document library with a big folder structure in SharePoint Online (classic). We need to display that library as a web part filtered by a specific metadata in another page. That's ...
user avatar
1 vote
1 answer
24 views

SharePoint 2013 List View items permission

There is one SP list (on SP 2013 Foundation) for all users to create their entries (items). Users have their individual departments columns, updated from users' profile details using workflow. I want ...
user avatar
1 vote
0 answers
293 views

SharePoint 2019: filter users and groups in People Picker with ActiveDirectoryCustomFilter

We are currently trying to filter the People Picker in SharePoint 2019 for users and groups, but we have a little bit of trouble. Currently, we have the following filter: (&(objectCategory=person)(...
user avatar
  • 175
0 votes
1 answer
232 views

Filtering news posts with a dropdown

I want to be able to filter news posts based on custom meta data, using a dropdown. I want all news posts to display in a list by default, but be able to choose a category from a dropdown and then ...
user avatar
  • 101
1 vote
1 answer
19 views

More than one value in a same field

I want to make a view in which I see only the minor versions (X.1, X.2, X.3, etc.) There is no way I can do that. Filtering the versions by « contains = .1 » doesn't work. And I only have 10 possible ...
user avatar
1 vote
1 answer
250 views

Filter a document library from a list

I have a list and a document library that I'd like to link. I would love to be able to have a link in the list that would search the document library based on a specific field. Example: The list ...
user avatar
0 votes
1 answer
401 views

I want to put a filter on a view that only shows the records from today

I have a list with a date column and 3 other columns. I want to put a filter on a view that only shows the records from today. How can I do that?
user avatar
0 votes
1 answer
157 views

filter column with last 4 digits using restapi

We have a column where the values are stored as '1002859817' and the Field Type is single line of text. The end goal here is to filter the column based on the last 4 digits i.e. '9817' Tried the ...
user avatar
  • 37
2 votes
1 answer
794 views

"Get Items" returning incomplete list of items in Power Automate

This has been a maddening problem for a few weeks now and I can't seem to find the cause. I have a flow that simply needs to get the items from a list and filter them based on a field. I've tried this ...
user avatar
  • 2,660
1 vote
3 answers
768 views

Dynamic filtering using lists, hide information until selected

New to this forum, tried searching without any luck. I wish to hide information from a list until a selection has occurred. I'm using dynamic filtering. Example I got two lists (List1, List2) List 1: ...
user avatar
  • 11
0 votes
1 answer
60 views

Create a view Filter SharePoint list for items I - [Me] - haven't rated

Is there a way to filter (and subsequently create a view for) a SharePoint list to show items that the current user hasn't rated? For example, in the list below I would like to create a view that ...
user avatar
0 votes
2 answers
46 views

Pass parameters to external list on SP2019 Standard

I have an external list that is displaying data from a SQL Server view. Now, I want to add filtering. The problem is that I'm working on Standard version of Sharepoint, so no Enterprise webparts are ...
user avatar
  • 297
0 votes
1 answer
904 views

Filtering listview using React Sharepoint

I am trying to display data in react-data-table-component according to the input given in the search field using Rest API. For eg: If a user enters name of the person the react-data-table-component ...
user avatar
1 vote
1 answer
41 views

Filter data based on Taxonomy value [closed]

I am building a search web part in which, I am filtering the data from the SharePoint document library based on the value in the skillset column. It is a managed metadata column. Below is the ...
user avatar
0 votes
1 answer
377 views

Filter list by Author (Created By) field with rest api - SP Online 2019

So I'm sending a REST query like: _api/web/lists/GetByTitle('List')/getitems?$select=AuthorId It works fine, I see 49 records with AuthorId. Now I want to filter by this column. Then I want to filter ...
user avatar
  • 43
0 votes
3 answers
229 views

Add multiple Fields For the CamlQuery in Sharepoint Hosted App

I am trying to filter two fields or more that is clean of null values. It works for the first field but it is not working for the second field: <View><Query><Where><IsNotNull>&...
user avatar
  • 1
0 votes
1 answer
21 views

All columns not present in create view filter option

Trying to create a view which filters a specific columns with hyperlinks in it. I went to create view --> filter and that column does not appear in the drop down. Any ideas?
user avatar
2 votes
2 answers
121 views

(another take on) Filtering Sharepoint view based on date range

I know that the answer for this question is easy to find on the internet, including this thread - but the suggested solution doesn't work for me. I need to create a view in a Sharepoint online list, ...
user avatar
1 vote
1 answer
371 views

Sharepoint online -- managed metadata term set filter not working

Novice user here. We have created a list of products on sharepoint online. Products are tagged using a managed metadata term set. We would like to use this to either A) filter the list and save views ...
user avatar
  • 111
0 votes
1 answer
1k views

Tagging news and filter them afterwards

Currently I´m trying to figure out whether is it possible to tag my news with a # or something else and then to create a news feed where every user can filter individualy by them self the news ...
user avatar
  • 1

1
2 3 4 5
17