MS Forms response to SharePoint List items via Power Automate. Why - Microsoft Community

MS Forms response to SharePoint List items via Power Automate. Why can't I get the choice, multi-selection options to populate on the list correctly?

I have created a Sharepoint List named "Test List - Favorite Color". There is a column titled "Name" and this column is a Text column. I've created a second column named "Color" and this is a choice column that allows multiple choices to be selected. I've created a Form named "Test Form - Favorite Color" which has a question "Name" which is a text question and a "color" question which is a choice question that allows multiple choices to be selected. I created a Power Automate flow that creates a new item on the SharePoint List "Test List - Favorite Color" and have added the dynamic content to each of the two questions to the columns on the list. However, when the response is displayed in the "Color" column, the multiple choices are displayed all together in a choice pill. How do I get the responses to display in separate choice pills in the SharePoint list item? I have spent two whole workdays trying to figure this out.

|

Dear Amy,

You can create the flow as follows.

Forms

Flow:

Compose: json(dynamic color result)

Append to array variable:

{

"Value":"@{items('Apply_to_each')}"

}

Result:

Welcome to share any updates at your convenience.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Dear Amy,

May I know whether you need further help on this issue?

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 27, 2024 Views 20 Applies to: