# Problems with MQTT flow after Excel import and msg modifications

**URL:** <https://discourse.nodered.org/t/problems-with-mqtt-flow-after-excel-import-and-msg-modifications/78030>\
**Category:** General\
**Created:** [29 April 2023 10:17 UTC](https://discourse.nodered.org/t/problems-with-mqtt-flow-after-excel-import-and-msg-modifications/78030 "2023-04-29T10:17:30Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [29 April 2023 10:50 UTC](https://discourse.nodered.org/t/problems-with-mqtt-flow-after-excel-import-and-msg-modifications/78030/2 "2023-04-29T10:50:20Z")

</div>

I suspect it is one of the JSONata expressions, as explained in your OG thread you may need to force an array

> [@How to create payloads (strings merged/concatenated from array objects) from Excel data?](https://discourse.nodered.org/t/how-to-create-payloads-strings-merged-concatenated-from-array-objects-from-excel-data/68050/14):
>
> Unless only one is returned. To force that to an array, [$keys()] would `force a single result to a single array, it would not affect a array with multiple values.

Please supply the data going into `change key and ip` functions so i can test.

---

_[View the full topic](https://discourse.nodered.org/t/problems-with-mqtt-flow-after-excel-import-and-msg-modifications/78030)._