5
votes
Sort list but not by one of the lists columns
You can create one column with name "OrderID" with Number or Single line text column type with set YES for Enforce unique values. Now set the order of the file name by assigning the number in "OrderID"...
- 7,247
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 ...
- 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 ...
- 8,090
2
votes
Accepted
Sorting Numeric Column
Try enclosing it in the VALUE() function and see if that changes anything.
- 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
- 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 ...
- 46.4k
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 ...
- 46.4k
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 ...
- 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 = ...
- 3,666
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;
}
...
- 6,249
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.
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:
...
- 4,260
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 ...
- 2,215
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, ...
- 133
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 ...
- 4,979
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 ...
- 11.7k
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 (...
- 11
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 ...
- 2,215
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.
- 372
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 ...
- 1,778
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 ...
- 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-...
- 1,282
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 ...
- 45.4k
1
vote
Sorting grouped items in a list view
You can create a calculated column with a type "number".
=IF(category="Permissions","<span style='display:none;'>1</span>CategoryName","<span style='display:none;'>2</span>...
- 360
Only top scored, non community-wiki answers of a minimum length are eligible