Cleaning up the formatting of data pulled from a choice variable and posted to a teams channel

Like (0) Share

Report

Posted on 29 May 2024 18:29:03 by Hensman

I'm new to using Power Automate, but I have managed to create a flow that does what I need it to. It takes the response from an MS Form, updates an MS List in MS Teams and posts a message on the MS Teams channel saying that the list has an update. This works.

My problem is cleaning up the data format from a choice list recorded in the MS Form. When the message is posted it reads as

["Option 1","Option 3"]

I would like it to read as

Option 1, Option 3

How do I get rid of the square brackets and quotation marks?

Any help would be appreciated.

All responses (1)

Answers (0)

creativeopinion 10,468 Super User 2025 Season 2 on 29 May 2024 at 23:10:17

Like (0)

Report

Re: Cleaning up the formatting of data pulled from a choice variable and posted to a teams channel

@Hensman You need to parse the data from the MS Form response. Take a look at this section of my YT Tutorial: How to Get a Microsoft Form RSVP Response into a SharePoint List.

I'll show you how to parse a multi-choice answer so you can add it to a multi-choice column in SharePoint as well as a how to output it as a string of text (which is what you are looking for).

I also cover the following in this video tutorial:

✅ How to get a Microsoft Form Response into SharePoint

✅ How to get a Microsoft Form ID

✅ How to get a Microsoft Form response

✅ How to Build a Microsoft Form with Conditional Fields

✅ How to used Branching in Microsoft Forms

✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

✅ How to parse a Microsoft Form multiple choice response as string of text

✅ How to convert a text response to a number

✅ How to use the Switch action

✅ How to create a custom email confirmation for a Microsoft Form submission

✅ How to Create a Custom View in a SharePoint list

✅ How to use the Compose Action

✅ How to write Power Automate Expressions

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram