Power Platform Community Forum Thread Details

Hi everyone!

So I have an MS Form & Flow combo set up for my work that: 1) asks which group you belong to, 2) populates multiple choice selections belonging to that group (specifically with an option for other/not on the list), 3) has you type in your 'Other/Not on the list' option if applicable via a branch question, and then 4) begins a Flow to populate the answers into a MS Word Template and fill out a form, which gets emailed to everyone.

Been using it for a while now and it's worked great! However, in adding the 'Other/not on the list' branch, I've run into a problem where the template plugs in the 'branch' answer, but ALSO the 'Other/Not on the List' selection (see output below).

Example Form below:

My attempt has been to first use Initialize Variable to plug in all the possible Form dynamic answers into one variable (TitleVariable = Group 1 event, Group 1 OtherEvent, Group 2 event, Group 2 OtherEvent, etc). That part works great!

However, since 'Other/Not on the list' IS a choice from the Form, it also plugs that into the template when they use the branch, like the output shown previously.

I'm trying to make an expression to remove 'Other/not on the list' from the string, but my formula is failing me! Here's what I have so far and I'm not sure what I need to replace:

if(equals(variables('Title'),'Other/Not On The List'),replace(''),variables('Title'))

However my output is still showing the branch question AND the 'Other/not on the list'. I feel like I'm missing something simple from my formula and would appreciate any help anyone might know :)

Thank you again and I hope everyone has a great day!

Categories:

Using flows