web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : igGyZ4EgmN1IYlfNcD+5Ib
Power Automate - General Discussion
Answered

How to create CSV file with 'semicolon' delimiter?

Like (0) ShareShare
ReportReport
Posted on 24 Sep 2020 16:08:16 by 34

I created a flow in which to create a CSV table based on the result of an SQL query. But, by default, the delimiter is a comma. I need to save this CSV to automate a routine, but the delimiter has to be a semicolon. How would I do that?

 

SamplePOwerAutomate.png

  • PietroAFarias Profile Picture
    34 on 25 Sep 2020 at 12:17:13
    Re: How to create CSV file with 'semicolon' delimiter?

    I redid the process using Replace () because I was doing it wrong. At the end of the flow was where I used Replace (), which is the action in which a file is created, that is, after you have already converted it from Array to String.

  • Jcook Profile Picture
    7,779 Most Valuable Professional on 25 Sep 2020 at 02:02:22
    Re: How to create CSV file with 'semicolon' delimiter?

    Hello @PietroAFarias 

     

    Can you try the solutions from this post

     

    https://powerusers.microsoft.com/t5/Building-Flows/Change-the-delimiter-when-creating-a-CSV-file/td-p/131894

  • PietroAFarias Profile Picture
    34 on 24 Sep 2020 at 17:55:26
    Re: How to create CSV file with 'semicolon' delimiter?

    I tried to do this, but it converts the array to String. Thus, I was unable to convert to an array using Array (). When I do this, everything is on the same line.

    Sample output: https://i.ibb.co/qnxcxdT/Sample-POwer-Automate.png

  • Verified answer
    yashag2255 Profile Picture
    24,669 Super User 2024 Season 1 on 24 Sep 2020 at 17:39:17
    Re: How to create CSV file with 'semicolon' delimiter?

    Hi @PietroAFarias 

     

    Can you check the outputs in the TabelaCSV action? 

     

    You can add a compose action after this once and use the replace() function to replace all the commas with semi colons. 

     

    Hope this Helps!

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete