Hi @Britney Tu ,
Query parameter $orderby
can be applied on the expanded properties of fieldvalueset, and usage of the is not recommended large lists.
Following is an example snippet:
/sites/{site-id}/lists/{list-id}/items?$expand=fields&$orderby=fields/Modified desc
Prefer: HonorNonIndexedQueriesWarningMayFailRandomly
Note: Please note that Prefer: HonorNonIndexedQueriesWarningMayFailRandomly
should be added in the Request headers, but be warned that such queries may fail on large lists.
Hope this helps.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any further questions about this answer, please click "Comment".