Answered

Loop on form multiple answers

(1) Share

Report

Posted on by divyagolla

I have a form which accepts multiple answers for a question.I have to send email to different persons based on the response received.

For example if user selects only finanace i have send email to xyz@abc.com

if user selects both finance and hr then i have to send emails to xyz@abc.com and def@abc.com respectively.

we can send individual emails for xyz and abc.

First i am collecting response using get repose details. When an user selects multiple answers, response is comes as string. So i have used compose to fetch the required output and used Initialise variable with create array and passed compose output to create array.

Then i have used Apply to each with array output and switch inside to send emails to difference peoples based on response received.

When i select both responses, current value is coming as ["Finance","HR"] and it is going to default value in the switch

Here i want to iterate loop for finance and hr so that emails can be sent individually.

Can some one please help me what is the issue here ?

Screenshot from 2020-04-10 17-10-14.png

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

Hi!

Which expression did you use inside your Compose? Also, which expression did you assigned to your 'Initialize variable' value?

Without such info, just guessing, it seems your compose is already creating an array... if so my suggestion is to assign compose Compose output to 'Apply to each' input and see if this way everything works as expected.

If not... please answer above questions, and if possible, share a screenshot from your 'Get response details' outputs so we can inspect its values

Hope this helps

Was this reply helpful? Yes No
divyagolla 10 on at

Like (1)

Report
Copy link

Link copied!

Thank you for checking the issue.
please find the answers to your questions

expression used in compose :
createArray(body('Get_response_details')?['r0eeaede2dc99449f8a489631de6bf539'])
expression assigned initialize variable : outputs(Compose)

I tried to assign compose output to Apply each but still the default case is getting executed.

Above are the output details of the flow

Was this reply helpful? Yes No
divyagolla 10 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
divyagolla 10 on at

Like (0)

Report
Copy link

Link copied!

Also i tried with this approach

i have passed just Access Requests as input and i got output of compose as ["Finance","Operations"]
This is displaying as String.
When i passed output of compose to Apply to each i got below error

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose')' is of type 'String'. The result must be a valid array

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

Hi!

Found a thread whose scope is similar to yours. It is from 2019, not sure if a more elegant method is currenty available

https://powerusers.microsoft.com/t5/Building-Flows/Multiple-Choice-data-from-Microsoft-Forms/td-p/415682

Hope this helps

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @divyagolla ,

If one option corresponding to an email address, you could try to refer to the following method.

Initialize an array variable to record options and email.

Please take a try and feel free to let us know if you have any questions.

Best Regards,

Was this reply helpful? Yes No