Group by Sharepoint List - send rows separately

[baxschwepo]

Hi members, 

I have a sharepoint List containing order data. There is an order_id (pruefschritt_f_id) as foreign key and then some lines with material with this foreign key (in the following example pruefschritt_f_id 2981 and 2980.

I want to send out emails for each order containing the material lines for invoicing. 

What I did so far: 

Output looks good:

grouping works, output is grouped..

Apply to each works properly, 

But the output is empty:

When I replace the [current item] of  [filter array 2] by manually with 2981 it works.

So, somehow it is connected to the "current item" variable / object, but I cannot "look" inside the variable...where is the error??

Anybody knows what to do? 

Here the overview of my actions:

[baxschwepo · Accepted solution]

Hi to all, 

found it out myself: the reason was that the variable contained Json Item: "OrderNo": 2981, so the filter function worked but of course not with the correct value. 

To get just the foreign key you need to enter the following expression: 

items('Apply_to_each')['OrderNo']

Ah, I am glad...it is so cool to achieve things !!

Best 

SwiPowE