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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to remove iteminte...
Power Automate
Unanswered

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

 

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

    @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

    What is the key and value for the map section?

     

    TrucoBen123_0-1637800581119.png

     

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

    @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

    Ok Thanks

  • JJJF Profile Picture
    2 on at

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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard