0

I am trying to write a CSV file from a flow, I have an array of JSON objects.

enter image description here

Output is 

enter image description here

I want something like this, I want to all fields in double quote.

enter image description here

I have more than 50 columns in total, some have numbe4rs, text, multiple text and dates, I am showing only 2 columns in this example.

1 Answer 1

0

You can use a [Select] action to concatenate double quote (") to the input values coming from your list.

enter image description here

Detail 1

enter image description here

Expressions used in [Select] action

outputs('Get_items')?['body/value']

concat('"', item()?['LastName'], '"')

concat('"', item()?['FirstName'], '"')

concat('"', item()?['Email'], '"')

Final Output in the attached CSV sent to email enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.