FILTER ARRAY AND CREATE ARRAY

[LitHouse]

Hello,

I have been trying to solve this by myself for hours, looked for and tried various methods and none of them worked.
My case is, I have a file with records of my expenses, with multiple ID's in one excel sheet, like that:

And there is also a second sheet, which is a summary of the record table, so it looks like that for now:

In order to SUM the AMOUNT of all expenses that apply to a specific job I used the excel function:
=SUMIF(Table_1[ID],Table_2[AMOUNT])
and that works great.

BUT. I would like to have all the workers that worked by this job in the column WORKERS, in a form like this:

And I thought, this should be an extremally easy flow, I was mistaken though. I started with:

So I just simple got all the rows from both tables. Then of course, I went with the filter array. I compared the ID from one table to another:

And this is actually where I got stuck, an example, of one of many filter array results is:
"

[

  {

    "@odata.etag": "",

    "ItemInternalId": "xxx",

    "ID": "192",

    "NAME": "xxx",

    "AMOUNT Brutto": "0",

    "WORKER": "WORKER 1",

  },

  {

    "@odata.etag": "",

    "ItemInternalId": "xxx",

    "ID": "192",

    "NAME": "xxx",

    "AMOUNT Brutto": "0",

    "PRACOWNIK": "WORKER 2",

  },

  {

    "@odata.etag": "",

    "ItemInternalId": "xxx",

    "ID": "192",

    "Nazwa Klienta": "xxx",

    "AMOUNT Brutto": "184.5",

    "WORKER": "WORKER 3",

  }

]

"
What should be done now is to extract the "WORKER" items from the object above and combine them into an array, then just update the right row in excel, end of story. But I just can not extract, neither combine them in an array.
I have tried this method:
https://powerusers.microsoft.com/t5/General-Power-Automate/How-do-I-get-all-values-from-outputs-in-a...

And it looked like this:

The problem is, I have hundreds of rows in the main table, and a thousand of them in the second table, and the flow did not compose a variable for each of the individual "IDs", it just kept adding and adding them, so for the 50th item the result was like:
"WORKER1, WORKER 2, WORKER 1, WORKER 5, WORKER 4, WORKER 3, WORKER 5, WORKER 1, WORKER 2, WORKER 3, WORKER 4... etc.", so many Workers.

I am hoping there is an easy and convenient way to solve it. I just don't know it. If anyone is able to help, I will be very gratefull.
Thanks 🙂

[ChadVKealey]

Honestly, this looks like a job for PowerBI. I don't really know how to do it in PowerBI, but I think that is the better tool for the job.  

If you're committed to doing this via Power Automate, using a Select action inside that loop will simplify things a little bit and probably speed it up quite a bit.

[LitHouse]

Ahh... I am committed to do this in Power Automate, this sheet is connected to bunch of other sheets and has some other details too, its my "Mastermind" sheet. 

But I tried everything now, I give up. I am hoping for someone to rescue me otherwise I will be testing this method:
https://www.extendoffice.com/documents/excel/2723-excel-concatenate-based-on-criteria.html
and maybe doing it in excel will be possible.

[LitHouse]

DID IT !! Had to take 2 steps back and go to the list where actually all of the records appear in the first place. Then I did a flow which looks like that:

And every time an item is created or uploaded in the list of jobs, the triggered flow creates an array of workers for this particular ID, even with their role now and puts it into the correct place:

Maybe this will help someone in the future.