How to load excel data and put it into outlook content

How To
1

I want to load excel data and put it into outlook email content so I use list worksheet rows module

However, the output of list worksheet rows module is bundle and each row is one bundle.

I want to put all rows into outlook email content so I use array aggregator module to aggregate all bundles from list worksheet rows module then use compose a string module to create the content to put into email. However, when I use map function in compose a string module, the output is empty. Please help to check why I can get the data from array aggregator module.
what I do in as below :

{{map(2.array; “brand”)}}

Here is my flow :

image
image1430Ă—602 46 KB

Array output :

image
image946Ă—1424 131 KB

compose a string output

image
image918Ă—1018 51.6 KB

3

Welcome to the Make community!

You might be using an incorrect aggregator type. Try a Text Aggregator.

Combining Bundles Using Aggregators

Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.

You can find out more about the other types of aggregator modules here:

Question: Which is the best aggregator do you think you’ll need for your use-case?

Example

Here is an example of how your scenario could look like:

This is just an example. Your final solution may or may not look like this depending on your requirements and actual data.

For more information, see “Mapping with arrays” in the Help Centre. You should also do the Make Academy, which also covers the use of Iterators & Aggregators.

Hope this helps! If you are still having trouble, please provide more details.

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

1 Like