Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 23wFUuUEn+5sr5W9v9TT9Y
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 13 Oct 2020 06:56:09 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
    4 on 09 Dec 2024 at 12:49:18
    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
    6 on 30 Oct 2024 at 14:11:58
    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
    50 on 19 Apr 2022 at 20:24:34
    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

  • Community Power Platform Member Profile Picture
    on 22 Feb 2022 at 09:51:38
    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
    24 on 12 Nov 2021 at 13:45:49
    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
    7 on 17 Mar 2021 at 14:06:39
    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.

  • Community Power Platform Member Profile Picture
    on 14 Oct 2020 at 05:26:21
    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
    8,179 Most Valuable Professional on 14 Oct 2020 at 05:14:25
    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!

     

  • Community Power Platform Member Profile Picture
    on 14 Oct 2020 at 00:49:46
    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
    32,399 Most Valuable Professional on 13 Oct 2020 at 23:52:34
    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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

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

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,369 Most Valuable Professional

Leaderboard
Loading started