Hi Sam,

If I recall correctly, the Export to Excel exports the data in the same order and shape that it is in the list. As such, either you have a query return the data as you want it to be exported, OR you can generate a list in the export action with the data you want, by the order you want it.

You can do this by:

1 - Creating a structure with the proper attributes that will be exported
2 - Creating a local variable in the export action of type record list and your new structure as its record definition
3 - Use the ListAppend action to append new items to the list

I hope this helps, or at least that it gives you some ideas on how to achieve what you're trying to get to.

Regards,

Paulo Tavares

What would be great was if on the Outsystems studio, instead of a "check" to select the fields, it would offer an order ID for the column. Or even better... allow some kind of drag&drop reorder on the field list, not only here, but on other places where lists with lots of fields can get messy after a few development iteration cycles.