Hot answers tagged

4 votes
Accepted

Sorting grouped items in a list view

For other people who run into the issue of ordering Groups but do not want to add any other (visible)characters to the title here is a small tip. Add spaces! More than one space is not shown in HTML ...
Peter's user avatar
  • 156
3 votes
Accepted

PowerApps Sort and Filter

I'm not sure why the items aren't sorting consistently, but a sort can be applied as part of the items property: SortByColumns('Inbound RM Inspection', "Title") Of course, this would sort, but ...
Mike2500's user avatar
  • 8,060
2 votes
Accepted

REST api postquery with SortList not working

I found a tutorial yesterday that had one sort term in the post query. It took a bit of work to figure out how to do multiple terms. Here is what ended up working for me: 'SortList' : { 'results' : ...
Rothrock's user avatar
  • 3,010
2 votes
Accepted

Library not sorting folders to top

I discovered that if the library setting Make "New Folder" command available? is set to Yes, folders sort as described/expected: at the top of any ascending sort, or the bottom of any descending sort, ...
Dan Henderson's user avatar
2 votes
Accepted

Sorting Numeric Column

Try enclosing it in the VALUE() function and see if that changes anything.
mannaggia's user avatar
  • 999
2 votes

Order by modified date on a text calculated column

If I understand correctly, I think all you need to do is to ensure that the data type returned from this formula should be data/time. Set the Data Type to Date/Time Result
SharePointer's user avatar
  • 3,046
2 votes
Accepted

Sorting Choices in Choice Field

As per my understanding you want to sort the choices list in choice column drop-down on list/library forms(Correct me if I am wrong). For a column configured as a Choice column, the order in which ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

How do I sort items that are grouped

Go in Modify View and check the settings under Group By - try changing it to descending and see what happens. When you are using Group By it overrides the usual Sort By settings. BTW - I'm using ...
Tally's user avatar
  • 2,273
1 vote

Sorting within a view misplaces a folder

I found what was happening here. This being an initial filling of this Sharepoint instance, I had not yet planned everything I wanted from the beginning. So, at first I created some folders, ...
Rumi P.'s user avatar
  • 133
1 vote

How to sort text field with first two digit numbers

This is the default behavior in SharePoint. SharePoint sorts the text fields alphabetically (A, B, C, or 1, 2, 3). Workaround: Create another column (probably number column) for sort order and sort ...
Ganesh Sanap - MVP's user avatar
1 vote

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

I know the OP referred to VB in the question but I had the same issue in C# and based on @Damjan's answer this is what worked for me: var sorted = folder.Folders.OrderBy(t => t.Name); Also had to ...
Mick's user avatar
  • 11
1 vote

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

You should be able to sort it as any other collection of objects. This piece of code should do the work: ... spClientContext.Load(spFOlder.Folders) spClientContext.ExecuteQuery() Dim sorted = ...
Damjan Tomic's user avatar
  • 3,646
1 vote

Remove pin icon from filters pane

We can create a SPFx Applications Customiser to inject the following CSS style to site to achieve it. .od-FilterSectionHeader-sideCommands button[name='Unpin']{ display:none !important; } ...
LZ_MSFT's user avatar
  • 6,219
1 vote

How can I filter a library using multiple columns?

I haven't experienced that issue. However, if you are having trouble getting filters to do what you want, you could try creating a view instead.
Lauren Furness's user avatar
1 vote
Accepted

Managed Property for counting document views

Just like Sheth said, viewslifetime is a useful property. In fact there are a bunch of similar managed properties you can use. A bit more information about viewslifetime and viewcountlifetime: ...
Jerry_MSFT's user avatar
  • 4,220
1 vote
Accepted

Dynamic sorting on search results page

Each property that you want to be Sortable must be a Managed Property that is Sortable. In SPO you need to map your property to a Refinable(TYPE)## managed property since they are already flagged as ...
Matthew McDermott's user avatar
1 vote
Accepted

How to list folders first in a Documents list

Done a lot of searching and this is the best solution I've come up with so far to mimic file explorer behavior. Sorting on the Title metadata field which is blank or null for folders, then the Name (...
TadLewis's user avatar
1 vote

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

In your question it is not clear if you are using 'Allow Multiples Selection' in a choice field - if you are, choice fields will not sort in a nice way. i.e. Value A will show at the top of your ...
Tally's user avatar
  • 2,273
1 vote
Accepted

Changing the sort order in a lookup field

I asked the same question in the Microsoft Tech Community forum, and the Microsoft MVP said that the only way to do it is with custom development.
Steve Morley's user avatar
1 vote
Accepted

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

If you don't specify the Order by in "SPQuery" as mention above the data return will Order by ID/Id of item of the list in Ascending order. For Quick result you can check with rest api on browser as ...
Sunil Sahu's user avatar
  • 1,758
1 vote
Accepted

Order by modified date on a text calculated column

You can use the CSR to change the display format of list column. Edit your list view web part properties. Under Miscellaneous section you will see "JS Link" You can enter the path of JS file. You ...
Venkat Konjeti's user avatar
1 vote

Showing top 5 with grouping

This is not possible OOTB since Aggregation has no sorting parameter. This might be because the values are never stored it is calculated on the fly. You can achieve this through some code. Have a look ...
SharePointer's user avatar
  • 3,046
1 vote

No Sort/Group by Content Type?

How about Metadata Navigation for your App. It allows you to add content type as something that can be filtered on. More info: https://support.office.com/en-US/article/Set-up-metadata-navigation-for-...
Chris G's user avatar
  • 1,292
1 vote

sorting military time in list

It's a normal behavior , the sort not working properly for a number value in a single line of text field So if you use a custom column with a single line of text you can change its datatype normally ...
Mohamed El-Qassas MVP's user avatar
1 vote

Sorting list items in a webpart in SharePoint

From the above ribbon, select modify view > Beside sort try to sort as ASC or Disc based on your column that you need to sort with it At list view web part > edit web part > and select this ...
Mohamed El-Qassas MVP's user avatar
1 vote
Accepted

Get random list item

It would depend on the number of items in the list. For example if its a small list, (say 100 items or less), then you could generate the random number between 0 and number of items -1, and select the ...
Paul Lucas's user avatar
  • 4,246
1 vote
Accepted

Bring files then folders in Sharepoint 2010

Modify your view and apply the sort as in the image. Make sure you select the check box.
Shashank Karam's user avatar
1 vote

Why are my sort orders not working in my SharePoint 2013 search results Web Part?

This helped me when I had a problem to make the sort order to behave as I wanted: Why can't I sort the Search Results Web Part by a Managed Property? Basically, you need to remove the JSON in ...
Jenny Fergéus's user avatar
1 vote

How can I change the sort order of the Default blog page in SharePoint 2010?

Click edit page on the blog home page. This should then allow you to edit the posts webpart. In the web part under List Views click edit view. Sort by ascending hit ok and save.
sharepointnoob's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible