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

Community site session details

Session Id :
Power Automate - General Discussion
Answered

How to remove iteminternal id and odata.etag columns

(0) ShareShare
ReportReport
Posted on by 22

Hi all, I am trying to extract data from an excel file and display it in an email where there is a specific value that has been met. However, it has been giving me this extra 2 columns while displaying the html table. Any headway to this?

 

TrucoBen123_0-1637648279789.png

 

MY FLOW:

TrucoBen123_1-1637648301680.png

 

I have the same question (1)
  • Verified answer
    CU-18081211-6 Profile Picture
    9,266 Moderator on at
    Re: How to remove iteminternal id and odata.etag columns

    @TrucoBen123 ,

    Use a select action after the filter array action, and in it create the output for HTML table, column name - value. 

    gabibalaban_0-1637667105178.png

    From -> body('Filter_array');

    Map - > Key - Value. 

    Also, Can you take in consideration to use ODATA filter inside "List rows present in a table" instead of bringing all values to flow and filter it locally ? (this is applied only if the filter condition is not to complex, as the Excel connector doesn't support many operations).

    Of course, that in this case the From from the new select action will be

    (use the Add dynamic content ->expressions):

    body('List rows present in a table')['value']

     

    Hope it helps !

     

  • TrucoBen123 Profile Picture
    22 on at
    Re: How to remove iteminternal id and odata.etag columns

    What is the key and value for the map section?

     

    TrucoBen123_0-1637800581119.png

     

  • CU-18081211-6 Profile Picture
    9,266 Moderator on at
    Re: How to remove iteminternal id and odata.etag columns

    @TrucoBen123 ,

    key = the desired name of the column in the resulted array of objects,

    value = item()?[‘name_the_column_from_Excel’]

  • TrucoBen123 Profile Picture
    22 on at
    Re: How to remove iteminternal id and odata.etag columns

    Ok Thanks

  • JJJF Profile Picture
    2 on at
    Re: How to remove iteminternal id and odata.etag columns

    Hi, 

     

    when I do this I automatically get apply to each.  and I can't use that dynamic content 

  • Suggested answer
    CU09121240-0 Profile Picture
    6 on at
    How to remove iteminternal id and odata.etag columns
    Hi,
     
    For those still looking for a solution on this challenge, I have written an article on how you can remove the two columns dynamically, without hard-coding any columns. I have had this solution working in a production envirtonment for a few weeks, having been fully reliable.
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 535 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 348 Moderator

#3
developerAJ Profile Picture

developerAJ 262

Last 30 days Overall leaderboard