Answered

Listin excel table rows using array and select

(0) Share

Report

Posted on by Community Power Pla...

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

All responses (6)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Listin excel table rows using array and select

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.
Verified answer

Ellis Karim 11,105 Super User 2025 Season 1 on at

Like (0)

Report
Re: Listin excel table rows using array and select

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
Community Power Pla... on at

Like (0)

Report

Re: Listin excel table rows using array and select

@ekarim2020Im not able to see those options in my flow
Ellis Karim 11,105 Super User 2025 Season 1 on at

Like (0)

Report

Re: Listin excel table rows using array and select

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
Community Power Pla... on at

Like (0)

Report

Re: Listin excel table rows using array and select

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
Ellis Karim 11,105 Super User 2025 Season 1 on at

Like (0)

Report

Re: Listin excel table rows using array and select

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