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:
Solved! Go to 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
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
12 | |
10 | |
10 | |
9 | |
6 |
User | Count |
---|---|
26 | |
20 | |
12 | |
10 | |
7 |