Skip to main content

Questions tagged [sorting]

Sorting is any process of arranging items in some sequence by arranging items of the same kind, class, nature, etc. in some ordered sequence.

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 views

Resturn results items by sorting by nearest location

I got managed properties crawled (in sp2016) of the Lat and Long coordinates of our offices location. I trying to het the nearest location to given coordinates by using rest api query. I using ...
Adleron's user avatar
  • 53
0 votes
1 answer
15 views

Struggling to Filter & Sort

In PowerApps, I have a Screen that displays a few SharePoint lists depending on the selection from the prior screen. On the Gallery in question, the only formula I have in the Items box is this: ...
Will's user avatar
  • 1
0 votes
0 answers
19 views

SharePoint Online List - Sort by Multi select People Column

I have a requirement to sort a SharePoint Online list by a people column called "Owner". The issue is that this is a multi-select people field. Does anyone have a suggestion for how I can ...
Chris's user avatar
  • 409
0 votes
0 answers
37 views

Graph search query: total results differs between pages

I'm encountering this issue: calling the POST /v1.0/search/query Graph API, with the following body: { "requests": [ { "entityTypes": ["listItem"],...
caneta's user avatar
  • 103
1 vote
2 answers
1k views

How to sort text field with first two digit numbers

I have below current order in my default column (LinkFilename). I want require orders mentioned in below. How we can do this? Current Order: 1_Project Management 10_Prototyping 11_Marketing ...
Harish Patil's user avatar
1 vote
1 answer
828 views

Sort based on multiple columns in Search API

We are using search API. We have a large dataset so we are using the below approach for pagination. https://docs.microsoft.com/en-us/sharepoint/dev/general-development/pagination-for-large-result-sets ...
vaishali's user avatar
0 votes
1 answer
172 views

Send Rest API's Post Query which should be Sorted by formula

I am trying to send a request using SharePoint 2013 Rest API (POSTQUERY) and my sort-list is a formula. When I am sending a GET request, it works fine as mentioned in below example: http://localhost/...
Adleron's user avatar
  • 53
2 votes
0 answers
296 views

How to use paging SharePoint lists along with sorting and filtering

