web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to Select columns ...
Power Automate
Answered

How to Select columns from HTML table

(0) ShareShare
ReportReport
Posted on by 24

Hi, 


So I have this flow to create an HTML table based upon an excel table. The problem is that I am getting two undesired columns (odata.etag and internalidsomething), I am not sure how can I use the SELECT operation to select only the desired columns. The flow is in Portuguese, but basically I get the rows from excel, create an HTML, Compose to style the table and finally I send an email

 

flow.png

These are the Headers of the table, and I would like to remove the first 2.

flowbi.png

 

 

Categories:
I have the same question (0)
  • Verified answer
    CU-18081211-6 Profile Picture
    9,270 Moderator on at

    Hi @nailepmac ,

    Use:

    gabibalaban_1-1613926777280.png

    Use show advanced option, set columns to Custom and then define your columns headers / values.

     

    Hope it helps !

  • nailepmac Profile Picture
    24 on at

    Hi It worked!!

    Thanks

  • nich3play3r Profile Picture
    249 on at

    I've created an HTML table from an array variable. In the Create HTML Table dialog custom columns dialog, how do I reference items from my array? Thanks!

  • CU-18081211-6 Profile Picture
    9,270 Moderator on at

    item()[‘column_name’]

  • nich3play3r Profile Picture
    249 on at

    Thanks very much for this, @gabibalaban . I've been fidgeting with the format here for much longer than I care to admit. I sure do wish the Values field would have a dropdown from my array values in this setup!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard