Export CSV with custom rows

[jaipalambati]

Hello community, I am trying to generate a CSV using Flow. I have joined my data using ID's. 

Schema as below:

[{
"DCQ":2,

"Export_Items":{
"Title":"AG-P-Triangle-01-2-F-2",
"minDQ":6,
"trancheCommodityBasePrice":6,
"trancheDCQ":6,
"trancheEndDate":"2024-01-10",
"trancheID":1,
"trancheMDQ":6,
"trancheStartDate":"2024-01-04"
},"MDQ":2,
"Title":"AG-P-Triangle-01-2-F-2",
"clientName":"Triangle",
"commodityBasePrice":2,
"endDate":"2024-02-02",
"startDate":"2024-01-02",
"transportCost":2
}
]

Is it possible to write highlighted data as a new row?

For example:

DCQ	MDQ	minDQ	Title	clientName	commodityBasePrice	endDate	startDate	transportCost	trancheId
2	2	null	AG-P-Triangle-01-2-F-2	Triangle	2	2/02/2024	2/01/2024	2	null
6	6	6	AG-P-Triangle-01-2-F-2	null	6	10/01/2024	4/01/2024	null	1

The second row is from the "Export_Items" object, mapping them to headers.

Please share your ideas on this.TIA 

[Chriddle]

I can't understand your example.
Can you use colors to show value mapping from JSON to table?

[jaipalambati]

@Chriddle , sorry for confusion. It is not about the color. I just highlighted the text.

I want to export a CSV, the first row of the CSV must be the text in black color as it is my Main Table,

The second row of the CSV must be in red as it is my Child table.

To be clear, I have 2 tables, I joined them using MainTable.ID = ChildTable.parentID

Hence I generated the Json data as I mentioned in my question.

[eliotcole]

Hi, @jaipalambati, you can achieve what you're after with this:

Split The Export and Non-Export Data And Re-join

I have represented your data in the Compose action named 'array' at the start here, obviously you will need to refer to your appropriately named resource.

SelectNonExport

Here's the expression in the 'Map' value for the 'SelectNonExport' Select action. Be sure that the Map field is switched to the 'text' entry method by tapping the little pen to the right:

addProperty(
    addProperty(
        removeProperty(
            removeProperty(
                item(), 
                'clientName'
            ), 
            'Export_Items'
        ), 
        'minDQ', 
        null
    ), 
    'trancheID', 
    null
)

FilterHasExportItemsValue

Before the 'SelectExports' Select action you will note that I performed a belt and braces check to ensure that the items actually have values in that specific key.

Whilst you may wish to omit this step for brevity it is there none-the-less, and the condition in the 'FilterHasExportItemsValue' Filter action is:

@not(equals(item()?['Export_Items'], null))

SelectExports

This Select action uses the 'text' mode (as previous) to ensure that values are properly added, but you should be OK in the normal view just adding the fields. This is the contents of that 'Map' if you wish to paste it in:

{
    "DCQ": @{item()?['Export_Items/trancheDCQ']},
    "minDQ": @{item()?['Export_Items/minDQ']},
    "MDQ": @{item()?['Export_Items/trancheMDQ']},
    "Title": "@{item()?['Export_Items/Title']}",
    "commodityBasePrice": @{item()?['Export_Items/trancheCommodityBasePrice']},
    "endDate": "@{item()?['Export_Items/trancheEndDate']}",
    "startDate": "@{item()?['Export_Items/trancheStartDate']}",
    "transportCost": @{null},
    "trancheID": @{item()?['Export_Items/trancheID']}
}

Create CSV table

Then you use a union to join the two data sets as the source 'From' value for the final Create CSV table creation action:

union(
    body('SelectNonExport'), 
    body('SelectExports')
)

Result

It should all finally look like this:

Here that is in an HTML table for clarity:

[Chriddle]

Or just create the whole array from scratch:

Compose:

first(outputs('Json'))

Create HTML table:

