cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JohnComm
Level: Powered On

Creating a CSV file from Sharepoint

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

1 ACCEPTED SOLUTION

Accepted Solutions
Ademar
Level: Powered On

Re: Creating a CSV file from Sharepoint

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

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Creating a CSV file from Sharepoint

Hi @JohnComm 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



JohnComm
Level: Powered On

Re: Creating a CSV file from Sharepoint

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.

 

 

Super User
Super User

Re: Creating a CSV file from Sharepoint

Hi @JohnComm 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



Ademar
Level: Powered On

Re: Creating a CSV file from Sharepoint

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

View solution in original post

JohnComm
Level: Powered On

Re: Creating a CSV file from Sharepoint

Thank You Ademar

 

That worked fine.

 

Thanks all for your help

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,237)