I am trying to apply paging in a SharePoint list. Everything works fine with the following query: const queryUrl = `${context.pageContext.web.absoluteUrl}` + `/_api/web/lists/GetByTitle('...
Ragnar's user avatar
  • 31
0 votes
1 answer
83 views

Set sorting for Survey Response by Default

I'm trying to set the default sort on responses from a Survey List to descending however I don't see where I can do this or even modify the view. Is there some where I can set the sort on the Survey ...
adams-j's user avatar
  • 317
0 votes
1 answer
3k views

Why doesn't SP remember my column sort settings?

I have a SP files site, the folders of which are labelled 01_label 1, 02_label 2 etc. which I want to have sorted in order of the first two characters. Instead, every time I open it, even after ...
Suzi's user avatar
  • 1
0 votes
1 answer
137 views

automatic sorting and moving of files

was wondering if anyone could help me out with this idea I want to execute in SharePoint. so I have created a document directory for data migration, and I want to automate the whole system of ...
Famia Torsoo's user avatar
0 votes
1 answer
3k 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 ...
Kwinten's user avatar
  • 101
0 votes
1 answer
499 views

sorting by date for files and A-Z for folder

what I want to do is to create something like windows sorting. in windows, you can have different sorting for folder and subfolder. in each document library, we have some top-level folders I want this ...
Ehsan Aliverdi's user avatar
2 votes
3 answers
1k views

Folders and Files under Library/List mixed together when sorting even New Folder Command is enabled in Share point Online

I met one issue that in some of my site collections (Team site (no Office 365 group)), the folders/files in my created Document Library/List are mixed together like: I tried to search and found the ...
Justin Shi's user avatar
1 vote
2 answers
253 views

Sort folders by name in spClientContext.Load(spFOlder.Folders) and VB.NET

I do have the folders and they are loaded correctly but they are not sorted. dim spClientContext As Microsoft.SharePoint.Client.ClientContext dim spFOlder As Microsoft.SharePoint.Client.Folder ... ...
Norman's user avatar
  • 11
0 votes
1 answer
156 views

Remove pin icon from filters pane

Is it possible to hide or remove the pin icon from filters pane which would prevent users to click on it or remove the pinned column from the filter pane by any chance? Such as making it default ...
Abbas's user avatar
  • 25
0 votes
2 answers
123 views

Picture library not sorting alphabetically by Name

I have a picture library containing folders that I want to sort by the "Name" column. As you can see, it sorts the first eight items correctly but then restarts the sorting for the final four items. ...
Tinderbox's user avatar
1 vote
1 answer
80 views

Group by a calculated column and sort with swedish vocals

Environment: SharePoint 2019 - Modern Experience - Modern List I've created a calculated column for grouping items alphabetically but when I group by this column the group are not sorting right the ...
Michel Mora's user avatar
0 votes
1 answer
111 views

How can I filter a library using multiple columns?

I'm trying to filter a library using multiple columns, by project number, type, and an additional category, however when I use multiple filters, the filters applied last don't apply properly. For ...
Confuser's user avatar
2 votes
1 answer
540 views

Managed Property for counting document views

I'm working with a custom search solution on SharePoint Online using the modern experience. I'm hoping to be able to sort the results from this based on the number of views per document (i.e. the ...
CThomas's user avatar
  • 49
0 votes
1 answer
4k views

Sorting Choices in Choice Field

I have created a list of choices in the choice field. How do I sort them alphabetically? Thanks
Aggaire's user avatar
1 vote
1 answer
753 views

How do I sort items that are grouped

I have a view setup were "call sign 1" is grouped and then grouped by "Call sign 2". This allows me to see when mutable submissions of the call sign have been submitted to my custom list. However, I ...
Zach McElwain's user avatar
0 votes
1 answer
49 views

Creat a view with Sharepoint List: Sort by column then filter everything but the most recent

I have a list coming in from forms with a serial number and a date: [Serial Number] [date] a-6/10/19 a-6/12/12 a-2/4/14 b-3/2/15 b-4/1/12 I want to create a view where I only display the most recent ...
Matty D's user avatar
1 vote
0 answers
69 views

Is it possible to sort items from an external content type?

I have an external list/content type set up that reads data from a SQL database view. I only have access to the one view, I do not have access to any tables directly. This database has been around ...
Dylan Cristy's user avatar
  • 12.8k
0 votes
1 answer
20 views

Sorting within a view misplaces a folder

I have created a custom column of the type "Choice" and then a view which will sort by that column. Surprisingly, one folder always gets sorted last and not with its "siblings" which have the same ...
Rumi P.'s user avatar
  • 133
2 votes
1 answer
4k views

PowerApps Sort and Filter

I don't see a similar question based on a quick search, so I'll ask a newbie question about PowerApps: I have a SP Online list relating to incoming parts (raw materials) and I'm creating a new form ...
gpence's user avatar
  • 295
1 vote
0 answers
94 views

Lists sorting by column header click does not trigger OnPostRender event

I'm using Client Side Rendering (JS Link) and according to this answer an OnPostRender event should be triggered whenever a list view column is resorted from a column header click: List view filter ...
George Champlin's user avatar
0 votes
1 answer
281 views

Is there a way to create a folder within Site pages for Sharepoint 2013

I have too many pages and want to sort them by folder within the site pages section of site contents
Mario Nicholas's user avatar
0 votes
1 answer
499 views

Dynamic sorting on search results page

I've created a search page that has a couple of refiners. I've also created a display template that shows search results on a table-like format. Each search result row shows the following three ...
kei's user avatar
  • 586
0 votes
1 answer
144 views

Thumbnail and sorting information issues of Picture Library in Sharepoint Foundation 2013

I have a few questions about SP Foundation 2013. I'm creating an Intranet page and came across a few issues here - tried to research but just want to have a final advice / suggestion / confirmation. ...
Eva Griskene's user avatar
0 votes
3 answers
8k views

How to list folders first in a Documents list

Yes, OK folders=bad. With that out of the way, what's the best way to have folders appear first in a Documents library then have the documents sorted alphabetically? Right now I'm sorting on Title ...
TadLewis's user avatar
0 votes
1 answer
319 views

Sort lookup column to show Active = Yes category on top in on edit form

We are on SharePoint 2016 on premise. We have one document library in which we have added look up column (Category) of existing list(Allow multiple selection). We We want to sort by Active column (yes/...
Amit Chhatbar's user avatar
5 votes
1 answer
2k views

Changing the sort order in a lookup field

I'm in an Office 365 SharePoint environment using a custom list. I have a lookup field that displays the title of courses. I'd like to sort it by the date of the course, but it sorts only ...
Steve Morley's user avatar
2 votes
1 answer
284 views

How are the results of a SPQuery sorted by default if OrderBy is not specified?

Take this simple SPQuery for example: SPQuery query = new SPQuery(); query.Query = "<Where><IsNotNull><FieldRef Name='Modified' /></IsNotNull></Where>"; query.RowLimit = ...
user67116's user avatar
3 votes
1 answer
501 views

Sorting Numeric Column

I have calculated column in a document library. The value for this column is a part of the files title. I'm using this formula: =RIGHT(Title,LEN(Title)-FIND("$",Title)) The data type returned from ...
Tom B.'s user avatar
  • 33
4 votes
0 answers
142 views

SortType of DocumentSet changed from Folder to File from 2010 to 2013

Some time ago we migrated a site collection from 2010 to 2013. Inside this site collection a library contains DocumentSets. We now have this interesting behaviour that sorting in list views does not ...
ben's user avatar
  • 162
0 votes
0 answers
22 views

Change sorting in view while allowing users to sort the view too

One of our customers asked to sort a document library based on the last modify date, so the last updated file is on top. However, when I change the view and add sorting, this will prevent the users ...
vilmarci's user avatar
  • 916
1 vote
2 answers
812 views

Order by modified date on a text calculated column

Due to a business requirement, the dates need to be displayed using the following format: DD MMM YYYY HH:MM Because I am converting modified date to text using the following formula on a calculated ...
diegol's user avatar
  • 33
3 votes
2 answers
377 views

Showing top 5 with grouping

I have a list that collects customer sales data (multiple records can contain the same customer). I am trying to create a view that will show the Top 5 customers based on sales. I need to have the ...
MattC's user avatar
  • 316
0 votes
1 answer
1k views

Most Popular Items from Library Sorting Not Working

When i click into the page of Most Popular items that has the sorting of recent and ever. But i click these two buttons that has no any response. i checked IE F12 debug mode that also has not any ...
okmqaz135's user avatar
1 vote
0 answers
1k views

Sort Folders in document Library

need some help. i have a folder structure in numerical order but it's not appearing in numerical order the way i like, probably because of the numbering. Any tips on how to show it as 1.1, 1.2,1.3? ...
Jodders's user avatar
  • 11
0 votes
1 answer
2k views

Is it possible to change the default order of SPList.Items?

In my code, I am simply using SPList.Items which is returning all items (SPListItemCollection) with default sorting order (ascending order by Created date). I know that I can use CAML Query or some ...
Pavan Kumar's user avatar
1 vote
1 answer
2k views

No Sort/Group by Content Type? [closed]

When editing a View, there is no option to Sort or Group by Content Type. This could be very useful for making a folder-like experience, for finding files, or other use cases. What design criteria ...
Dan's user avatar
  • 305
1 vote
0 answers
1k views

Sort Order Calendar Overlay

Is there a way to change the order of the calendars when using multiple overlay calendars in SharePoint online. I'd like them to sort alphabetically.
user63351's user avatar
1 vote
0 answers
75 views

Datetime querystring format when paging the sorted list-view

When I sort a column (ExpiryDate) in the list view and then click next page button, SharePoint generates URL like this: http://www.example.com/Lists/WatchList/AllItems.aspx#InplviewHash0691b043-5378-...
Ari Gunawan's user avatar
1 vote
1 answer
166 views

sorting military time in list

I've created a single line of text field that's being used for storing military values (no column used). For some reason, it's sorting fine EXCEPT any value in the 1900s. Example 1942, 1900, 1925, etc....
kbald1's user avatar
  • 11
0 votes
1 answer
698 views

What is the default sort order of a Content Query Web Part in SharePoint 2013?

If no sort order is specified in a CQWP, how does SharePoint determine the order to place the items? Is there a default field that it uses to sort if no sorting is specified in the CQWP options?
J. Rivera's user avatar
1 vote
0 answers
174 views

Sort View based upon a specific order of a lookup column

Our standard setup when a department requires a document library with document types is to create a separate Custom List for the Document Types so a power user within that department can add new ...
Michelle Hines's user avatar
2 votes
1 answer
503 views

SP Designer 2010 -- Send Multi-Line Text Field on one line in email

UPDATE I have figured out a work around to this issue (see below). How the workaround functions. I made an new multi-line text field column... "Holder CR" When I edit the entry, I go to "Holder CR" ...
Cyberfan1999's user avatar
1 vote
1 answer
37 views

How can I get folders in a document library to "group" for my custom view? Folders sit in a blank / ungrouped category

I have a simple document library with a custom view that uses the group feature. My coworker setup a list that manages to group folders, but I cannot replicate the effort. Please see the images to see ...
Justin's user avatar
  • 11