[
	{
		"DCQ": @{outputs('Compose')?['DCQ']},
		"MDQ": @{outputs('Compose')?['MDQ']},
		"minDQ": null,
		"Title": @{outputs('Compose')?['Title']},
		"clientName": @{outputs('Compose')?['clientName']},
		"commodityBasePrice": @{outputs('Compose')?['commodityBasePrice']},
		"endDate": @{outputs('Compose')?['endDate']},
		"startDate": @{outputs('Compose')?['startDate']},
		"transportCost": @{outputs('Compose')?['transportCost']},
		"trancheId": null
	},
	{
		"DCQ": @{outputs('Compose')?['Export_Items']?['trancheDCQ']},
		"MDQ": @{outputs('Compose')?['Export_Items']?['trancheMDQ']},
		"minDQ": @{outputs('Compose')?['Export_Items']?['minDQ']},
		"Title": @{outputs('Compose')?['Export_Items']?['Title']},
		"clientName": null,
		"commodityBasePrice": @{outputs('Compose')?['Export_Items']?['trancheCommodityBasePrice']},
		"endDate": @{outputs('Compose')?['Export_Items']?['trancheEndDate']},
		"startDate": @{outputs('Compose')?['Export_Items']?['trancheStartDate']},
		"transportCost": null,
		"trancheId": @{outputs('Compose')?['Export_Items']?['trancheID']}
	}
]

[Chriddle]

Or with a little less writing work

Table From:

createArray(
	removeProperty(
		first(outputs('Json')),
		'Export_Items'
	),
	json(
		replace(
			string(first(outputs('Json'))?['Export_Items']),
			'tranche',
			''
		)
	)
)

[jaipalambati]

@Chriddle  life saver..! This is a great solution. 

Just another query, how can I do this if I have multiple records? 

I just mentioned only one record in my question.

here is my flow. 

ParseJson: my schema

Compose : outputs('Parse_JSON')

HTML table: query you have written in your solution ( with custom columns)

I am getting null values in the output 

Any ideas on this?

[jaipalambati]

@eliotcole  thank you for the solution. This works but I am afraid of how this works if I have multiple records? 

For Example:

1st item has 2 child items

2nd item has 3 child items

Will they join correctly with "Union"

I worked on one of those solutions but that didn't join properly.

[eliotcole]

They should work just fine, that's how it was designed, @jaipalambati 🙂 ... why not give it a try?

---

@jaipalambati wrote:

@eliotcole  thank you for the solution. This works but I am afraid of how this works if I have multiple records? 

For Example:

1st item has 2 child items

2nd item has 3 child items

Will they join correctly with "Union"

I worked on one of those solutions but that didn't join properly.

---

Basically, you obviously ignore my action named 'array' ... and the two actions after that are filtering YOUR array ... the one on the left grabs all the items without their 'Exports' data ... the one on the right grabs only the exports data for those that have them.

The union() of the two will remove any duplicates so that you only have the unique entries for both. Pretty much everything you need is above to just paste into the right fields. Just ensure that the 'From' fields of the SelectNonExport and the FilterHasExportItemsValue have your source in there. 👍

( if you would have included screenshots of your flow as embedded images - not attached - in the original question I would have given you something to simply paste into your flow 🙂 )

[Chriddle]

Can you provide an example of a JSON with multiple records?

[eliotcole]

Good point, @Chriddle ... @jaipalambati your original example shows the 'export' as a single item. Is it a property that can be either a single item or an array of items?

---

@Chriddle wrote:

Can you provide an example of a JSON with multiple records?

---

So if export items is always going to be presented as it *could* have either a single entry or multiples, this would be good information to have.

If you have just made an oopsie, and it was supposed to look like the code in the below spoiler, then I totally understand, and I will amend my solution accordingly.

Spoiler

