Questions tagged [filter]
A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.
845
questions
0
votes
0
answers
14
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?
1
vote
1
answer
18
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 ...
- 11
0
votes
0
answers
10
views
using search(q='{search-text}') or ?$filter=contains(name,'search-text') in a folder of a drive
I would like to search for files in a drive within a folder. If I use
https://graph.microsoft.com/v1.0/drives/{driveId}/root/search(q='searchText') this works fine but I have a folder inside this ...
- 1
0
votes
1
answer
39
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 ...
- 107
0
votes
0
answers
22
views
How to build summary page of data from other lists filtered by a certain item/document?
I am looking for a way in SharePoint Online to build a summary page where an item is displayed at the top and a couple other lists/libraries are shown below with items/docs filtered by the item at the ...
- 371
0
votes
2
answers
66
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 ...
- 149
0
votes
0
answers
205
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....
- 1,005
0
votes
0
answers
14
views
CAML filter in library: check group membership not based on a field value
I have currently a list which I would like to filter.
The filter clause would be something like this in pseudo code :
If CurrentUser is member of GroupAdmin then show library item
Or If CurrentUser is ...
- 1
0
votes
0
answers
26
views
Filter array within array
I used the Select-action to create an array of planner tasks from a planner board.
I managed to filter the information by bucketID to get only the tasks from a specific bucket.
Now I'm trying to ...
- 149
0
votes
1
answer
254
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.
...
- 4,148
1
vote
0
answers
11
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" ...
- 11
0
votes
1
answer
75
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 ...
- 103
1
vote
2
answers
97
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 ...
- 11
0
votes
1
answer
126
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 ...
- 107
0
votes
0
answers
45
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 ...
1
vote
1
answer
298
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 ...
- 107
0
votes
1
answer
34
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. ...
- 5
0
votes
1
answer
30
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
0
answers
10
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.
0
votes
1
answer
2k
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 ...
- 114
0
votes
0
answers
79
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 ...
0
votes
1
answer
447
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, ...
- 1
0
votes
0
answers
85
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" ...
- 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/...
- 23
0
votes
2
answers
18
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 ...
- 3,614
1
vote
1
answer
556
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/...
- 148
0
votes
0
answers
846
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....
- 2,818
0
votes
1
answer
20
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 ...
- 1
2
votes
3
answers
68
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 ...
- 23
0
votes
1
answer
617
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 ...
- 37
0
votes
1
answer
114
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 ...
- 3
1
vote
0
answers
108
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 ...
- 2,227
1
vote
2
answers
2k
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 = "...
- 4,148
0
votes
1
answer
59
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 ...
- 156
0
votes
2
answers
345
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 ...
- 2,140
1
vote
1
answer
2k
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 ...
- 646
1
vote
2
answers
1k
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
2
answers
41
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 ...
- 133
0
votes
1
answer
74
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 ...
- 25
1
vote
1
answer
26
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 ...
- 11
1
vote
0
answers
450
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)(...
- 175
0
votes
1
answer
373
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 ...
- 101
1
vote
1
answer
20
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 ...
- 11
1
vote
1
answer
332
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 ...
- 13
0
votes
1
answer
843
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?
- 219
0
votes
1
answer
223
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 ...
- 37
2
votes
1
answer
1k
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 ...
- 2,660
1
vote
3
answers
1k
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:
...
- 11
0
votes
1
answer
79
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 ...
- 1
0
votes
2
answers
54
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 ...
- 297