join consecutive key/value pairs in an array.

(0) Share

Report

Posted on by rleonen

Hi,

I have an array of key/value pairs that looks like this:

[
{
"ID": "https://knowledgebase.com/link_to_article_1"
},
{
"Title": "Title of Article 1"
},
{
"ID": "https://knowledgebase.com/link_to_article_2"
},
{

"Title": "Title of Article 2"

}
]

How can I combine consecutive array elements so that it looks like this instead?

[
{
"ID": "https://knowledgebase.com/link_to_article_1",
"Title": "Title of Article 1"
},
{
"ID": "https://knowledgebase.com/link_to_article_2",
"Title": "Title of Article 2"
}
]

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @rleonen ,

You need to use Select action to get the required data. This action maps the data from input to output.

in your case all you need to do map like this

ID --> item()?['ID']
Title-->item()?['Title']

Thanks

Was this reply helpful? Yes No
rleonen 8 on at

Like (0)

Report
Copy link

Link copied!

That suggestion is close but I don't get the consecutive rows combined into a single element. The output after using the 'Select' action now looks like below. Is there a way to combine the consecutive rows into a single element?
[
  {
    "ID": "https://danahertest.cherwellondemand.com/CherwellPortal/Beckman/Command/Queries.GoToRecord?BusObID=KnowledgeArticle&PublicID=11655",
    "Title": null
  },
  {
    "ID": null,
    "Title": "Document Needs to Have World Read Permission"
  },
  {
    "ID": "https://danahertest.cherwellondemand.com/CherwellPortal/Beckman/Command/Queries.GoToRecord?BusObID=KnowledgeArticle&PublicID=13361",
    "Title": null
  },
  {
    "ID": null,
    "Title": "NAO How to create Jira Change Requests for L&D IT North America team"
  }
]

Was this reply helpful? Yes No
Paulie78 8,424 Moderator on at

Like (0)

Report
Copy link

Link copied!

Take a look at this screenshot (I also included run history on right hand side). It does what you want. If you have any trouble following, I will explain in more detail:

https://ibb.co/v42ZHFZ

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @rleonen

A lot simpler way of doing it, is just by using a select like @ManishJain has suggested and using some of @Paulie78 length logic. It can be done in one simple action as follows:

Your from is
range(0,div(length(outputs('Compose')),2))
which is a range from 0 to the length of the array divided by 2

Your ID value is:
outputs('Compose')[mul(item(),2)]?['Id']
which is the range value multiplied by 2, i.e. 0,2,4,6,8 .....

Your Title ID is:
outputs('Compose')[add(mul(item(),2),1)]?['TItle']
which is the same as above +1, i.e. 1,3,5,7,9 ....

The flow runs as follows:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
rleonen 8 on at

Like (1)

Report
Copy link

Link copied!

Thanks Damien - solution works perfectly!

Was this reply helpful? Yes No