Grab spreadsheet from email, customize it, then send to network share

[tcollins]

So I already have a flow that is grabbing files from emails and sending to network shares (flow gateway working fine). 

My struggle is, I have a request to:

1. Grab spreadsheet from email, has a bunch of columns I don't need and headers that I need to update

2. Remove columns, update headers

3. Send new file as a csv to network share

4. Another automation I have running takes it from there

[ChristianAbata · Accepted solution]

hi @tcollins  what you can do, is create a new temporary file in one drive or sharepoint with atable and headers that you want, then you can follow this examaple.

then you can send this file as attachment but as xlsx not cvs

Unfortunally you can't delete columns in PA

[tcollins]

Thank you. I believe this would work except the end file has to be .csv