Unanswered

How can I make semicolon the delimiter in CSV file

(0) Share

Report

Posted on by Community Power Pla...

I'm trying to convert data to CSV and attach in email. The compose actions is attempting to convert the CSV to string and then replacing "," to ";" but it didnt seem to work well. So instead tried to write ";" in the Select action itself but the "," remains as a column. How can I fix this or go around it?

Categories:

General topics

MicrosoftTeams-im...

I have the same question (0)

All responses (7)

Answers (2)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Sorry, can you elaborate the issue with examples and screenshots?

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

Like (0)

Report

My work's default excel delimiter is a semicolon. Initially I'm Parse JSON the input content that comes from PowerApps, then im selecting the certain column that I want and creating a CSV table with it so that I can attach in the email content I'll be sending. However, because the delimiter in create CSV table action is a comma, all the output data in the excel is in just one single column. I want to basically replace the commas with a semicolon.

I attempted the replace function but it wanted the input to be a string, so I attempted to first convert the output data (from create CSV table action) into a string and then the replace function. But this didn't work properly, so instead in the Select action I put a semicolon in the beginning and end of every key and value. In this way the columns are being seperated in the excel but there are also commas inbetween every column. I'm trying to find a way to fix this or a way to go around it, please

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
The excel screenshot you have is your source file? Since CSV is just a text file, Replace function should just work.

replace("Something,another thing",',',';')

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

Like (0)

Report

No, the excel is the attached file in the email I receive with this flow. The datasource comes from SharePoint

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

See my updated question

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

In this case I'm doing: replace(outputs('Create_CSV_table'),',',';') and getting this error:

So i try to do the the action:

- string(outputs('Create_CSV_table')) first and then
- replace(outputs('Compose_3'),',',';')

but doing that, the output becomes:

and the excel file's values dont appear (with the "{body:"" in the beginning as well):

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Can you put outputs('Create_CSV_table') in a compose and see what it returns?

It must be returning an object (not string)

Was this reply helpful? Yes No