Answered

Brackets and Quotations around Output

(1) Share

Report

Posted on by Shaebert

107

I have a flow where I am taking lines of data and then splitting them using the index selector to extract the data I want to capture. I am successful in doing this, however, when I send the data to a spreadsheet it has brackets and quotations around the values. For example, ["FirstName"] and ["LastName"] when I just want FirstName and LastName to be outputted.

I am new to power automate, so I am guessing I have the output formatted incorrectly? I imagine I could do a replace function, but feel like that seems more like a workaround vs the correct operation.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Shaebert
Can you give an example how your original data looks like. Then I might be able to give you some suggestions. Like just make a test data and post it.

Was this reply helpful? Yes No
Shaebert 107 on at

Like (0)

Report

Original data was from an email with comma-separated values.

FirstName,LastName,Company

Then changed to an Array so I could split:

[
"FirstName,LastName,Company"
]

Then I split via comma:

[
"FirstName",
"LastName",
"Company"
]

Then used this expression split(outputs('Compose')[0],',') to get the ["FirstName']

Was this reply helpful? Yes No
Verified answer

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Shaebert
You could have directly used split on the csv, this will change it to an array only. Then you can extract the first name by 0 index.
Compose 2: split(outputs('Compose'),',')
Compose 3: outputs('Compose_2')[0]
Compose 3: to get the first name, you can use 1 and 2 to get other values too.
First creating array and then using split is doing ["FirstName"], you are creating the array twice.

I hope this helps.

Was this reply helpful? Yes No