# Map Bundle Output to return a dynamic value (similar to mapping an array)

**URL:** <https://community.make.com/t/map-bundle-output-to-return-a-dynamic-value-similar-to-mapping-an-array/33044>\
**Category:** Questions\
**Tags:** arrays, excel\
**Created:** [April 8, 2024, 6:56am UTC](https://community.make.com/t/map-bundle-output-to-return-a-dynamic-value-similar-to-mapping-an-array/33044 "2024-04-08T06:56:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexey88](https://avatars.discourse-cdn.com/v4/letter/a/dc4da7/32.png) [@Alexey88](https://community.make.com/u/Alexey88)\
**Post date:** [April 8, 2024, 6:56am UTC](https://community.make.com/t/map-bundle-output-to-return-a-dynamic-value-similar-to-mapping-an-array/33044/1 "2024-04-08T06:56:43Z")

</div>

How do I use the map() function or similar to search a module output bundle?

I am using [make.com](http://make.com) to look-up a cell in excel where the Excel Retrieve Data module is given a single cell to pull data from, using a variable “{{79.output}}”

As this variable changes (ie C:13 to H:4).the modules bundle output then changes from bundle1.row.c.value to bundle1.row.h.value as well. (Screenshot 2)

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/3/e3023ef898808503393d82770198df3108a1ffec.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/1/21d89a52458298f0271eb50285d1667c50b7b5a0.png)

This then creates a problem as I cannot use the Excel Get Data module’s output to map it to the next module, since this output item’s name keeps changing:

ie. bundle1.row.c.value-\> bundle1.row.d.value → bundle1.row.h.value

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/8/48dc418133db3228d668d5b2b7cc8167c7479442.png)

I have even tried to aggregate the bundle output into an array, and use the map() function to search for an item within the array, however [make.com](http://make.com) does not like this for some reason.  
" BundleValidationError  
Validation failed for 1 parameter(s).

- Invalid number in parameter ‘UnitPrice’."

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/b/1bc208742ed0aef552038cb8f4aea303b32bdc85.png)

One solution COULD be to use the same initial input variable for the target cell to dynamically specify the bundle name. but neither of these formats are accepted by [make.com](http://make.com)

{{127.array[].row.{{79.output}}.value}}  
bundle1.row.[output].value

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/4/f4eafcf384657eab2e33aba3fd660cdad192851c.png)

Can anybody please help me change the mapping of a module’s output to use a dynamic reference or a search function that can retrieve the data ?

---

<div class="post-metadata">

**Author:** ![Jock\_Learns](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/jock_learns/32/33903_2.png) [@Jock\_Learns](https://community.make.com/u/Jock_Learns)\
**Post date:** [May 8, 2024, 8:13am UTC](https://community.make.com/t/map-bundle-output-to-return-a-dynamic-value-similar-to-mapping-an-array/33044/4 "2024-05-08T08:13:02Z")

</div>

Hey @Alexey88, nice to meet you. 🙂

I think the get() function can help here, maybe together with a map() function.  
If you still need some help, I’m happy to take a look at it. Can you download a sample OUTPUT bundle from the MS 365 Excel module where you want to extract the data and share it here?

~ Jock

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [August 6, 2024, 8:19am UTC](https://community.make.com/t/map-bundle-output-to-return-a-dynamic-value-similar-to-mapping-an-array/33044/5 "2024-08-06T08:19:12Z")

</div>


