1

I have set up a view (modern experience) on a list in a SharePoint Online site, grouping by a 'Meeting Date' column and sorting on a 'Time' column (ascending order) then 'Requirement' column (ascending order).

I and other users are seeing incorrect items being placed into each grouping, and items being sorted in the wrong order within each group. There is no apparent pattern to the order (i.e. it is not falling back to a sort on 'ID' or other columns).

'Meeting Date' is a Calculated Column, which looks up a 'Meeting' (Date & Time) column and returns as Date only. 'Time' is also a Calculated Column, which extracts the time from the 'Meeting' column and returns as Text. Finally, 'Requirement' is a Lookup column returned as Text.

I have kept all other view settings as close to the SharePoint defaults as possible. Is there anything I have missed which may be causing the items to appear in the wrong order, or could this be a SharePoint bug?

1

I test in my environment based on the same column types and few items, all the group and sort order is display correctly.

Please narrow down your issue as following:

  1. How many items in the list view? Large number of items in the list might cause the wrong display in the view.

  2. Clear the sort in the list view, check if the Group By works correctly.

  3. You can also clear all the view settings, then add group by or sort one by one to check which settings might cause the issue.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.