Hi, I'm manipulating an array that comes from an excel table, later in my flow I'm using a "Select data operation" to create an HTML table with only the excel columns I'm interested in. But I'm having troubles selecting the columns that has two or more words in the name, Im going to add screenshots to explain myself
Here I'm listing the rows of an excel table to later filter an array from the values/body of that table
Then I'm using a select to select a few columns, for example, Im using item()?['Ticket Stage'] to get the value from the excel column with that name
Finally, I create a HTML table with the select's output and add it to an email, but when I receive the email all the columns that has a name with two or more words have empty values in the HTML table
This is the input of the select
[
{
"@odata.etag": "",
"ItemInternalId": "467ea17c-7677-49f2-b562-aa36bbc07196",
"ID": "36",
"Start time": "2023-02-06T01:06:10.000Z",
"Completion time": "2023-02-06T01:06:29.000Z",
"Email": "*********",
"Name": "Josué Víquez",
"Ticket RFC number\n": "554455",
"Description": "Testing",
"Comments": "rfc follow testing",
"Ticket Stage\n": "To be checked",
"Category": "RFC Follow up"
}
]
And this is the output
[
{
"Ticket RFC number": null,
"Ticket Stage": null,
"Description": "Testing",
"Comments": "rfc follow testing",
"Last Assignee": "Josué Víquez"
}
]
As you can see, Im getting and /n in the columns with two or more words, just as "Ticket RFC number\n"
But when I tried to get the value with item()?['Ticket RFC number'] I get a null, I also tried with item()?['Ticket RFC number\n'] but didn't work
It's weird but there is no way for me to find the columns in the dynamic content
Second option worked ok, thank you for your advice.
Hi @Anonymous ,
In my demo flow I see the following Dynamic content:
(1) I'm not sure why you are not seeing the dynamic content. You can try to search for the column to see if it shows up:
(2) Another option, though not my preferred option, is to use an expression to create a string that contains both the column name and a new line character. For example:
item()?[concat('Ticket RFC number',outputs('ComposeNL'))]
{
"Ticket RFC number": "554455",
"Ticket Stage": "To be checked",
"Description": "Testing",
"Comments": "rfc follow testing",
"Last Assignee": "Josué Víquez",
"Ticket RFC number 2": "554455"
}
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
Hi @Anonymous ,
Don't use any expressions for the Select action, but use Dynamic content, for example:
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
Hi @ekarim2020 , thanks for your response
Im trying what you said, but only selecting the Ticket RFC number for testing, using item()?['Ticket RFC number'] and item()?['Ticket RFC number\n'] and still not working
Im still getting null values for those columns
Hi @Anonymous ,
The \n in the column name "Ticket RFC number\n" likely indicates that there is a return (new line) character in the column name.
Try changing the order of the actions by placing the Select action after "List rows present in a table" as shown:
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
stampcoin
69
Michael E. Gernaey
66
Super User 2025 Season 1
David_MA
42
Super User 2025 Season 1