How to sort the results of the choices in alphabetical order?

Robbins, Susan P 0 Reputation points
2024-01-04T20:30:06.2266667+00:00

Hi there, I am trying to get the drop down list (data source Office365 users) to be in alphabetical order. I have the following selections.

Items=Choices([@'Services Request'].NameofRequester)

DisplayFields-["DisplayName","Email","Picture"]

SearchFields=["DisplayName"]

Thanks!

User's image

SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
583 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yanli Jiang - MSFT 26,016 Reputation points Microsoft Vendor
    2024-01-05T03:09:51.3566667+00:00

    Hi @Robbins, Susan P ,

    Based on the screenshot you provided, it seems you are using Power Automate?

    If so, unfortunately Power Automate is currently not supported in the Q&A forum. Please start a new discussion via the Power Automate Community so that you can get dedicated support on this issue.

    If not, can you provide more information about this? Generally, the order of the choice drop-down list is consistent with the order of the input values. like this:

    The order of input values:

    User's image

    The order of drop-down list:

    User's image

    Hope this is help.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.