Creating a CSV file from Sharepoint

[JohnComm]

Hi All

 I am trying to create a CSV file from a SharePoint list and i would like to have the test fields in the format below, i have tried a few ways to create the file but seem to get double quotes around the fields.

""PULSAR"",""Nissan"",""N15"" ,01/02/2019 12:00:00,""Silver"",""InStock""

Would Like

"PULSAR","Nissan","N15" ,01/02/2019 12:00:00,"Silver","InStock"

Thanks

John

[abm]

Hi @JohnComm 

Did you tried using Power Automate action step Create CSV table?

[JohnComm]

Thanks abm

That's what i am using to create the file the create CSV Table, i wanted to enclose the text fields in quotes but it appears to add some itself.

[abm]

Hi @JohnComm 

Is any specific reason why you want to enclose the quotes? Could you post your Power Automate screenshot please?

[Ademar · Accepted solution]

Hi @JohnComm,

It seems that the Action card "Create CSV table" adds quotes to string values regardless if they are already there.  

You can verify your string and remove the quotes before passing to "Create CSV table" or you can add a Compose action card after the “Create CSV table” and add the expression:

          - replace(body('Create_CSV_table'),'""','"')

This should replace the double quote for one quote.

Please let me know if this is a solution to your scenario.

Best regards,

Ademar Urbano 

Power Platform Support Engineer

[JohnComm]

Thank You Ademar

That worked fine.

Thanks all for your help

[jose_raymundo]

> replace(body('Create_CSV_table'),'""','"') For some reason Power Automate escapes the two double quotes inside the two single quotes. So when checking Peek Code, the following is done: { "inputs": "@replace(body('Create_CSV_table'),'\"\"','\"')" } So I can't seem to add quotes to my values. Employee_Name should be "Employee_Name" in the csv but what happens is """Employee_Name"""