[
	{
		"DCQ": 2,
		"Export_Items": [
			{
				"Title": "AG-P-Triangle-01-2-F-2",
				"minDQ": 6,
				"trancheCommodityBasePrice": 6,
				"trancheDCQ": 6,
				"trancheEndDate": "2024-01-10",
				"trancheID": 1,
				"trancheMDQ": 6,
				"trancheStartDate": "2024-01-04"
			}
		],
		"MDQ": 2,
		"Title": "AG-P-Triangle-01-2-F-2",
		"clientName": "Triangle",
		"commodityBasePrice": 2,
		"endDate": "2024-02-02",
		"startDate": "2024-01-02",
		"transportCost": 2
	}
]

[jaipalambati]

 @Chriddle & @eliotcole  here you go

[{
"DCQ":1,
"Export_Items":{
"Title":"AG-S--1-AA-1",
"minDQ":2,
"trancheCommodityBasePrice":2,
"trancheDCQ":2,
"trancheEndDate":"2024-01-11",
"trancheID":1,
"trancheMDQ":2,
"trancheStartDate":"2024-01-09"
},
"MDQ":1,
"Title":"AG-S--1-AA-1",
"clientName":"Agnew",
"commodityBasePrice":1.2,
"endDate":"2024-01-31",
"startDate":"2024-01-01",
"transportCost":1,
},{
"DCQ":2,
"Export_Items":{
"Title":"AG-P-Triangle-01-2-F-2",
"minDQ":2,
"trancheCommodityBasePrice":2,
"trancheDCQ":2,
"trancheEndDate":"2024-01-10",
"trancheID":1,
"trancheMDQ":2,
"trancheStartDate":"2024-01-04"
},
"MDQ":2,
"Title":"AG-P-Triangle-01-2-F-2",
"clientName":"Triangle",
"commodityBasePrice":2,
"endDate":"2024-02-02",
"startDate":"2024-01-02",
"transportCost":2
}, {
"DCQ":7,
"Export_Items":null,
"MDQ":7,
"Title":"AG-P-Triangle-01-7-AA-7",
"clientName":"Triangle",
"commodityBasePrice":7,
"endDate":"2024-01-25",
"startDate":"2024-01-17",
"transportCost":7,
}]

[eliotcole]

OK, @jaipalambati , that's great, then ... as long as the Export_Items field never responds with a value that looks like the following, then my solution will work perfectly.

[
	{
		"DCQ": 1,
		"Export_Items": [
			{
				"Title": "AG-S--1-AA-1",
				"minDQ": 2,
				"trancheCommodityBasePrice": 2,
				"trancheDCQ": 2,
				"trancheEndDate": "2024-01-11",
				"trancheID": 1,
				"trancheMDQ": 2,
				"trancheStartDate": "2024-01-09"
			},
			{
				"Title": "AG-P-Triangle-01-2-F-2",
				"minDQ": 2,
				"trancheCommodityBasePrice": 2,
				"trancheDCQ": 2,
				"trancheEndDate": "2024-01-10",
				"trancheID": 1,
				"trancheMDQ": 2,
				"trancheStartDate": "2024-01-04"
			}
		],
		"MDQ": 1,
		"Title": "AG-S--1-AA-1",
		"clientName": "Agnew",
		"commodityBasePrice": 1.2,
		"endDate": "2024-01-31",
		"startDate": "2024-01-01",
		"transportCost": 1
	}, ...
]

[Chriddle]

Compose

The original array

Spoiler

