In this example, we will be using HD order reference workflow. So the first step is to download the order reference module file here
Prepare a statuses file from HD order workflow file
Unzip the file and go to the folder assets -> workflows. Create a new JSON file:The content of the file should only contain the LOV statuses from HD order workflow:
Convert the JSON file to Excel table format
This video will demonstrate how to convert a JSON list into an Excel table format. Here are the keynotes:
Open Excel
Go to the "Data" menu
Click on the "Get Data (Power Query) icon on the top left-hand corner -> Get Data (Power Query) popup is displayed
In the popup, click on the JSON icon
Click on the "Browse" button -> choose the status JSON file that was prepared earlier, and then click on the "Get Data" button.
Click on the "Next" button -> the Power Query Editor is displayed with the list of data.
Mouseover on the header "List" and right mouse click -> select "Convert to table"
After the list is updated, then click on the icon on the header to open the filter, click on the OK button
The list should be displayed in three columns: name, entityType, and category.
Click the "Close and Load" icon in the top left-hand corner.
The statuses list is successfully converted into a table form.