I have an excel file and want to bring a bunch of data from it to another file.
I've done it before and it worked. The way I did it was to use TEXTJOIN to summarize all of the data in a single string and put it in a table, then set up a Flow to fetch that table row and update a row in the target file. The concated string is then exploded and used to populate that file.
This works fine for one file, but when I try the same solution for another file the flow gets the value "#NAME?" instead of the joined string.
It's a fairly complex file with a ton of references between cells that eventually result in a string that looks something like this:
80|360|500|33|912|893|10|10|4|7|28|6|42|707|6|20|15|1045|1088|43|8|x|x|x|0|0|Sax|Bas|0|0|360|0|0|0|360|Orkester|0|0|0|0|0|0|0|0|0|0|0|500|0|0|0|0|0|0|0|0|0|0|0|500|Workshops|2|0|0|10|2|3|4|19|Annan|Aktivitet|0|0|10|20|0|0|30|Extra 1|2|3|4|5|6|7|8|9|10|11 dagar|1|2|3|4|5|6|7|8|9|10|11|Byte|0|0|0|0|0|0|44616|0|0|0|0|0|0|44702|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|Jajamensan|0|0|0|0|0|0|0|0|0|0|0|Jipp
I use a localized version of Excel with the Swedish alphabet, I don't know if that can mess something up.