Unanswered

MS Forms Multi-choice values are not showing properly in SharePoint.

(0) Share

Report

Posted on by jay_mangukia

156

Hello All,

I am facing an issue.

I have created a form in MS Forms. Users have to select one or more options in the form

Screenshot 2024-02-06 170546.png

Then the response will be stored in the SharePoint List.

Screenshot 2024-02-06 170932.png

But, the values or the multi-choice values are not being shown here properly. It is looking something like this.

Screenshot 2024-02-06 170552.png

However, the Options column is a "Choice Column".

Screenshot 2024-02-06 170604.png

Also, when these values are stored in SharePoint, I have to send them through email using Power Automate like in the "Send an Email v2" trigger.

Can anyone show me show to solve this? Please Help. Thank you in advance!

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (2)

Verified answer

CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

Hey @jay_mangukia

Please review the video tutorial at https://www.youtube.com/watch?v=1NMdjM-YNlg

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
sgtsnacks64 322 Super User 2024 Season 1 on at

Like (1)

Report

Hi @jay_mangukia ,

You might need to add a Select action before Creating the SharePoint item,

Your choices in the form are being returned as a String array, but SharePoint I believe is expecting a object array with a column "Value",

The value in the red box on Select should represent your Question1 value from the form response.

Was this reply helpful? Yes No
jay_mangukia 156 on at

Like (0)

Report

Hello dear,

Thank you for your response. I have tried the way it is shown in the video. the details are showing properly in SharePoint, But I also want to send that values in email using send email trigger. How can I do that?

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@jay_mangukia - I assume you want to include the details in the email body?

Was this reply helpful? Yes No
jay_mangukia 156 on at

Like (0)

Report

That's right.

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@jay_mangukia You can directly include the responses in the Email body...

You can look at the end of the video around 10 minutes- https://www.youtube.com/watch?v=qnio2qEZKto

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
jay_mangukia 156 on at

Like (0)

Report

Yes. I can get the normal details in my mail body like text and stuff. But I am not able to get the multichoice response in my mail body.

For example this is my form which has a multi choice question where user can select one more options.

When the user submits the form then it will stored in my SharePoint list (Thank you for the video suggestion). Like this,

But when I try to attach the dynamic content of "Sports" to my email body like,

The mail which I receive during the test shows something like this,

This is what I want to avoid. It is showing with brackets and commas, I just want to show them as plain text.

How can I do that????

Was this reply helpful? Yes No
Verified answer

sgtsnacks64 322 Super User 2024 Season 1 on at

Like (0)

Report
Hi @jay_mangukia

Depending on how you want to display them will determine the answer.

However, to remove the array square brackets, you could use the join() function to achieve this:

As a formula, enter:
join(outputs('Get_form_responses')?['body/[questionguid]'],', ')

You'll need to add the Sports questions as a dynamic value in the formula,

This will combine the string elements of the array being passed back by the Sports question, and separate them by a comma and space.

If you're formatting your email as HTML, you could add a <br> to perform a line break per item in the response.

Was this reply helpful? Yes No
jay_mangukia 156 on at

Like (0)

Report

Got it, Where do I have to write this formula? In New Compose action like this?

Was this reply helpful? Yes No
sgtsnacks64 322 Super User 2024 Season 1 on at

Like (0)

Report

You can either add it to compose to observe the output for directly into the mail body.

Was this reply helpful? Yes No