Skip to main content

Notifications

Community site session details

Community site session details

Session Id : aKKV0KM1hnKQdSlPO2igxH
Power Automate - Building Flows
Answered

Listin excel table rows using array and select

Like (0) ShareShare
ReportReport
Posted on 6 Feb 2023 20:48:32 by

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

 

JosueViq_0-1675715766696.png

 

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

JosueViq_1-1675715966151.png

 

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

JosueViq_2-1675716143298.png

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

  • Community Power Platform Member Profile Picture
    on 06 Feb 2023 at 22:59:11
    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 Profile Picture
    10,940 Super User 2025 Season 1 on 06 Feb 2023 at 22:23:10
    Re: Listin excel table rows using array and select

    Hi @Anonymous ,

     

    In my demo flow I see the following Dynamic content:

    Snag_5cc222b.png

    (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:

    Snag_5cdfbcd.png

     

    (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:

    Snag_5d72572.png

    Snag_5d375a8.png

     

    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 Platform Member Profile Picture
    on 06 Feb 2023 at 21:55:09
    Re: Listin excel table rows using array and select

    @ekarim2020Im not able to see those options in my flow

    JosueViq_4-1675720492086.png

     

  • Ellis Karim Profile Picture
    10,940 Super User 2025 Season 1 on 06 Feb 2023 at 21:50:06
    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:

    Snag_5ba6eeb.png


    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 Platform Member Profile Picture
    on 06 Feb 2023 at 21:44:07
    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

    JosueViq_0-1675719709038.png

     

    Im still getting null values for those columns

    JosueViq_1-1675719833774.png

     

     

  • Ellis Karim Profile Picture
    10,940 Super User 2025 Season 1 on 06 Feb 2023 at 21:32:46
    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:

     

    Snag_5a57df5.png

    Snag_5a81d87.png

     


    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 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 69

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 66 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 42 Super User 2025 Season 1

Overall leaderboard