[
  {
    "DCQ": 1,
    "Export_Items": {
      "Title": "AG-S--1-AA-1",
      "minDQ": 2,
      "trancheCommodityBasePrice": 2,
      "trancheDCQ": 2,
      "trancheEndDate": "2024-01-11",
      "trancheID": 1,
      "trancheMDQ": 2,
      "trancheStartDate": "2024-01-09"
    },
    "MDQ": 1,
    "Title": "AG-S--1-AA-1",
    "clientName": "Agnew",
    "commodityBasePrice": 1.2,
    "endDate": "2024-01-31",
    "startDate": "2024-01-01",
    "transportCost": 1
  },
  {
    "DCQ": 2,
    "Export_Items": {
      "Title": "AG-P-Triangle-01-2-F-2",
      "minDQ": 2,
      "trancheCommodityBasePrice": 2,
      "trancheDCQ": 2,
      "trancheEndDate": "2024-01-10",
      "trancheID": 1,
      "trancheMDQ": 2,
      "trancheStartDate": "2024-01-04"
    },
    "MDQ": 2,
    "Title": "AG-P-Triangle-01-2-F-2",
    "clientName": "Triangle",
    "commodityBasePrice": 2,
    "endDate": "2024-02-02",
    "startDate": "2024-01-02",
    "transportCost": 2
  },
  {
    "DCQ": 7,
    "Export_Items": null,
    "MDQ": 7,
    "Title": "AG-P-Triangle-01-7-AA-7",
    "clientName": "Triangle",
    "commodityBasePrice": 7,
    "endDate": "2024-01-25",
    "startDate": "2024-01-17",
    "transportCost": 7
  }
]

Select

Basically the same expression as above, creates the 2 items

From

outputs('Compose')

Map

createArray(
	removeProperty(
		item(),
		'Export_Items'
	),
	json(
		replace(
			string(item()?['Export_Items']),
			'tranche',
			''
		)
	)
)

Select 2

Since Select made an array of 2 items for each item in the original array, flatening the array is necessary

From

xpath(
    xml(json(concat('{"Root":{"Item":', body('Select'),'}}'))),
    '/Root/Item/Item'
)

Map

json(item())['Item']

Filter

Remove the items that are created based on "Export_Items": null

From

body('Select_2')

Filter

item() is not equal to null

[eliotcole]

Coincidentally, @Chriddle, I was just improving my solution with an xpath(), too! 😅

Split Exports & NonExports Then Union() - Improved

This does exactly the same as my previous answer, @jaipalambati, but this will ensure that each item does not care about whether the Export_items value is an array or an object.

You can put this straight into your flow by copying the code in the below spoiler and pasting it into your own.

Spoiler

