Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Removing Brackets and Quotes from Multiple Choice Answers from MSFORMS to Email.

Posted on by 2
I have a very basic understanding of Power Automate. I have searched this forum for the solution to my problem and hove found several. Unfortunately, I don't think I know enough about Power Automate to understand how to implement the solutions. 
 
So, I here goes. I have a flow that takes responses from a MS Form and sends them in an email. The single choice answers look fine, but the multiple-choice answers come back in brackets and quotes. 
 
Example:
 
4 Exceeds Expectations
["Consistently communicates with intentionality and purpose with the right people at the right time with the right content and context.","Consistently makes good use of electronic communication services, including email, groupware, and videoconferencing","Encourages others to communicate openly and effectively"]
 
How can I remove the brackets and quotes. My flow looks like this:
  • JD-30111543-0 Profile Picture
    JD-30111543-0 2 on at
    Removing Brackets and Quotes from Multiple Choice Answers from MSFORMS to Email.
    Thank you for the reply. When I try to use the Join action, there is no dynamic content available. Did you use an expression for Multiple Choice Question? 
     
  • Suggested answer
    EKarim Profile Picture
    EKarim 10,290 on at
    Removing Brackets and Quotes from Multiple Choice Answers from MSFORMS to Email.
     
     
    You could join all the answers together into a single text string, separating each answer using a COMMA and a SPACE character:
     
     
    Exampple runtime output:
     
     
     
    Ellis
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard