Skip to main content

Notifications

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

 

  • Suggested answer
    CU09121240-0 Profile Picture
    CU09121240-0 4 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.
     
  • JJJF Profile Picture
    JJJF 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 

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

    Ok Thanks

  • CU-18081211-6 Profile Picture
    CU-18081211-6 9,261 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
    TrucoBen123 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

     

  • Verified answer
    CU-18081211-6 Profile Picture
    CU-18081211-6 9,261 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 !

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard