cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhanney2323
Helper III
Helper III

Why is create CSV table adding double quotes?

Hi so I have a flow that triggers when a new item is added to a sharepoint list and basically the purpose of the flow is to create text file out of this list and send it to our file server. 

 

Before I explain my issue, some preface: In the description of the item there are quotes used for the general description, as well as quotes used as inch marks (see the sharepoint screenshot below for the original and correct description)

bhanney2323_0-1638479782579.png

The issue is in the flow I have a create CSV table action and it seems to be adding extra quotes where the inches markers are and this is causing us issues in the import item process into our erp system. 

 

Here is a screenshot of the action and the raw inputs and outputs, anything highlighted in red should not be there. 

 

Raw Inputs: 

bhanney2323_1-1638479978776.png

Raw Outputs:

bhanney2323_2-1638480157741.png

 

Here is a full version of the output:

GK-SH-BR8-V2XN-V2XN-8PGR,"Quantum Unbranded Gasket Sheet Material! 20.000"" Length x 20.000"" Width x 1/32""Nom. Thk",

 

Any guidance on this would be greatly appreciated, thank you. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @bhanney2323 ,

 

I think this is expected behavior.

I created a .csv file and I enter a value in it .

vxiaochenmsft_0-1638841399910.png

vxiaochenmsft_1-1638841411761.png

 

I changed the file content to .txt and open it.

vxiaochenmsft_2-1638841526553.png

vxiaochenmsft_3-1638841548557.png

 

Best Regards,

Wearsky

 

 

 

 

View solution in original post

5 REPLIES 5
v-xiaochen-msft
Community Support
Community Support

Hi @bhanney2323 ,

 

I think this is the escape character.

This does not affect the outputs. Please see the images.

vxiaochenmsft_0-1638773532010.png

vxiaochenmsft_1-1638773553345.png

vxiaochenmsft_2-1638773589753.png

vxiaochenmsft_3-1638773612502.png

 

Best Regards,

Wearsky

bhanney2323
Helper III
Helper III

This does affect output on my end, we output to a text file because that is what our erp system takes and I can assure you it does affect this final output. 

bhanney2323
Helper III
Helper III

We first create a copy of the file in a sharepoint library and save it as a text file, then we grab the file from the SP library and create it in our file system. 

 

bhanney2323_0-1638808944440.pngbhanney2323_1-1638808967651.png

 

v-xiaochen-msft
Community Support
Community Support

Hi @bhanney2323 ,

 

It looks like that .txt file coused this problem . 

I suggest you create .csv file instead of .txt file.

 

Best Regards,

Wearsky

 

v-xiaochen-msft
Community Support
Community Support

Hi @bhanney2323 ,

 

I think this is expected behavior.

I created a .csv file and I enter a value in it .

vxiaochenmsft_0-1638841399910.png

vxiaochenmsft_1-1638841411761.png

 

I changed the file content to .txt and open it.

vxiaochenmsft_2-1638841526553.png

vxiaochenmsft_3-1638841548557.png

 

Best Regards,

Wearsky

 

 

 

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,419)