
We are developing an app which loads data into excel. But we are trying to keep the headers in a custom way where insertion order needs to be preserved based on our requirement. But we are not able to either sort the headers or the Collect or Clear Collect functions are by default sorting them in alphabetical order which we don't want. We need to have the collection storing the insertion order of headers which is not happening. Can someone help us with the issue?
Hi @sbaddam ,
You are only looking at the Collection in the "internal" view and this will always be in alphabetical order to make it easier to find columns. However if you use JSON to export, you will get the same order - the only alternative is to define the export table manually using Concat() and your delimiter. If you do this, you do not need JSON in the Flow and the output can actually be the CSV file content.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps