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
Solved! Go to 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
Hi @JohnComm
Did you tried using Power Automate action step Create CSV table?
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsThanks 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.
Hi @JohnComm
Is any specific reason why you want to enclose the quotes? Could you post your Power Automate screenshot please?
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @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
Thank You Ademar
That worked fine.
Thanks all for your help
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
41 | |
36 | |
36 | |
22 |
User | Count |
---|---|
40 | |
36 | |
28 | |
27 | |
27 |