Answered

How to replace column names in header row in csv file in cloud flow

(0) Share

Report

Posted on by AP-03101741-0

Hi,

I have a cloud flow that is using a .csv file and have the first row as the header and need to replace the text to rename the columns.

Example, is I have a column called "Issue_Key" and I need it to say "Key" (I have other columns as well I need replaced)

Also, I only want it in the header row and not in the stream of data, so if a record contains "Issue_Key", leave that as is.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

cmht 82 on at

Like (0)

Report
Copy link

Link copied!

Hi @PowerTony
You need to generate and record script in Automate in Excel Online.
When this is done, you may use action named "Run Script". (Excel connector).

Was this reply helpful? Yes No
AP-03101741-0 on at

Like (0)

Report
Copy link

Link copied!

I'm new to PowerAutomate, how do I go about doing that ?

Was this reply helpful? Yes No
cmht 82 on at

Like (0)

Report
Copy link

Link copied!

Hi @PowerTony
I'm also new to PowerAutomate.
You need to open your file using Excel Online.
When opened: choose tab named automation:

Now select record actions:

Now Excel will "generate script" -> so do the operations you want to have (change the column name);

In the right pane it will show you actions you did:

Now click on Stop:

Excel will show you the script name:

You can now exit Excel Online (it should autosave) and now you can run this script using:

Was this reply helpful? Yes No
AP-03101741-0 on at

Like (0)

Report
Copy link

Link copied!

Here is the issue with that, I am generating the file out of PowerBI and within the cloud flow I am using..here is my flow:

Was this reply helpful? Yes No
Verified answer

cmht 82 on at

Like (0)

Report
Copy link

Link copied!

Hi @PowerTony
You can still open the CSV file and record actions.
Your scripts are stored not in the file, but globally.
Script, once created, can be run on any Excel file.
You may also need to convert CSV to Excel.

Was this reply helpful? Yes No
AP-03101741-0 on at

Like (0)

Report
Copy link

Link copied!

Can i use this technique to reorder the columns as well ?

My file at the end (.csv) is delimited, can I open this in Excel use the delimiter and reorder the columns and save as .csv again and record this action ?

Was this reply helpful? Yes No
cmht 82 on at

Like (0)

Report
Copy link

Link copied!

@PowerTony
Yes, you can. Delimiter is in the ribbon "Data" -> Text to columns -> choose delimiter.

Was this reply helpful? Yes No
AP-03101741-0 on at

Like (0)

Report
Copy link

Link copied!

I don't have Excel online, just Excel desktop but I was able to get the "Record Macro" added as an option.

So, for my step above "Export to file", I would change this from csv to xlsx and the next step after that is to run the script ?

Was this reply helpful? Yes No