When viewing the data in a table in the Workflows Console, there are default columns labeled with "(auto)" (such as "rowID (auto)" and "updated (auto)"). When trying to sort by those columns, the rows do not seem to sort.
- Workflows Tables
This is expected behavior. Those default columns are not sortable columns like the columns that are manually added to the table.
While keeping in mind that tables are a convenient way to store data that can be read from or written to a flow and are not meant for long-term storage, the below can be a method to have the table capable of sorting when it is (approximately) updated:
- In the table, add a New Column.
- For example:
- Name: updatedDate
- Field Type: date.
- For example:
- For flow(s) Create Row or Update Row, insert a Date & Time - Now card before the Create/Update Row card, and drag the date into the updatedDate field.
- In the example below, a Create Row card was used.
- Now, when going into the table, the manually added date column can be sorted.
NOTE: If the table is manually edited, the updatedDate field does not auto-update. Either it would have to be manually updated, or ensured that the rows are updated by flows that update the field as shown.
