Sort an array by dates in Power Automate
When we use the Sort function to sort arrays in Power Automate, it is soo much easier than the 3 step approach that we had before. But there are a few potential issues when you really start to use this function.
Sort Dates
When we sort dates in Power Automate we really want to to work with dates like this:
We have some dates generated by for example a get items action in SharePoint. Or anything else that generates the dates and all dates are nicely formatted optimized for automation processes.
But what if we have a bad date format returned by an API? Yesterday I was contacted on the chat about an API that didn’t return these nice to work with dates.
In the example below you can see the issue.
As you can see the dates are sorted by month, then day and then year as the dates are sorted alphabetically. This is of course no use at all.
How can we deal with that?
Obviously just using the sort date in this case will not be good enough.
Fixing the dates
To fix the dates, all we have to do is use a select action that converts the date format often used in the US to the sortable date format. The expression used for this is:
formatDateTime( item(), ‘yyyy-MM-dd’)
And for the sorting we now use the following one liner:
sort(body('Select'),'Date')And our dates are sorted!
Continue Reading Pieter Veenstra’s Article on their blog
Sort an array by dates in Power Automate
When we use the Sort function to sort arrays in Power Automate, it is soo much easier than the 3 step approach that we had before. But there are a few potential issues when you really start to use this function.
Blog Syndicated with Pieter Veenstra’s Permission
More About This Author
Array
Modern Workplace26 March 2024Receive the available storage within your SharePoint Online tenant- Modern Workplace20 March 2024Options for Documenting Your Power Apps: Comments, Code, and Controls
- Modern Workplace18 March 20242 ways to duplicate SharePoint Lists to support your Power Apps
- Modern Workplace14 March 2024Update a Hyperlink Column in SharePoint with Power Automate
