Answered

Parentheses and quotes being added to "add a row"

(0) Share

Report

Posted on by SL-23071500-0

I've created a flow for MS Form to "Add a Row" in an excel spreadsheet (exactly the same as I created for last year.) It works, but on one of the columns, parentheses and quotes are being ADDED to the text. Why?

The data is then filtered out to other sheets for analysis based on the text in each column. When parentheses and quotes are added, then my analyses won't work.

How to fix?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @slarson77

does the data from form added to excel have such parentheisis, quotes etc ? have you checked the form dynamic content value added to flow ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
SL-23071500-0 41 on at

Like (0)

Report
Copy link

Link copied!

I am using the easily clicked Dynamic content. I believe I've discovered the issue. That particular question has a "multiple answers" allowed. I think this is what's doing it. I don't know how to tell Power Automate to simply put a comma between the words IF and only if there's multiple answers. I assume I have to use expression, and script it out, but I'm not a programmer, so I'm stuck.

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @slarson77

for that try this expression :

replace(replace(replace(outputs('Get_response_details')?['body/re864f35465eb4950a00837e65dbb9104'],'[',''),']',''),'"','')

Replace that highlighted dynamic content with yours.

Note: for multi choice questions like below, response via power automate looks like below:

When using above expression, it looks like this:

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
SL-23071500-0 41 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for trying to help me. But, I'm not sure where the compose comes in. I've looked at several you tube videos, and I am not able to get it right.
Any chance you could give me all the screen shots from after the Get response details? Putting that Expression directly into my Add a Row Into a Table didn't work.

Was this reply helpful? Yes No
SL-23071500-0 41 on at

Like (0)

Report
Copy link

Link copied!

Between your info, and this video, I got it to work.

https://youtu.be/l82nVlGwrio?si=0ehyyvEdVFDitk2Z

I really like the join/ json way. Much easier.
Thank you so much for pointing me in the right direction to find a solution!! 🙂

Was this reply helpful? Yes No