cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
baxschwepo
Helper I
Helper I

Group by Sharepoint List - send rows separately

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: 

 

baxschwepo_0-1616134750039.png

Output looks good:

baxschwepo_2-1616134946742.png

 

 

baxschwepo_1-1616134825207.png

grouping works, output is grouped..

 

baxschwepo_3-1616134999006.png

baxschwepo_5-1616135163848.png

Apply to each works properly, 

baxschwepo_4-1616135030283.png

But the output is empty:

baxschwepo_6-1616135211238.png

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_7-1616135444122.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
baxschwepo
Helper I
Helper I

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

View solution in original post

1 REPLY 1
baxschwepo
Helper I
Helper I

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

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,796)