Append Labeled Array to New Empty Array

(0) Share

Report

Posted on by IPC_ahaas

1,387 Moderator

I am looping through the array AllSiteEmployees.

Within that loop, I am filtering the array AllChipAwards for the current item in the loop.

This works.

When a match is found, I want to append the result (body) to a new array AllSiteChipAwards.

When I try to use "Append to Array Variable", it says I cannot append an array to an array.

When I try to use "Append to String Variable", it appends, but the resulting data is a mess:

How can I create an array of these?

"EmployeeName": "Jane Doe",

"EmployeeID": "6237M",

"GrantedBy": "Jon Doe",

"GreenChips": "+1",

"RedChips": null

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

Can you show your full flow? I think the logic might need a bit of adjusting.

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report

Basically what I'm trying to do is run a report of all chips given out for a time period, by Site for a given time period. The log of chips given has employee information, but not Site. A separate list has all employee info including Site.

1. Get AllSiteEmployees "EmployeeIDs" and put them in an Array

2. Get AllChipTransactions and use Select the values I want

3. Initialize an empty array AllSiteChipAwards

4. Loop through the AllSiteEmployees array and for each loop, filter the AllChipAwards array for the current item, then append that result to AllSiteChipAwards

and this is where we're at now. I either can't create the AllSiteChipAwards array or I get a messy string.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

Are you using a Filter Query in the Get Items action? If not, I'd recommend doing that first. Only returning items from your specified time period. Otherwise you'll be unnecessarily looping through a bunch of items that you don't need to loop through.

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report

Yes, I am using filter query to limit the date range. This has nothing to do with my issue.

Was this reply helpful? Yes No
Verified answer

IPC_ahaas 1,387 Moderator on at

Like (0)

Report

I figured this out on my own. The only way I could move forward was to put the result of the filter in it's own "Apply to Each" and then putting the "Append to Array Variable" inside that.

Was this reply helpful? Yes No