Power Automate connects multiple-choice selections in Microsoft Forms to Microsoft SharePoint

[YoelM]

"I am getting the following error when I try to incorporate the 'Apply to each' loop in Power Automate. I don't understand why, as I have seen other models where it works. My goal is to replicate a multi-choice question from Forms to SharePoint."

Error:

The execution of template action 'Auf_alle_anwenden' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body/resourceData/responseId']' is of type 'Integer'. The result must be a valid array.

 Best regards. Y.

[creativeopinion]

You are trying to loop through the Response ID which is a single number (integer). In order to use an Apply to Each action, the output in the action has to be an array of items.

[YoelM]

Hi @creativeopinion,  thanks for your answer.

My problem is I don't really have other options or don't know exactly how to solve what you described. Can you help me further? I would be very grateful.

[creativeopinion]

I'm unclear on what you are trying to do. What do you mean by replicate a multi-choice column from Forms to SharePoint? Are you talking about updating a SharePoint item with the selection of a multi-choice column from a Form?

[YoelM]

@creativeopinion Ok, my goal is to reflect the Forms survey responses in Sharepoint. I have already done that. There is only one problem and that is that a question in Forms is one with the possibility to select multiple answers. See screenshot how it looks like so far.

Basically it works, only the multiple selection "Affected areas" are not displayed individually. If the user selects multiple answers in Forms for the question "Affected areas" then it should look like this (see screenshot2)

That's why I tried to build it up differently via apply to each. My problem is as you describe correctly that "Response ID" is integer. From this moment on I can't think of a solution.
Does it describe my problem better and do you understand what I am trying to achieve?

[creativeopinion · Accepted solution]

You need to use the Get response details action. To get the information from the form.

Add a Compose Action to convert the multi-choice response values to json with an expression. Add an expression:

Then put your cursor inside the brackets, select the Dynamic content tab and insert the appropriate dynamic content from your form.

Add a Select action. Insert the outputs from the Compose action above into the From field. The Key should be Value and insert an expression into the Value field.

In your SharePoint action (whether it's to Update or Create an item) insert the outputs from the Select action. 

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!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok