Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

#NAME? error when fetching row from Excel

Posted on by

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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,473

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,659

Leaderboard