You’re offline. This is a read only version of the page.
11
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:
Share
Reportitems('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 |
You have to change the mode to text mode, then you can input like @item()?['Financial \nYear 1']
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.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
All responses (
Answers (
