cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

How to sent email to group chosen from Form?

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 

 

 

 

email form.PNG

 

Thank you

Regards

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: How to sent email to group chosen from Form?

@slavenqx :

You need to manually enter the choice yourself.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

13 REPLIES 13
Highlighted
Super User III
Super User III

Re: How to sent email to group chosen from Form?

@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.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Regular Visitor

Re: How to sent email to group chosen from Form?

@ScottShearer  thank you for the feedback.

so this is Form

 

email form 2.PNG

and here is Flow (There is no see more)

 

email form 3.PNG

 

email form 4.PNG

Highlighted
Super User III
Super User III

Re: How to sent email to group chosen from Form?

@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.

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Regular Visitor

Re: How to sent email to group chosen from Form?

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

 

email form 5.PNG

 

email form 6.PNG

Highlighted
Super User III
Super User III

Re: How to sent email to group chosen from Form?

@slavenqx :

You need to manually enter the choice yourself.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Highlighted
Regular Visitor

Re: How to sent email to group chosen from Form?

Hi Scott

 

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

 

BR

Highlighted
Regular Visitor

Re: How to sent email to group chosen from Form?

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?

Highlighted
Super User III
Super User III

Re: How to sent email to group chosen from Form?

@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?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Regular Visitor

Re: How to sent email to group chosen from Form?

email form 7.PNGCan 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

Highlighted
Super User III
Super User III

Re: How to sent email to group chosen from Form?

@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?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Regular Visitor

Re: How to sent email to group chosen from Form?

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

 

This is the response

Highlighted
Super User III
Super User III

Re: How to sent email to group chosen from Form?

@slavenqx :

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

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Regular Visitor

Re: How to sent email to group chosen from Form?

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.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,308)