Sort CSV [DEPRECATED]
This action is deprecated, meaning it is outdated and no longer maintained. It can still be used, but the updated version here (opens in a new tab) includes new features and bug fixes.
Usage
Sort a CSV file by specifying a column for streamlined data organization and customized sorting.
Input Arguments
| Input Argument | Type | Description | Required? | Advanced Option? | Default |
|---|---|---|---|---|---|
CSV | String in CSV format | The CSV code or a file containing CSV | ✔️ | ✔️ | - |
Output
| Response | Type | Description |
|---|---|---|
CSV | String in CSV format | The sorted CSV code |
Power Automate Examples
Sort CSV
We use a simple CSV with four pets.
Pet; Identifier;First name;Last name
Dog;1000;Eats;A Lot
Cat;1001;Likes;To Scratch
Cat;1002;Furry;Kitty
Duck;1003;Dagobert;SwimmyWe have not changed the advanced options and indicated the sort column.
In the advanced options, you can specify the sort column, indicate if the CSV has headers, enable automatic field type detection, set the number of rows for field type detection, remove empty rows, skip or stop at specific rows, define the separator, enable automatic quote delimiter detection, choose a further sorting column, and reverse the sort order.
Looking for the response of this example? If you scroll up you see a Output tab.