Sort CSV
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.
Simple CSV with semicolon delimiter
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.
Known Limtitations
⚠️
If you experienced other limitations please get in touch with us!