cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anmdf Helper I
Helper I

Renaming worksheet, removing format, reading text file

Hello!

 

I have a few questions on the flow that I'm building... The process is to read a table in Excel, convert to CSV, and send in an email which will be taken care of by another automation.

 

My flow right now is that I have created an Excel template, and proceeded to "add a row into a table" for each row in the source file table. Then create a file in Sharepoint with a .csv extension and then attach it to an email. Opening the file and it still had the formatting of the table. 

 

So I was just wondering, is it possible to...

1. rename the worksheet in the csv file using Flow?

2. remove all formatting of data?

 

Also, is it possible to read a text file with tab delimiters and then "paste" it into an Excel table for conversion to csv? 

 

Thank you! Any suggestions would help.

5 REPLIES 5
Community Support
Community Support

Re: Renaming worksheet, removing format, reading text file

Hi @anmdf,

 

  1. I have tested on my side, there is no worksheet name in the CSV file, do you mean rename the worksheet in the Excel file?
  2. What' the original format of the data? On my side, there is String.
  3. There is no way to read a text file, so you may be hard to get data from it and put it into Excel Table.

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support
Community Support

Re: Renaming worksheet, removing format, reading text file

Hi @anmdf,

 

Correct my previous reply: There is no relative action to read a text file, but you can use the Get file content to get the content of the text file.

 

Could you share your Csv file instance? So that we can better understand your requirement that renames the worksheet name.

 

By the way, there are a blog and some post that how to deal with the CSV file, you can have a reference with it:

https://powerusers.microsoft.com/t5/Flow-Cookbook/read-csv-file-and-write-to-destination/m-p/258524

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anmdf Helper I
Helper I

Re: Renaming worksheet, removing format, reading text file

Hello @v-litu-msft,

 

Sorry for the late response. 

 

The process is that:

1. A tab-delimited .txt file is received via email (with about a hundred rows, no header)

2. There is a template Excel (.xlsx) file with two sheets (stored in SharePoint). The contents of the .txt file is copied to Sheet 1.

3. Sheet 2 gets the data required from the .txt file. The result is two rows (one header and one datarow)

4. Sheet 2 is then converted to a .csv file and sent via email.

 

I tried making it into a .csv file via Flow by doing the Create File (SharePoint) and just putting a .csv extension; but I guess that's not how I should do it? Smiley Mad

 

Thank you!

Community Support
Community Support

Re: Renaming worksheet, removing format, reading text file

Hi @anmdf,

 

Could you please share an example about the txt file? (Block the key information)

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anmdf Helper I
Helper I

Re: Renaming worksheet, removing format, reading text file

Here is the data:2019-09-20_10-40-05.png

 

These should be converted to csv, and will be filtered using the first column. Thank you!

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,216)