Skip to main content

Notifications

Power Automate - Using Flows
Answered

Parentheses and quotes being added to "add a row"

(0) ShareShare
ReportReport
Posted on by 41

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?  

  • SL-23071500-0 Profile Picture
    SL-23071500-0 41 on at
    Re: Parentheses and quotes being added to "add a row"

    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!! 🙂

  • SL-23071500-0 Profile Picture
    SL-23071500-0 41 on at
    Re: Parentheses and quotes being added to "add a row"

    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.

    slarson77_0-1704396642993.png

     

     

  • Verified answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 17,074 on at
    Re: Parentheses and quotes being added to "add a row"

    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:
    Nived_Nambiar_0-1704394410246.png

     

    Nived_Nambiar_1-1704394484879.png

     

    When using above expression, it looks like this:

    Nived_Nambiar_2-1704394503713.png

     

     

    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! 🙌

  • SL-23071500-0 Profile Picture
    SL-23071500-0 41 on at
    Re: Parentheses and quotes being added to "add a row"

    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.

     

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,074 on at
    Re: Parentheses and quotes being added to "add a row"

    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! 🙌

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics

Restore a deleted flow