How to sent email to group chosen from Form?

[slavenqx]

Hi

I have made a Form from Excel where you can first chose which department you want to ask something, and second part where you can write your question.

Now I am trying to create a Flow where email would be set to chosen department from the Flow.

On the sceenshot bellow from the value in Condition I can only choose the questions from the form but not acctual option.
I found somewhere that here you have to pick "choice" but it is not given to me to choose.

Let me know if some more data is needed 

Thank you

Regards

[ScottShearer]

@slavenqx :

All of the questions from Forms should be available to you in Dynamic properties, including choice (option) questions.  You may need to click on "see more" by the group heading in Dynamic properties in order to have all questions available to you.

[slavenqx]

@ScottShearer  thank you for the feedback.

so this is Form

and here is Flow (There is no see more)

[ScottShearer]

@slavenqx 

All you need to do is to reference the column that starts with "Molimo" in the condition. That will give you the option/value that was selected for that question.  You may have read that for a SharePoint option column that you need to select the "Value" from Dynamic properties.  With Forms it is not that complicated - just reference the option question.

I am assuming that multiple options cannot be selected.

[slavenqx]

Yes I already tried that, but funny even chosing "Molim" I am left with the same options and no choises displayed

[ScottShearer · Accepted solution]

@slavenqx :

You need to manually enter the choice yourself.

[slavenqx]

Hi Scott

Yes this does it, thank you very much for the solution.

BR

[slavenqx]

Hello @ScottShearer 

Need some more help on this 🙂

The emails just stopped working, don't understand why, everything is the same, and Flow shows everything godd, the excell sheet gets updated but no emails received.

How can I troubleshoot this please?

[ScottShearer]

@slavenqx 

Step 1 to troubleshoot is to look at one of the runs where email has not been set. 

Take a look at the email action.  Is the email address as you expect?  Also, take a look at the data available to you in the run for the other actions - is it as you expect it to be?

[slavenqx]

Can I get more details then this? Its just says that condition not satisfied, but its the correct form and email is good so not sure what is the problem 😞

Tnx

[ScottShearer]

@slavenqx :

Take a look at the data returned for the Get response details action - is it as you expected?

What is your condition?

If you are referencing a choice column in the condition, are you referencing the "value" for the choice column?

What are the values supplied by the get response details action that are used in your condition?

[slavenqx]

[
{
"webhookId": "d1ade2e6-4a03-4fbf-9aaa-7689c4da5079",
"eventType": "ResponseAdded",
"resourceData": {
"formId": "4Nt6o0URL0GZTDUd9ffU7MgacKcKPH5NnFkq016gme9UM09NSjIyRFhCR1JLRFIwSVlVUkFHVDVLUS4u",
"responseId": 16
},
"eventTime": "2019-05-08T15:21:49.4691596Z"
}
]

This is the response

[ScottShearer]

@slavenqx :

You need to look at the response details action and not the trigger.

[slavenqx]

Here is all:

When a new response is submitted

[
{
"webhookId": "d1ade2e6-4a03-4fbf-9aaa-7689c4da5079",
"eventType": "ResponseAdded",
"resourceData": {
"formId": "4Nt6o0URL0GZTDUd9ffU7MgacKcKPH5NnFkq016gme9UM09NSjIyRFhCR1JLRFIwSVlVUkFHVDVLUS4u",
"responseId": 19
},
"eventTime": "2019-05-27T12:10:57.6484922Z"
}
]

Get response details

{
"responder": "anonymous",
"submitDate": "5/27/2019 12:10:56 PM",
"r9f6aae2c6c9c4e9994b928bfd270d891": "novi flow",
"rcb257eb3e63042f4a0cf0a4424faa1c3": "[\"IT\"]"
}

Condition

ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email_2' skipped: the branching condition for this action is not satisfied.