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
