I am using collection to provide data to JSON. Later this JSON data is used to export to csv as attachment Via Power Automate.
All is working fine, But one issue remains that JSON data column sequence is not same as of collection from where it is been reffered.
Below is the image (green both highlighted) where it can be noted that RecoNo is the first column in the collection code. But in the JSON data it is third column, which indicates that JSON is sorting the header column ascending. But I need to stop this, As sequence of column is important for user.
Kindly guide how it can be corrected to avoid JSON column header sorting.
Full code which is in use :
Clear(colSvcExportData);
ForAll(
SupportSvcGallery.AllItems As SvcExportData,
Collect(
colSvcExportData,
{
RecoNo: SvcExportData.RecoNo,
SvcDate: Text(SvcExportData.SvcDate,"dd-mm-yyyy"),
Model: SvcExportData.Model,
SerialNo: SvcExportData.SerialNo,
SvcSMR: SvcExportData.SvcSMR,
SvcRemarks: SvcExportData.SvcRemarks,
SvcExpense: SvcExportData.SvcExpense,
Customer: SvcExportData.Customer
}
)
);
Set(JSONFileSvcExpo,JSON(colSvcExportData)); //this line hold the data in JSON format
ExpoSvcData.Run(JSONFileSvcExpo,HoldMachDetailsForCsv.Text); //This is power automate flow
Notify("DataExported as CSV file in one drive, and sent email to you",NotificationType.Success,2000);