{"id":"bd5aed05-bd91-4f00-93c1-be7054e02dc3","brandColor":"#8C3900","connectionReferences":{},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"ScopeFlattenArrays","operationDefinition":{"type":"Scope","actions":{"SelectNonExport":{"type":"Select","inputs":{"from":"@body('SelectAddExportType')","select":"@addProperty(\r\n\taddProperty(\r\n\t\tremoveProperty(\r\n\t\t\tremoveProperty(\r\n\t\t\t\tremoveProperty(\r\n\t\t\t\t\titem(), \r\n\t\t\t\t\t'clientName'\r\n\t\t\t\t), \r\n\t\t\t\t'Export_Items'\r\n\t\t\t), \r\n\t\t\t'exportItemsStatus'\r\n\t\t), \r\n\t\t'minDQ', \r\n\t\tnull\r\n\t),\r\n\t'trancheID',\r\n\tnull\r\n)"},"runAfter":{"SelectAddExportType":["Succeeded"]},"description":"This removes information you do not want and adds the columns unused from exports - addProperty(addProperty(removeProperty(removeProperty(removeProperty(item(), 'clientName'), 'Export_Items'), 'exportItemsStatus'), 'minDQ', null), 'trancheID', null)","metadata":{"operationMetadataId":"7bd3a248-ea40-4ff3-9f64-941e86a546ed"}},"FilterHasExportItemsValue":{"type":"Query","inputs":{"from":"@body('SelectAddExportType')","where":"@or(equals(item()?['exportItemsStatus'], 'array'), equals(item()?['exportItemsStatus'], 'object'))"},"runAfter":{"SelectAddExportType":["Succeeded"]},"description":"This checks whether or not the item is either an array or an object and if it is either includes it - @or(equals(item()?['exportItemsStatus'], 'array'), equals(item()?['exportItemsStatus'], 'object'))","metadata":{"operationMetadataId":"8956c5a1-c78e-48ba-ac5d-d087d7679ac9"}},"SelectExports":{"type":"Select","inputs":{"from":"@xpath(\r\n    xml(\r\n        json(\r\n            concat(\r\n                '{\"r\": { \"c\":', \r\n                string(body('FilterHasExportItemsValue')), \r\n                '}}'\r\n            )\r\n        )\r\n    ),\r\n    '/r/c/Export_Items'\r\n)","select":{"DCQ":"@int(json(item())?['Export_Items/trancheDCQ'])","minDQ":"@int(json(item())?['Export_Items/minDQ'])","MDQ":"@int(json(item())?['Export_Items/trancheMDQ'])","Title":"@json(item())?['Export_Items/Title']","commodityBasePrice":"@int(json(item())?['Export_Items/trancheCommodityBasePrice'])","endDate":"@json(item())?['Export_Items/trancheEndDate']","startDate":"@json(item())?['Export_Items/trancheStartDate']","transportCost":"@null","trancheID":"@int(json(item())?['Export_Items/trancheID'])"}},"runAfter":{"FilterHasExportItemsValue":["Succeeded"]},"description":"This formats the filtered items from JSON to XML and flattens to only Export_items then the Map expressions translate back to JSON - xpath(xml(json(concat('{\"r\": { \"c\":', string(body('FilterHasExportItemsValue')), '}}'))), '/r/c/Export_Items')","metadata":{"operationMetadataId":"6650e4c4-7e20-4af4-989f-2533a0d23703"}},"SelectAddExportType":{"type":"Select","inputs":{"from":"@outputs('InputArray')","select":"@addProperty(\r\n    item(), \r\n    'exportItemsStatus',\r\n    if(\r\n        equals(\r\n\t\t\titem()?['Export_Items'], \r\n\t\t\tnull\r\n\t\t),\r\n        'null',\r\n        if(\r\n            empty(\r\n                trim(\r\n                    string(item()?['Export_Items'])\r\n                )\r\n            ), \r\n            'null', \r\n            if(\r\n                startsWith(\r\n                    trim(\r\n                        string(item()?['Export_Items'])\r\n                    ),\r\n\t\t\t\t\t'['\r\n                ), \r\n                'array', \r\n                if(\r\n                    startsWith(\r\n\t\t\t\t\t\ttrim(\r\n\t\t\t\t\t\t\tstring(item()?['Export_Items'])\r\n\t\t\t\t\t\t),\r\n\t\t\t\t\t\t'{'\r\n\t\t\t\t\t), \r\n                    'object', \r\n                    if(\r\n\t\t\t\t\t\tisInt(\r\n\t\t\t\t\t\t\ttrim(\r\n\t\t\t\t\t\t\t\tstring(item()?['Export_Items'])\r\n\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t), \r\n\t\t\t\t\t\t'integer', \r\n\t\t\t\t\t\tif(\r\n\t\t\t\t\t\t\tisFloat(\r\n\t\t\t\t\t\t\t\ttrim(\r\n\t\t\t\t\t\t\t\t\tstring(item()?['Export_Items'])\r\n\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t), \r\n\t\t\t\t\t\t\t'floating', \r\n\t\t\t\t\t\t\t'other'\r\n\t\t\t\t\t\t)\r\n\t\t\t\t\t)\r\n                )\r\n            )\r\n        )\r\n    )\r\n)"},"runAfter":{"InputArray":["Succeeded"]},"description":"This will add a piece of information to make it simple for the FilterHasExportItemsValue to differentiate what is relevant - addProperty(item(), 'exportItemsStatus', if(equals(item()?['Export_Items'], null),'null', if(empty(trim(string(item()?['Expor","metadata":{"operationMetadataId":"576f83c6-f1cb-4d6c-920d-5f9f5ccc1db7"}},"InputArray":{"type":"Compose","inputs":"","runAfter":{},"description":"Ensure you place your array in the inputs here","metadata":{"operationMetadataId":"6e013c43-f0f5-49e1-b968-71117b4d23ec"}},"OutputArray":{"type":"Compose","inputs":"@union(\r\n    body('SelectNonExport'), \r\n    body('SelectExports')\r\n)","runAfter":{"SelectExports":["Succeeded"],"SelectNonExport":["Succeeded"]},"description":"This provides an array that you can use in subsequent actions by merging the SelectNonExport results and the SelectExport results to make one proper list without duplicates - union(body('SelectNonExport'), body('SelectExports'))","metadata":{"operationMetadataId":"b64f3be7-0db5-4a2e-808c-a8930e258fc4"}},"OutputCsvTable":{"type":"Table","inputs":{"from":"@outputs('OutputArray')","format":"CSV"},"runAfter":{"OutputArray":["Succeeded"]},"description":"This produces a CSV table","metadata":{"operationMetadataId":"17901388-356f-4bc4-a1ec-05563c2b4bc7"}},"OutputHtmlTable":{"type":"Table","inputs":{"from":"@outputs('OutputArray')","format":"HTML"},"runAfter":{"OutputArray":["Succeeded"]},"description":"This produces an HTML table","metadata":{"operationMetadataId":"b072dae0-1e89-4c35-85ad-0e768a203502"}}},"runAfter":{},"metadata":{"operationMetadataId":"2e572720-9da4-4138-b754-6ac302592f99"}}}

