Answered

Handling Excel header on two lines

(0) Share

Report

Posted on by norocdinu

Hi.
I have an interesting situation.
I need to update an Excel table with some data from another Excel.
When I try to map rows in step "Add a row into a table", I have difficulties with some column names.
I am pulling items from step "Filter array" with an expression like this:

items('Apply_to_each_row')?['Column1']

but when I try to use it for a column that has the header on two lines, flow is just ignoring those columns.

I tried to paste the name as it is on 2 lanes, then to put it on only one name, and using the name like is in the output from "Filter array" that looks like this

Text one \ntext two kg

but no luck so far. Is there a special way to handle this situations?

Column1	Column 2	Text one text two kg
Abcd	Bcde	100

Screenshot 2022-08-09 174317.png

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

v-bofeng-msft on at

Like (1)

Report

Hi @norocdinu ,

Please try:

['Text one

text two kg']

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

norocdinu 11 on at

Like (0)

Report

Thank you for your suggestion. I have tried this with no success. However I solved the problem with an intermediary step. I parsed JSON and that gave me the column names in the dynamic content window which I used to add rows to a table.

Was this reply helpful? Yes No
Thomas Luo Microsoft Employee on at

Like (1)

Report

You have to change the mode to text mode, then you can input like @item()?['Financial \nYear 1']

Was this reply helpful? Yes No