Remove text from CSV Header

(0) Share

Report

Posted on by MiltonK

Hi all,

I have a flow that export Power BI data to a CSV file.

How can I remove the text input[ and ] from the header automatically in the flow please?

Please note: new Date columns are generated every week so can not be hard-coded

Thanks for your help

Categories:

General topics

All responses (7)

Answers (1)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @MiltonK

Not sure this will help or not.
But in the action where you are creating csv table, instead of automatic do custom in the columns.

Then you will be able to give headers you want.
MiltonK 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@Sundeep_Malik Thanks but I was looking at the option and not sure what to fill? Esp the date columns are generated every week so can not be hard-coded ::
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

@MiltonK

Give a column there and in the values write something as
item()['columnname']
Or some kind of dynamic value that you are getting from above power bi action.
But from the screenshot I am not able to see any of the values so might not be possible.
Verified answer

MiltonK 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help.

Managed to do it with Replace text variable:
takolota1 4,980 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone with similar issues could also try this template to process CSVs to Excel tables. It includes an option in the Data & Set-up action to remove header & footer lines in the CSV like this.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-To-New-Excel-Table/td-p/1826096
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

What did you put in your initialize variable step?
MiltonK 22 on at

Like
a
(0)

Report
Copy link

Link copied!

replace(variables('VarCSV'),'OutputExport[','')