Hello!
This is a challenge, at least for me!
I was able to use a compose split to get the following output. Not sure what to do next.
Using power automate flow actions, I need to convert the following compose output into an array of objects.
Each row of data in the array contains the columns as follows:
department_number,
department_name,
category_number,
category_name,
class_number,
class_name,
item_number,
fullItemDescription
Example row in table form:
| department_number |
department_name |
category_number |
category_name |
class_number |
class_name |
item_number |
fullItemDescription |
| 4 |
GROCERY |
19 |
CRACKERS |
22 |
Cheese Crackers |
111222 |
Cheez-it Original Crackers 12.4 OZ |
Better example:
[
{
"department_number": "4",
"department_name": "GROCERY",
"category_number": "19",
"category_number": "CRACKERS",
"class_number": "22",
"class_name": "Cheese Crackers",
"item_number": "111222",
"fullItemDescription": "Cheez-it Original Crackers 12.4 OZ"
},
]
Compose output:
["[[\"4\",\"GROCERY\",\"19\",\"CRACKERS\",\"22\",\"Cheese Crackers\",\"111222\",\"Cheez-it Original Crackers 12.4 OZ\"",
"\"3\",\"PRODUCE\",\"22\",\"Cooking Greens\",\"1\",\"BULK COOKING GREENS\",\"333444\",\"Organic Kale Green\"",
"\"90\",\"Homestyle American\",\"2\",\"Chicken\",\"1\",\"Rotisserie Chicken\",\"555666\",\"Whole Rotisserie Plain\"",
"\"3\",\"PRODUCE\",\"54\",\"Bananas\",\"1\",\"BANANAS\",\"777888\",\"Bananas\"",
"\"3\",\"PRODUCE\",\"18\",\"Salad Leaf (New)\",\"2\",\"BULK ICEBERG\",\"999111\",\"Iceberg Lettuce 1 EA\"",
"\"85\",\"Asian Foods and Bowls\",\"3\",\"Asian Hot Bars\",\"1\",\"Asian Self Serve Bars\",\"888222\",\"Hot Bar\"",
"\"52\",\"WINE\",\"27\",\"OREGON\",\"40\",\"Pinot Noir\",\"777333\",\"Erath Pinot Noir\"]]"]
Screen shot of the Compose output ...