Output

So, using the below (in spoiler) sample data this resulted in the below:

Spoiler

[
  {
    "DCQ": 1,
    "Export_Items": [
      {
        "Title": "AG-S--1-AA-1",
        "minDQ": 2,
        "trancheCommodityBasePrice": 2,
        "trancheDCQ": 2,
        "trancheEndDate": "2024-01-11",
        "trancheID": 1,
        "trancheMDQ": 2,
        "trancheStartDate": "2024-01-09"
      },
      {
        "Title": "AG-P-Triangle-01-2-F-22",
        "minDQ": 1,
        "trancheCommodityBasePrice": 32,
        "trancheDCQ": 3,
        "trancheEndDate": "2024-01-11",
        "trancheID": 2,
        "trancheMDQ": 2,
        "trancheStartDate": "2024-01-04"
      }
    ],
    "MDQ": 1,
    "Title": "AG-S--1-AA-1",
    "clientName": "Agnew",
    "commodityBasePrice": 1.2,
    "endDate": "2024-01-31",
    "startDate": "2024-01-01",
    "transportCost": 1
  },
  {
    "DCQ": 1,
    "Export_Items": [
      {
        "Title": "AG-S--1-AA-7",
        "minDQ": 5,
        "trancheCommodityBasePrice": 2,
        "trancheDCQ": 2,
        "trancheEndDate": "2024-01-12",
        "trancheID": 1,
        "trancheMDQ": 2,
        "trancheStartDate": "2024-01-09"
      }
    ],
    "MDQ": 1,
    "Title": "AG-S--1-AA-1",
    "clientName": "Agnew",
    "commodityBasePrice": 1.2,
    "endDate": "2024-01-31",
    "startDate": "2024-01-01",
    "transportCost": 1
  },
  {
    "DCQ": 2,
    "Export_Items": {
      "Title": "AG-P-Triangle-01-2-F-22",
      "minDQ": 2,
      "trancheCommodityBasePrice": 32,
      "trancheDCQ": 2,
      "trancheEndDate": "2024-01-11",
      "trancheID": 1,
      "trancheMDQ": 2,
      "trancheStartDate": "2024-01-04"
    },
    "MDQ": 2,
    "Title": "AG-P-Triangle-01-2-F-2",
    "clientName": "Triangle",
    "commodityBasePrice": 2,
    "endDate": "2024-02-02",
    "startDate": "2024-01-02",
    "transportCost": 2
  },
  {
    "DCQ": 7,
    "Export_Items": null,
    "MDQ": 7,
    "Title": "AG-P-Triangle-01-7-AA-7",
    "clientName": "Triangle",
    "commodityBasePrice": 7,
    "endDate": "2024-01-25",
    "startDate": "2024-01-17",
    "transportCost": 7
  }
]

