Array where every second item is column header

[AndersAukrust]

I have an array of data where every second item is a column header. I want to convert this to one row of data with column headers. This data will later in flow be inserted into SharePoint list. 

Sample array:

Header1

Value1,

Header2,

Value2,

Header3,

Value3

[HenWang]

Hi @AndersAukrust ,

For this issue, I created two variables to store the described array in your request and the object converted from this array. Please refer to below process:

By the way, this flow can only work for array with fixed number of headers inside and need to update these values by manually typing their names. You can follow this flow as an example and do the customizations from your side to achieve your request.

Variable test_array:

Variable one_row:

Expression inside the value:

{

  variables('test_array')[0]: variables('test_array')[1],

  variables('test_array')[2]: variables('test_array')[3],

  variables('test_array')[4]}: variables('test_array')[5]

}

Then you can use the update Item action to do the update:

Expression:

variables('one_row')?['Header1']

variables('one_row')?['Header2']

variables('one_row')?['Header3']

This is the result:

Hope this flow can help.

Best Regards,

Hen Wang

[AndersAukrust]

Hi,

Thank you. But the flow need to work with different count of headers. This is actually results from "magic form" (website form) which is recieved on email. and since not all questions in the form is mandatory, the count of headers will be different from time to time. 

[grantjenkins · Accepted solution]

As long as you have a Header/Value pair for each, this should work for any number of items.

See full flow below. I'll go into each of the actions.

Compose contains your array of Headers/Values.

Select uses the output from Compose but chucks it into groups of two (Header and Value). Below are the expressions used.

//From
chunk(outputs('Compose'), 2)

//Header
item()[0]

//Value
item()[1]

After running the flow, you would get the following output. You could then loop over each of the items and update your SharePoint List as required.

[
  {
    "Header": "Header1",
    "Value": "Value1"
  },
  {
    "Header": "Header2",
    "Value": "Value2"
  },
  {
    "Header": "Header3",
    "Value": "Value3"
  }
]

[AndersAukrust]

Thank you. This solved my problem!