Parallel branches for multiple choice questions?

[jpope]

Hi all,

Total newbie here. I'm actually a graphic designer who had an idea, opened my big mouth in a meeting, and now has to make the idea happen. This is an entirely new world, and I'd appreciate your guidance. My problem centers around a multiple choice question on a form and parallel branching not performing as expected. Here's what I've done:

I've created a universal referral form which will use a flow to populate into a master Excel table. From there the info will copy into various dedicated Excel sheets; ultimately notification emails will be sent to the instructors of each topic. Here's how I've laid out the question in forms:

Each option that people select should be captured in its own Excel column with an 'X'.  I've set up a parallel branch for each option, and they look like this: 

Here's the problem. Testing shows that if one option is selected, it transfers to it's respective Excel column just fine. However, if more than one is checked, then only the 'Resume' column is checked. Here's the Excel table showing what I mean:

Any thoughts or ideas? I'm open to approaching this in a different way, but I crashed and burned with some of the other options I watched on YouTube.

I so appreciate any help you can give!

[v-yujincui-msft · Accepted solution]

Hi @jpope ,

Maybe you could try without parallel branches. You could use expressions instead of Dynamic content in Update a row Action.

I have made a test for your reference.

1. Here are my MS Form and excel table.

2. Here is my Flow.

if(contains(Dynamic Content,'Resumes'),'X','')

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#c...

Result Screenshot:

Best Regards,

Charlie Choi

[jpope]

Hi Charlie,

Thanks for your reply. My apologies for not responding right away--it came in while I was out of the office.  I'm back, and will be working with your suggestions this morning. For some reason, expressions have been difficult for me to parse (both currently and historically,) but I'm more than willing to give it another shot.

I shall report back!

-JoAnne

[v-yujincui-msft]

Hi @jpope ,

Is your problem solved?

Best Regards,
Charlie Choi

[jpope]

Hi @v-yujincui-msft .

I just now finished. The info you have me was great, but my knowledge wasn't quite high enough to understand and use it properly. I've worked hard on that this week (logical expressions have always been very difficult for me) and I'm very happy to say that FINALLY I understand it enough to execute your suggestions. They worked well, and the main part of the flow is finished. 

Charlie, I really appreciate your assistance and patience! 

-JoAnne