Answered

Why is create CSV table adding double quotes?

(0) Share

Report

Posted on by bhanney2323

237

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)

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:

Raw Outputs:

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.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bhanney2323 ,

I think this is the escape character.

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

Best Regards,

Wearsky

Was this reply helpful? Yes No
bhanney2323 237 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
bhanney2323 237 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bhanney2323 ,

It looks like that .txt file coused this problem .

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

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bhanney2323 ,

I think this is expected behavior.

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

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

Best Regards,

Wearsky

Was this reply helpful? Yes No