Sorting an Action List in Power Automate

@Reuben Schmitz
To use the sort() expression, you can read it here:

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#sort

when you sort without providing the “sortBy” I think it sort based on the first “simple” property it can find, which may not be the sorting you want.

First point is, you have to use the action that you did the sort on (Compose action), or you can using the array sorted directly in a apply to each loop or create html action. But if you use dynamic content directly from the Action List for Audit variable or List actions action, then the order is still going to the be “old” order before sort.

Also, you “can't” really sort on the List actions array of actions, as fundraiser is an array of system record id of the fundraiser, unlikely what you want to sort by, nor can sort by as array is not a simple type.

Then the question becomes, how are you handling action that has multiple fundraiser? From your Append to array variable action, it seems you are using a dynamic content called “Name”, but without seeing what your Apply to each looks like, can't really tell if you are using another apply to each for fundraiser array or only getting “first()” fundraiser.

Anyway, you don't need a separate Compose action (you can if you want), instead you can do the sort in the create html table action as the array from which you are creating html table for:

sort(variables('Action List for Audit'), ‘Action Solicitor Name’)