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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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......",

........

}

]

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey Mate,

You can use a Select Data Operation and map just the columns you want into a new data collection

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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,
I don't want to do mapping as it's 40+ excel for which conversion to .csv is required and all tables/columns are different in each excel...I want a dynamic solution which I'm afraid is possible or not...

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

This blog might be helpful posted by Josh Cook.

https://flowaltdelete.ca/2020/06/25/power-automate-excel-dynamic-file/

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @abm ,
I checked the blog, but it's for dynamic file name...which I don't want. The output of the object "list rows present in a table" for excel is creating these 2 extra columns which can be seen in the images posted in that blog...odata.etag & ItemInternalId...if there's a way to skip those extra columns then my work will be done, otherwise have to find some other workaround!

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It's dynamic schema so this might not work.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 🙂

Was this reply helpful? Yes No
Dnyaneshwar 7 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DaveDodge 24 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No