Flow Failing when Multiple Choice Response Left Empty

[fredlines1]

Hello,

I am creating a flow, and I have two multiple choice questions that when one or the other is left blank, the entire flow fails with the error:  

Unable to process template language expressions in action 'Join' inputs at line '0' and column '0': 'Required property 'from' expects a value but got null. Path ''.'.

I have two Join and Compose boxes in my flow to format the data received in these two questions. The Join boxes format line breaks between the responses in the email that is sent (1st screenshot below) and the Compose boxes format to remove the quotations from the responses in the email that is sent (2nd screenshot below). 

My entire flow is as follows:

When I run this flow with both multiple choice questions answered, it works fine. If one is left blank, the entire flow fails. 

I've tried I adding a Condition box to attempt to have the flow not break when the two multiple choice responses are left empty (screenshot below), but now that I added it, the emails do not populate anything when responses are submitted. 

Does anyone know how to have this flow work if one of these questions are not answered to still populate in the email that is sent?

Thank you so much!

[abm]

Hi @fredlines1 

Is your join action step failing? You may need to extend the IF condition to check if both are NOT empty then do the same current logic for the join and compose. In the Else part of the IF condition you need to check which one is entered then change the logic accordingly and extend the same logic for the Else for the other entry as well.  This way you have covered for all.

Your current IF condition is not quite right. Could you post a screen shot of the mappings of the join and compose?

Thanks

[fredlines1]

Hi @abm 

Thank you so much for replying and your help with this. I am new to power automate so I am still learning. 

I've included below screenshots of my Join and Compose

Right now my flow is set up as follows:

I added in the condition to check for if the output of my two questions are empty = true and if yes, my thought was it would just go straight to the email part of the flow, and if no, it would go through the nested 'no' flow to format the responses before going to the email. 

Because I'm so new to power automate, any screenshots you have on your end, or providing the logic you're referring to is super helpful. Again - thank you so much for your response and please let me know if there is any other information I can provide!

[abm · Accepted solution]

Hi @fredlines1 

Following are the steps:

1. Declare one variable where you can append both results.

2. Check the first response is not empty then do the join with delimiter as <br>

3. Append the step 2 result

4. Check the second response is not empty then do the join with delimiter as <br>

5. Finally map the appended result in your email body

Note: An additional check is needed for breaking two lines if both are entered.

Thanks

[fredlines1]

@abm 

Thank you so much for your help in figuring this out! This is exactly what I needed, so thank you for providing suck a quick response and solution!

[dedgerton1]

I'm struggling with the same issue, but I need a visual example of the solution. What did it end up looking like? 

[dedgerton1]

For context, here's what I'm working with. When any of these 6 fields are left blank, it fails. I've since added an "n/a" option and made the question required, but I still need to move the two failed submissions along. What can I do to make that work here? Currently, each is set to join the results with a simple comma and space. 

[abm]

Hi @dedgerton1 #

Could you please create a new thread and explain bit more about your issue and requirements? Tag me as @abm 

Thanks