Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file

(0) ShareShare
ReportReport
Posted on by

Hi, while converting excel to .csv there are two ("@odata.etag","ItemInternalId") extra columns added in .csv file. How can I skip creation of these two columns in my .csv file...these columns are not required. Also, I want the flow to be reading multiple excels and creating .csv so I can't select specific columns or hard-code it...as i's different in all tables. Any suggestions how to resolve this issue?

 

[
  {
    "@odata.etag""",
    "ItemInternalId""2......",
........
}
]

 

  • Suggested answer
    CU09121240-0 Profile Picture
    CU09121240-0 4 on at
    How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file
    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.
     
  • swapnilwani20 Profile Picture
    swapnilwani20 6 on at
    How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file
    I faced the similar issue, to remove/hide unwanted columns from HTML Table, we can use Create Table action with Columns value as "Custom" and you can select your required columns only. Below screenshot for your reference.
     
    Please mark this as resolved if you this solution works for you.
    Thanks!
     
  • na12063 Profile Picture
    na12063 50 on at
    Re: How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file

     

    https://powerusers.microsoft.com/t5/Building-Flows/How-to-eliminate-odata-etag-and-ItemInternalId-columns-while/td-p/1456032

  • Re: How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file

    Hi,

     

    Even I am facing the same issue, can you please share what workaround worked for you?

     

    Thanks

    Priyank

  • DaveDodge Profile Picture
    DaveDodge 24 on at
    Re: How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file

    Seems like a big miss.  These data values are not present in the tables that we are parsing, they are not expected or wanted, and we shouldn't have to jump through magical hats to make them disappear.  Please fix this.  This is a big problem.

  • Dnyaneshwar Profile Picture
    Dnyaneshwar 7 on at
    Re: How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file

    Hi @Anonymous ,

     

    You and me in the same boat. I also want to avoid those two extra columns i.e @odata.etag and ItemInternalId while converting my excel into csv file.

     

    Do you get any solution or any workaround to overcome this challange?

     

    Please reply.

     

    Thanks in advance.

  • Re: How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file

    Hi @CFernandes ,

     

    It's 40+ excel/tables...if it was 1 then I know manual mapping option. Blog doesn't help in answering my question and has same issue which i want to resolve. Have thought of a workaround for this requirement. Anyways thanks for your reply 🙂

  • CFernandes Profile Picture
    CFernandes 8,146 on at
    Re: How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file

    @Anonymous I understand you have 40+ column but it is a one time activity. You can also try @abm suggestion and Josh Cooks article looks promising.. 

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

  • Re: How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file

    It's dynamic schema so this might not work.

  • abm abm Profile Picture
    abm abm 32,296 on at
    Re: How to ignore/skip odata.etag and ItemInternalId columns while converting excel to .csv file

    Hi @Anonymous 

     

    You could try parsing the output to Parse JSON and iterate the values and construct the  CSV files using Append string variable. That might be a possibility.

     

    Thanks

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard