Power Platform Community Forum Thread Details

Hello! I am very new to Power Automate so excuse me if I don't use the right terminology. I have a Form which contains a multi-select question where users can select up to 3 answers out of 14 possible answers. Right now my flow creates an item to put the answers into a certain column on a SharePoint List. The trouble is, the flow sorts the multiselect answers by the order the user selects the answers, not in the order the Form is in. For example, the Form is in ascending order from 1-14, but if a user selects outside that order (10, 7, 5) then the flow will sort the answers into the List based on the users selection order instead of 5, 7, 10. How can I fix the flow so it keeps the answer in the proper ascending order in the column in the List? Hope this makes sense.

Categories:

Building flows

Hi @CU06121735-0

You could try the following. but this requires an object variable that stores the Choice/Selection text and their sort order. The content of the object variable must match exactly the forms selection text as you see in the example below:

In the Select action below, I'm adding a property called idx - this adds the sort order value to the user's responses:

Select 2 sorts the responses by the idx property we added above. In the Select 2 action make sure you switch Map to Text mode. The expression in the Map selects just the users selection (and we ignore the idx property, as we don't need this anymore).