Taking corresponding actions according to what contains in a string array

(0) Share

Report

Posted on by Levinand

Let's say I have a MS form, Q1 has choices such as apple, orange, lemon, and allow multiple selection

Q2 has choices such as lettuce, tomato, potato, and allow multiple selection.

Different items cost differently, and I want to calculate the total amount that the responder needs to pay according to his selection.

I think I have successfully appended the answer from different questions to one single array variable, contains all the strings from the answer.

And I find that "Switch" action can only process string but not array, and I don't know how to perform the logic of
"if the array contains apple, add $2"; "if the array contains potato, add $4"; "if the array contains tomato, add $5"

Moreover, sorry that I have not yet searched for anything about automatically sending email in power automate. Is it easy if I want to sent back this amount to be paid & the items that he has chosen back to responder's email?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Levinand ,

Could you please show me a screenshot of your existing flow configuration?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Levinand 6 on at

Like (0)

Report
Copy link

Link copied!

Forget the excel thing in the middle, that is not mentioned

I try to use filter array in the second parallel operation in order to perform corresponding actions according to array, and fails.
And the flow for sending email is not yet started

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Levinand ,

To be honest, I don’t know what you are doing based on the flow screenshot you provided, but based on your demand description, I built a test myself for your reference.

My MS Form:

My Flow Overall Preview:

My Flow parameters configuration:

The function of the above four 'initialize variables' and 'append to array variable' controls is to add the options selected in the two multiple-choice questions to an array variable.
It is convenient for looping in 'apply to each' later.

json()

Explain the meaning of this code. If the option you choose contains apple+2, if the option you choose contains orange+3, if the option you choose contains lemon+4, and so on, finally break out of the loop and get the total price.

if(contains(items('Apply_to_each_3'),'apple'),2, if(contains(items('Apply_to_each_3'),'orange'),3, if(contains(items('Apply_to_each_3'),'lemon'),4, if(contains(items('Apply_to_each_3'),'lettuce'),5, if(contains(items('Apply_to_each_3'),'tomato'),4,5)))))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Levinand 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your advice. Actually my flow is similar, and my only concern is that the total number of items may up to 10 - 20, and the 'if' part can by very long.

Was this reply helpful? Yes No