Questions tagged [filter]
A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.
822
questions
0
votes
0answers
9 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....
0
votes
1answer
14 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 ...
0
votes
0answers
23 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: ...
2
votes
3answers
34 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 ...
0
votes
0answers
6 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&...
0
votes
0answers
36 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 ...
0
votes
1answer
70 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 ...
0
votes
1answer
42 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 ...
1
vote
0answers
18 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 ...
0
votes
2answers
351 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 = "...
0
votes
1answer
16 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 ...
0
votes
2answers
26 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 ...
0
votes
1answer
114 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 ...
1
vote
2answers
103 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,...
1
vote
2answers
31 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 ...
0
votes
1answer
36 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 ...
1
vote
1answer
15 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 ...
1
vote
0answers
116 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)(...
0
votes
1answer
46 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 ...
1
vote
1answer
17 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 ...
1
vote
1answer
61 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 ...
0
votes
1answer
18 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?
0
votes
1answer
56 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 ...
2
votes
1answer
218 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 ...
1
vote
3answers
262 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:
...
0
votes
1answer
36 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 ...
0
votes
2answers
31 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 ...
0
votes
1answer
496 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 ...
1
vote
1answer
22 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 ...
0
votes
1answer
136 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 ...
0
votes
3answers
52 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>&...
0
votes
1answer
18 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?
2
votes
2answers
61 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, ...
1
vote
1answer
210 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 ...
0
votes
1answer
417 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 ...
0
votes
1answer
602 views
Querying a sharepoint list with more than 5000 records returned while supporting sorting and filtering
We are facing some problems dealing with large list on SharePoint online via API, we tried below methods but no luck, please advise if there is a proper way to handle such cases.
Requirements
...
0
votes
1answer
406 views
SharePoint Online 'Filter By' not showing all available options
I have created a custom list which contains around 32,000 items. There is a 4 part key which looks something like 'T1-0000-X-XX'. Each part has a meaning. In order for users to be able to filter by ...
0
votes
1answer
39 views
SharePoint List View Complex Filter Logic
I'm creating a SP list view and trying to apply a filter to it without creating calculating columns to compare:
Show items only when the following is true:
Status equals to "Cancelled" AND ...
0
votes
1answer
69 views
Sharepoint REST API - Filter by Negative Number
I'm trying to filter by a negative number but it only seems to work with zero or positive. Does anyone know how to fix this? My query is below:
spUrl + '/SitePages/checklist.aspx?filter=ChecklistID/...
1
vote
1answer
380 views
View only Folder items
Can someone explain to me why this is not working (and how to make it work)?:
Steps to reproduce :
Go to a folder in all document view > edit current view > click show items only when the ...
3
votes
1answer
97 views
Link Document Library to Search Filter
I have a SharePoint Content site which also has a document library. The document library has columns that classify the document. I am trying to (on the homepage of the content site) add a Search ...
0
votes
2answers
621 views
Filter a list by User or Group column in CAML Query
Is there a way to filter a list by User or Group column?
I need to get all the tasks assigned to each user in a site.
I got the below code for now, but that only works if I'm trying to get my tasks.
...
0
votes
1answer
52 views
Date column grouping header links to page with date format incorrect and no results shown
I have a SharePoint Online list using the Modern view that I have grouped by a date column. When showing the list of groups everything appears fine. However, when I click the group header to view all ...
0
votes
1answer
24 views
How do I make the "Created by [Me]" filter work after saving a list as a template
I created a list from a template where one of the views is filtered using the "[Me]" value of the "Created By field" so users can only view their entry and their entry only. Now, in the new list I ...
1
vote
1answer
54 views
Filtering Sharepoint Server 2013 list with multiple "OR" column view filters above the 5000 item threshold
I have a list that's butting up against the 5000 item threshold and I've added a couple of dummy items so I can experiment with the threshold before I cross over with real data. My list is structured ...
0
votes
1answer
295 views
Microsoft Graph Change contentType of uploaded file and filter
I have a VBA macro I'm using to interface with the graphAPI to upload a ton of files to SharePoint Online.
That's working fine.
The issue is changing the contentTypes after the fact. I'm using the ...
0
votes
1answer
147 views
Filter tiles view of a Document Library in modern sharepoint
I have a document library in a modern SharePoint on which I use custom formatting to customize the tiles view. The library contains leaning material for the users in different languages.
The document ...
0
votes
1answer
36 views
Rest query, get values IN a collection
I would like to get the items whose field A is IN (X,Y,Z...).
I've seen ways to do it with ORs (Rest API - $filter multiple values) but is there a simpler way?
Something like:
/_api/web/lists/...
0
votes
1answer
214 views
Filtering large list (more than 5K items) using two columns with REST API
I have a list which has more than 5K items in it and I need to filter it by using multiple columns. Below is the challenge that I am facing.
Scenario 1: Below REST API fails with Microsoft.SharePoint....
1
vote
1answer
215 views
How can we sort the filter options in the information panel?
Head scratcher here. I'm wondering how/if we can change the display order of choice options in the filter info pane. Does anyone how to do this, or even better, why this appears to be an order set at ...
