How to list the each row of excel and also add a sum to email content

Questions
1

I have two excel sheets,

  1. the first sheet is vender contact list (one vender one row)
  2. the second sheet is vender product list (one vender to multiple rows) and each row has 3 columns - brand, item_id, quantity
  3. Objective : I want to use the two sheets to create email draft, one email per vender and the email content will show the product list from second sheet and the sum of quantity. Now I can successfully show the product list by using text aggregator but when using sum(quantity), it will not sum but still show quantity by each item_id. Since the output of excel list worksheet rows is not an array so I can’t use map as well. May I know how to do it ? thank you
    Here is my flow :

image
image2688×736 103 KB

set up for text aggregator

image
image1780×862 82.4 KB

1 Like
3

Hey there,

I assume you want to sum all the entries right? You can have a router with a sum aggregator doing that and then use the Make magic formula to bring that back to the main route and combine it with the text aggregator output.

4

Hello,

What’s the point of creating multiple threads with the same problem? Are you facing any new problems not mentioned earlier?

Have a nice day,

5

Hi Stoyan, thanks for your reply. can you elaborate more about how to use router with a sum aggregator and bring it back to the main route ? thank you

6

Hi, it’s the same data set but totally different question so I create separate thread, thank you

7

Add a router after the second search module and have the first route be with the sum aggregator and a set variables module after it, then have the rest of the scenario on the second route with a get variables module after the aggregator to grab the result from the sum aggregator.

8

I tried what you said but when I use the second route with get variables module, it can not select the set variable module from first route. My flow look like as below :

image
image2246×764 95.1 KB

9

You dont select it, just type it in.

{{57.sum}} for example, where in this case sum is the name of the variable.

10

Yeah that’s tricky, intuitively I will try to find out where to select but for get variable module I neet to type the name of the set variable if it is in different path. Tricky but finally solved !!