Actions

This provides a breakdown on each action and as I have been through most of it before this will mostly be brief.

InputArray

This is empty in the copy/paste so that you can drop in the value of whatever is producing your array.

SelectAddExportType

This is a new action that I've added, and it will add an extra piece of information which classifies the type of Export.

The very long expression in the below spoiler is essentially a long if/then/else logic which helps define what the exportItemsStatus. I've indented it so that it is easier to follow.

Spoiler

addProperty(
	item(), 
	'exportItemsStatus',
	if(
		equals(
			item()?['Export_Items'], 
			null
		),
		'null',
		if(
			empty(
				trim(
					string(item()?['Export_Items'])
				)
			), 
			'null', 
			if(
				startsWith(
					trim(
						string(item()?['Export_Items'])
					),
					'['
				), 
				'array', 
				if(
					startsWith(
						trim(
							string(item()?['Export_Items'])
						),
						'{'
					), 
					'object', 
					if(
						isInt(
							trim(
								string(item()?['Export_Items'])
							)
						), 
						'integer', 
						if(
							isFloat(
								trim(
									string(item()?['Export_Items'])
								)
							), 
							'floating', 
							'other'
						)
					)
				)
			)
		)
	)
)

FilterHasExportItemsValue

This has changed, so here is a little image of that:

... and here you can see where it uses the following advanced 'Where' expression to find relevant items.

@or(equals(item()?['exportItemsStatus'], 'array'), equals(item()?['exportItemsStatus'], 'object'))

As you can see the new classification in the previous action allows us to simply ask for any items which are an array or an object. 👍

SelectExports

This has changed, and here I have made it look a little more simple by switching to the normal Map view, and there are clear differences in the From/Map values.

From

Here this utilises the xpath() function to do pretty much all of the heavy lifting.

Spoiler

xpath(
    xml(
        json(
            concat(
                '{"r": { "c":', 
                string(body('FilterHasExportItemsValue')), 
                '}}'
            )
        )
    ),
    '/r/c/Export_Items'
)

The initial important part, here, is ensuring that the xml() conversion can properly understand what it is getting. So we have to place the value of the filter (as a string) inside an object ('r') with one property ('c') which holds the array of items from the filter action.

Then once that is converted to XML the xpath() expression reads *only* the Export_Items values from the array and objects fed through.

Map

All of the above means that each item() in the array will end up looking something like the following without some help:

{
  "$content-type": "xml/something blah blah",
  "$content": "sdfkushgkudhfgkudhfg-sdfgsidufghsdifguh_difudhfgidufhg+=="
}

Now ... that is just gibberish. So ... In order to help that along, I will show you how the DCQ value is correctly worked out into a proper integer value.

int(json(item())?['Export_Items/trancheDCQ'])

There you can see that the original item() that would otherwise be gibberish is placed inside a json() conversion function! Nice! This makes that nonsense a bit more understandable.

However, since you know for sure that the value will convert, and is needed to be in the integer format, then the final thing to do is to wrap an int() conversion function around the whole thing. This then ensures that the final value is a proper integer number that can be used accordingly.

OutputArray

I have separated this out so that you can reuse the data in this as you see fit for other actions down the line. This simply represents what I spoke about in the previous response with the union() function smashing together the two different sets of data that the flow has produced.

OutputCsvTable

This outputs your CSV table.

OutputHtmlTable

This outputs an HTML table should you wish it.

How To Paste Into My Clipboard Tab

I believe that this might only be available in the old 'V2' designer, but check the images in the below spoiler which should show you where to CTRL+V what you have copied.

Spoiler

Add action > My clipboard	CTRL+V

[eliotcole]

Yeah, I knew I'd forget one little bit ... it's not important, but I forgot to show you the outputs in the Outputs section above, @jaipalambati ... sorry about that! 😅