SharePoint Online List: How to sort the lookup column's drop down list options?

0
votes

There are two Lists: ListA and ListStatus

ListA has a lookup field Status pointing to list ListStatus

In list ListStatus there are 3 items: New, WIP, Closed

Currently, when creating a new ListA item, select Status field and the values in the drop down list show in below order: enter image description here

Is it possible to show/sort the statuses in the drop down list as below? How?

  • New
  • WIP
  • Closed

Thanks

1
sharepointsharepoint-online

1 Answers

0
votes

Workaround, create a order in ListStatus list and add it to lookup show field.

Demo result.

enter image description here

enter image description here

Otherwise, you have to consider custom solution.