Unanswered

Split incoming array into two different arrays

(0) Share

Report

Posted on by Community Power Pla...

Hi all, array question here. I have a button in Power BI that brings in data, which I put into an array via compose. An entry in the resulting array looks like this:

Spoiler (Highlight to read)

{

"Field 1": "1234",

"Field 2": "5678 - Name1 - Name2",

"Field 3": "OPEN",

...

"Field8": 2022,

"Field9": "1/2/3/4",

"Field10": 3,

"Field11": String"

},
etc.

{ "Field 1": "1234", "Field 2": "5678 - Name1 - Name2", "Field 3": "OPEN", ... "Field8": 2022, "Field9": "1/2/3/4", "Field10": 3, "Field11": String" },etc.

I'd like to split the array in two, so I get one array that contains fields 1-7 and a second one that contains fields 8-11, then add a GUID created earlier in the flow into each so I can link them together if necessary.

I tried something like creating two array variables, and then loading data into one or the other with an "apply to each" to the original array, but I wasn't able to get it to work. I'm still new enough to Power Automate that I'm still trying to understand the data operations. Is this doable?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Output:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @SudeepGhatakNZ - thanks so much for the detailed response! I think I'm 90% of the way there, just getting a couple remaining errors. My Parse JSON step looks like the following:

However, both of the Append to Array steps at the end throw this error:
I'm assuming it's a problem with my Parse step. Do I need to run a Apply To Each to loop through the array? What am I missing?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

If your Parse JSON step is returning an array, shouldn't the Append step be inside a loop?

Are you able to share the entire output of your Compose PBI Data to array action?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @SudeepGhatakNZ,

@SudeepGhatakNZ wrote:
If your Parse JSON step is returning an array, shouldn't the Append step be inside a loop?
I wouldn't know, that's the kind of thing I'm trying to figure out by asking.

When the Power BI trigger is hit, it returns this:
Spoiler (Highlight to read)
{
  "type": "object",
  "properties": {
    "rows": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "entity": {
            "type": "object",
            "properties": {
              "Power BI values": {
                "title": "Power BI data",
                "type": "array"
              }
            },
            "required": [
              "Power BI values"
            ]
          }
        },
        "required": [
          "entity"
        ]
      }
    }
  },
  "required": [
    "rows"
  ]
}
{  "type": "object",  "properties": {    "rows": {      "type": "array",      "items": {        "type": "object",        "properties": {          "entity": {            "type": "object",            "properties": {              "Power BI values": {                "title": "Power BI data",                "type": "array"              }            },            "required": [              "Power BI values"            ]          }        },        "required": [          "entity"        ]      }    }  },  "required": [    "rows"  ]}
I use the Compose Power BI Data step to extract the actual contents, the full output which looks like below. Each Power BI output will contain 5-10 elements of 20 fields each. I'm trying to split this one set into two different arrays, one of fields 1-10, and another of fields 11-20.

Then for each of those new arrays, I would like to add a new field at the end of each named "GUID" that contains the output of my guid() step.

Spoiler (Highlight to read)
{
    "Field 1": "x",
    "Field 2": "x - 2",
    "Field 3": "OPEN",
    "Field 4": "Brand",
    "Field 5": "Address",
    "Field 6": 0,
    "Field 7": 2190,
    "Field 8": 2445,
    "Field 9": -255,
    "Field 10": -0.104,
    "Field 11": 0.209,
    "Field 12": 0.212,
    "Field 13": -0.00,
    "Field 14": 2022,
[etc.]
  hoping for: "Field 20": guid output
  },
[repeat 5-10 times with different values]
  },
{    "Field 1": "x",    "Field 2": "x - 2",    "Field 3": "OPEN",    "Field 4": "Brand",    "Field 5": "Address",    "Field 6": 0,    "Field 7": 2190,    "Field 8": 2445,    "Field 9": -255,    "Field 10": -0.104,    "Field 11": 0.209,    "Field 12": 0.212,    "Field 13": -0.00,    "Field 14": 2022, [etc.]   hoping for: "Field 20": guid output  }, [repeat 5-10 times with different values]  },
Thanks for the help. I feel like this should be easier than I'm making it.

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report
This is what I mean. Since the field values are repeated for each item in the PARSE JSON output, if you reference any of the fields, it should generate a loop as shown below.

I have simple pasted the following input in the compose action.

[{
"Field 1": "x",
"Field 2": "x - 2",
"Field 3": "OPEN",
"Field 4": "Brand",
"Field 5": "Address",
"Field 6": 0,
"Field 7": 2190,
"Field 8": 2445,
"Field 9": -255,
"Field 10": -0.104,
"Field 11": 0.209,
"Field 12": 0.212,
"Field 13": -0.00,
"Field 14": 2022
},{
"Field 1": "x",
"Field 2": "x - 2",
"Field 3": "OPEN",
"Field 4": "Brand",
"Field 5": "Address",
"Field 6": 0,
"Field 7": 2190,
"Field 8": 2445,
"Field 9": -255,
"Field 10": -0.104,
"Field 11": 0.209,
"Field 12": 0.212,
"Field 13": -0.00,
"Field 14": 2022
}]

Was this reply helpful? Yes No