JSON Key Reordering Guide:

To reorder JSON keys, use the Json_ReOrder client action. By passing in the required input parameters (Input_Json and KeyOrder), where keys in KeyOrder are separated by spaces, you’ll receive the reordered JSON. This reordered JSON can be used directly for data handling or exporting to Excel.

Instructions for Reordering:

• Step 1: Create a button action in your screen flow.

• Step 2: Within the button’s logic, assign values to Input_Json and KeyOrder. Use the client action’s return value, Output_json, for further processing as per your requirements.

Key Selection for Reordering:

You can choose to reorder all keys or only specific ones. If only some keys are specified, those will be reordered according to KeyOrder, while the remaining keys in Input_Json will retain their original order.

Example Usage:

In this example, we pass Input_Json and KeyOrder values to Json_ReOrder, and the reordered JSON is displayed using an expression. Additionally, to export this JSON to Excel, you can use the jsonToExcel Forge component for seamless conversion.

Screenshot Walkthrough:

For better understanding, refer to the following steps:

Step 1: Create a button action to initiate the reordering.

• Step 2: Set Input_Json and KeyOrder values, and store the reordered JSON in Output_json for further use.

Sample example: 

Here I passed Json and key order and display the reorderd json in expression. but you can also convert that into excel by using josntoexcel forge.